Power Query and Power Pivot

Learning Unit 1: About Power Query

Understand and Learn to use Power Query to automate data preparation tasks like:

• Get Data from multiple sources such as Different Worksheets and/or Different Workbooks, Text File, Web Data, etc.
• Combine Data into One Worksheet either by Appending data or Merging data.
• Clean and transform data e.g handling missing values, merging columns, etc. so the data is suitable for analysis.

Learning Unit 2: About Power Pivot

Understand and Learn to use Power Pivot to better analyse data by creating :

• Data Model & Table Relationship for Linking Excel Tables.
• Pivot Report with Data Model that enables user to produce insightful summary
• Report from multiple Excel Tables.
• Powerful DAX Formula and KPI which are new methods of analysing data.