Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Power Pivot - Big Data, Data Modeling, DAX & Dashboards

ExcelIsFun via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course teaches how to use Excel Power Pivot for Data Modeling, DAX Formulas, and creating Dashboards. The learning outcomes include importing Big Data, building Data Models, creating PivotTables and Charts, and understanding DAX Formulas. The course covers topics such as SQL Database import, creating Relationships, Date Tables, and various DAX calculations. The teaching method involves practical demonstrations and step-by-step instructions. The intended audience for this course is individuals interested in Data Analysis and Business Intelligence using Microsoft Power Tools.

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

Reviews

Start your review of Power Pivot - Big Data, Data Modeling, DAX & Dashboards

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.