Главная
Study mode:
on
1
) Introduction to Entire Project, including what type of start files we have and what the final report looks like.
2
) What is Data Modeling? Steps to creating a Data Model.
3
) Data Modeling Step 1: Power Query to Clean, Transform & Import Fact Tables
4
) Data Modeling Step 1: Import Dimension Tables from an Excel Sheet
5
) What is a Calendar Table (Dimension Table)? Why a Calendar Table and not Group by Date?
6
) Data Modeling Step 1: Create Calendar Table in Excel & Import to Data Model
7
) Data Modeling Step 2: Create Relationships between Related Tables
8
) Data Modeling Step 3: Create DAX Calculated Columns in Calendar Table. Dee the DAX functions: MONTH, FORMAT, YEAR, ROUNDUP, and IF. See how to calculate Calculated Columns for Month Number, Month N…
9
) What is Row Context?
10
) Data Modeling Step 3: Create DAX Calculated Columns in Fact Table for Revenue. See the functions ROUND, RELATED
11
) Data Modeling Step 3: Create DAX Measures using SUM function n to add values from Calculated Column.
12
) Data Modeling Step 3: Alternative Total Revenue Calculation: DAX Measure with SUMX. Learn how to perform Row Context in a DAX Measure. This formula calculates total revenue without a Helper Column.
13
) DAX Calculated Column or DAX Measure to calculate Total Revenue?
14
) Data Modeling Step 3: More DAX Measures. SUMX to calculate Total COGS. DAX Measure for Gross Profit.
15
) Data Modeling Step 4: Hide Tables & Fields not used in PivotTables
16
) Data Modeling Step 5: Create PivotTables and Pivot Charts and Final Dashboard
17
) What is Filter Context?
18
) Advantage of Power Pivot Data Model Columnar Database & Relationships & DAX Measures when you have Big Data.
19
) Data Modeling Step 6: Refresh Data Model when Source Data Changes
20
) Data Modeling Step 7: Fix Calendar Table
21
) Data Modeling Step 7: Dashboard After Refreshing
22
) Data Modeling Step 7: Create new DAX Formulas and create New Report.
Description:
Dive into an extensive Excel 2016 tutorial focused on building data models and creating DAX formulas in Power Pivot. Learn the step-by-step process of data modeling, from importing and cleaning data using Power Query to creating relationships between tables. Master DAX functions like MONTH, FORMAT, YEAR, ROUNDUP, and IF to create calculated columns in calendar tables. Explore the concepts of row context and filter context, and understand when to use DAX calculated columns versus DAX measures. Discover how to create PivotTables, Pivot Charts, and build a final dashboard. Gain insights into the advantages of Power Pivot's columnar database for handling big data. Practice refreshing data models, fixing calendar tables, and creating new DAX formulas for advanced reporting. This comprehensive guide covers everything from basic data modeling steps to advanced DAX techniques, providing a solid foundation for Excel power users and aspiring data analysts.

How to Build Data Model and DAX Formulas in Power Pivot

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Business Intelligence #DAX (Data Analysis Expressions) #Programming #Databases #Database Design #Data Modeling #Spreadsheets #Pivot Tables #Pivot Charts #Power Pivot #DAX Formulas
0:00 / 0:00
1 of 22

) Introduction to Entire Project, including what type of start files we have and what the final report looks like.