Introduction to Power Query & Power Pivot Data Model in Excel 2016

Learn essential data analysis techniques in Excel 2016 with this comprehensive 50-minute tutorial. Explore Power Query and Power Pivot Data Model functionalities, including cleaning data, creating PivotTable reports, transforming cross-tabulated tables, and importing large datasets. Master the process of refreshing reports with new data and understand the Data Model and Power Pivot concepts through practical examples. Gain insights into handling common errors and follow along with downloadable Excel files for hands-on practice.

Syllabus

) Introduction.
) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016.
) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!.
) Example #2: Transform Cross Tabulated Table into Proper Data Set.
) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report..
) Diagram to understand Data Model and Power Pivot.
) Unhanded Exception Error..
) Summary.