Big Data Analysis and Dashboards with Microsoft Excel for Business Analysis Course

This Big Data Analysis and Dashboards with Microsoft Excel for Buisness Analysis Course Contents

DAY ONE

• Pivot Table
  • Default Pivot Table
  • Tabular Pivot Table
  • Pivot Table Filtering
  • Making a very dynamic regular table from Pivot Table
  • Calculations and Formula use with Pivot Table
  • Advanced Pivot Table tricks.
• PowerPivot for Data Mining (Excel 2013 or 2010 with PowerPivot Addin)
  • Working with data of over 2 million rows
  • Connecting with multiple sources of data
  • DAX formulas
  • Most popular PowerPivot Analysis.

• PowerQuery
  • Understanding what PowerQuery is
  • Simple practical uses
  • Using it to connect to third party data sources (your ERP or Database).
• PowerView
  • Understanding what PowerView is
  • Simple practical uses.
• Power Map
  • Plotting your data on a live map that can be zoomed and rotated
  • Special amazing use of the Power Map.
• Charting Large Data
  • Understanding the principles that guide visualizing large data
  • Making charts that bring insights to a large data
  • Building a large data dashboard.

DAY TWO

• Making Professional Reports in Excel and Dashboards
  • Linking sheets
  • Duplicating sheets (better than copy and paste)
  • Inserting sheets, labeling and coloring the professional way
  • Freezing Panes and splitting windows
  • Conditional formatting
• To identify patterns
• Using formulae
• To make extremely intelligent reports
• Absolute and Relative Cell addressing to make effective formulas
• Dashboards
• Having the audience/recipient in mind
• E-mails and Excel reports.

DAY THREE

• Excel to PowerPoint
  • Linking PowerPoint Charts to Excel
  • Embedding Excel sheets in PowerPoint
  • Making a Powerful PowerPoint Presentation.
• Excel to Word

• Mail Merge: Sending a personalized mail to a list of people
• Linking PowerPoint Charts to Excel
• Embedding Excel sheets in Word
• Copying tables and content from Excel to Word, the right way.