Power Pivot - Big Data, Data Modeling, DAX & Dashboards
Offered By: ExcelIsFun via YouTube
Course Description
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
Related Courses
Web Intelligence and Big DataIndian Institute of Technology Delhi via Coursera Big Data for Better Performance
Open2Study Big Data and Education
Columbia University via edX Big Data Analytics in Healthcare
Georgia Institute of Technology via Udacity Data Mining with Weka
University of Waikato via Independent