Главная
Study mode:
on
1
) Introduction & Over view of entire Big Data & DAX Project.
2
) Download Files.
3
) What is a Data Model PivotTable and why Power Pivot is called “Power Pivot”
4
) Differences Between Standard PivotTable & Data Model PivotTable
5
) Average Daily Reve Example and why DAX is Easier than Standard PivotTable.
6
) Choice between: Standard PivotTable & Data Model PivotTable
7
) What is a SQL Database?
8
) Import Big Data from SQL Database using Power Query
9
) Load SQL Tables into Columnar Database in Power Pivot’s Data Model
10
) How to get into the Data Model. Into to Data Model.
11
) Create Relationships in Design View
12
) What is a Date Table? Create Date Table.
13
) Hide Column From Client Tool
14
) Overview of DAX Formulas
15
) DAX Calculated Column for Line Revenue
16
) Row Context
17
) DAX Measure to add Calculated Column using SUM
18
) SUMX DAX Measure to calculate Total Revenue without a Calculated Column.
19
) Compare and contrast Calculated Column and Measures.
20
) Create Data Model PivotTable
21
) Filter Context
22
) Create More DAX Formulas: Total COGS, Gross Profit and Percent Gross Profit.
23
) Create Dashboard for Gross Profit.
24
) Create Running Total and Average Daily Revenue DAX Measures and Final Data Model PivotTable.
25
) Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Intelligence #Microsoft Power BI #Data Science #Big Data #Data Analysis #DAX (Data Analysis Expressions) #Programming #Databases #Database Design #Data Modeling #DAX Formulas #Spreadsheets #PivotTables
0:00 / 0:00
1 of 25

) Introduction & Over view of entire Big Data & DAX Project.