Dive into an in-depth 45-minute tutorial on Excel Power Pivot for data modeling, DAX formulas, and dashboard creation. Learn to import SQL big data using Power Query, build a comprehensive data model, and create advanced PivotTables and charts. Master essential concepts like row context, filter context, and the differences between standard and data model PivotTables. Explore practical applications including calculating line revenue, gross profit, and average daily revenue using DAX measures. Follow along with downloadable files to create your own running totals and dashboards, gaining valuable skills in data analysis and business intelligence using Microsoft Excel's powerful tools.
Overview
Syllabus
) Introduction & Over view of entire Big Data & DAX Project..
) Download Files..
) What is a Data Model PivotTable and why Power Pivot is called “Power Pivot”.
) Differences Between Standard PivotTable & Data Model PivotTable.
) Average Daily Reve Example and why DAX is Easier than Standard PivotTable..
) Choice between: Standard PivotTable & Data Model PivotTable.
) What is a SQL Database?.
) Import Big Data from SQL Database using Power Query.
) Load SQL Tables into Columnar Database in Power Pivot’s Data Model.
) How to get into the Data Model. Into to Data Model..
) Create Relationships in Design View.
) What is a Date Table? Create Date Table..
) Hide Column From Client Tool.
) Overview of DAX Formulas.
) DAX Calculated Column for Line Revenue.
) Row Context.
) DAX Measure to add Calculated Column using SUM.
) SUMX DAX Measure to calculate Total Revenue without a Calculated Column..
) Compare and contrast Calculated Column and Measures..
) Create Data Model PivotTable.
) Filter Context.
) Create More DAX Formulas: Total COGS, Gross Profit and Percent Gross Profit..
) Create Dashboard for Gross Profit..
) Create Running Total and Average Daily Revenue DAX Measures and Final Data Model PivotTable..
) Summary.
Taught by
ExcelIsFun
