Главная
Study mode:
on
1
) Introduction & Overview of Topics in Two Hour Video
2
) Standard PivotTable or Data Model PivotTable?
3
) Excel Power Pivot & Power BI Desktop?
4
) Power Query to Extract, Transform and Load Data to Data Model – Get data from Text Files, Relational Database and Excel File.
5
) Build Relationships
6
) Introduction to DAX Formulas: Measures & Calculated Columns
7
) DAX Calculated Column using the DAX Functions, RELATED and ROUND
8
) Row Context: How DAX Calculated Columns are Calculated: Row Context
9
) We do not want to use Calculated Column results in PivotTable using Implicit Measures
10
) DAX Measure to add results from Calculated Column, using DAX SUM Function.
11
) Number Formatting for DAX Measures
12
) Data Model PivotTable
13
) Explicit DAX Formulas rather than Implicit DAX Formulas
14
) Show Implicit Measures
15
) Filter Context (First Look) How DAX Measures are Calculated
16
) Drag Columns from Fact Table or Dimension Table?
17
) Hiding Columns and Tables from Client Tool
18
) Use Power Query to Refine Data Model
19
) SUMX Function (Iterator Function). DAX Measure for Revenue using the SUMX Function to simulate Calculated Columns in DAX Measures
20
) Compare and Contrast Calculated Columns & Measures
21
) Why We Need a Date Table. Why we do NOT use the Automatic Grouping Feature for a Data Model PivotTable
22
) Build an Automatic Date Table in Excel Power Pivot. And then build Relationship.
23
) Introduction to Time Intelligence DAX Functions. See TOTALYTD DAX Function
24
) Context Transition and the Hidden CALCULATE on all Measures.
25
) DAX Formula Benefits.
26
) Example of DAX Formula that is easier to author than if we tried to do it with a Standard Pivot Table or Array Formulas
27
) AVERAGEX Function (Iterator Function) to calculate Average Daily Revenue.
28
) Filter Context (Second Look) AVERAGEX Iterator Function
29
) Build Dashboard. Create multiple DAX Formulas. Create Multiple Data Model PivotTables and a Data Model Chart.
30
) Create Measures for Gross Profit and Gross Profit %
31
) Continue making more Data Model PivotTables.
32
) Make Data Model Pivot Chart.
33
) Conditional Formatting for Data Model PivotTable.
34
) DAX Text Formula for title of Dashboard
35
) CUBE Function to Convert Data Model PivotTable to Excel Spreadsheet Formulas.
36
) Adding New Data and Refreshing.
37
) Update Excel Power Pivot Automatic Date (Calendar) Table. Clue is the blank in the Dimension Table Filter.
38
) How to Double Check that a DAX Formula is yielding the correct answer?
39
) DAX Table Functions. See CALCULATETABLE DAX Function.
40
) DAX Studio to visualize DAX Table Functions, and to efficiently create DAX Formulas
41
) Existing Connections to import data from Data Model into an Excel Sheet
42
) Summary
Description:
Dive into a comprehensive 2-hour video tutorial on Excel Power Pivot, DAX formulas, and functions. Learn to extract, transform, and load data using Power Query, build relationships, create calculated columns and measures, and understand row and filter contexts. Master DAX functions like SUMX, AVERAGEX, and CALCULATE while exploring time intelligence and table functions. Develop practical skills in building dashboards, creating pivot tables and charts, and using conditional formatting. Gain insights into data modeling best practices, including the importance of date tables and efficient formula authoring. Utilize tools like DAX Studio for visualization and formula creation. By the end, you'll have a solid foundation in Power Pivot and DAX, enabling you to create powerful data models and analyses in Excel.

Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

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

) Introduction & Overview of Topics in Two Hour Video