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

YouTube

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

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 provides a comprehensive introduction to Excel Power Pivot, DAX Formulas, and DAX Functions. By the end of the course, learners will be able to build relationships, create DAX formulas for measures and calculated columns, understand row and filter context, utilize iterator functions like SUMX and AVERAGEX, and build dashboards with multiple data model PivotTables and charts. The teaching method includes video lectures and hands-on practice with downloadable Excel files. This course is intended for individuals interested in mastering advanced data analysis techniques in Excel using Power Pivot and DAX formulas.

Syllabus

) Introduction & Overview of Topics in Two Hour Video.
) Standard PivotTable or Data Model PivotTable?.
) Excel Power Pivot & Power BI Desktop?.
) Power Query to Extract, Transform and Load Data to Data Model – Get data from Text Files, Relational Database and Excel File..
) Build Relationships.
) Introduction to DAX Formulas: Measures & Calculated Columns.
) DAX Calculated Column using the DAX Functions, RELATED and ROUND.
) Row Context: How DAX Calculated Columns are Calculated: Row Context.
) We do not want to use Calculated Column results in PivotTable using Implicit Measures.
) DAX Measure to add results from Calculated Column, using DAX SUM Function..
) Number Formatting for DAX Measures.
) Data Model PivotTable.
) Explicit DAX Formulas rather than Implicit DAX Formulas.
) Show Implicit Measures.
) Filter Context (First Look) How DAX Measures are Calculated.
) Drag Columns from Fact Table or Dimension Table?.
) Hiding Columns and Tables from Client Tool.
) Use Power Query to Refine Data Model.
) SUMX Function (Iterator Function). DAX Measure for Revenue using the SUMX Function to simulate Calculated Columns in DAX Measures.
) Compare and Contrast Calculated Columns & Measures.
) Why We Need a Date Table. Why we do NOT use the Automatic Grouping Feature for a Data Model PivotTable.
) Build an Automatic Date Table in Excel Power Pivot. And then build Relationship..
) Introduction to Time Intelligence DAX Functions. See TOTALYTD DAX Function.
) Context Transition and the Hidden CALCULATE on all Measures..
) DAX Formula Benefits..
) Example of DAX Formula that is easier to author than if we tried to do it with a Standard Pivot Table or Array Formulas.
) AVERAGEX Function (Iterator Function) to calculate Average Daily Revenue..
) Filter Context (Second Look) AVERAGEX Iterator Function.
) Build Dashboard. Create multiple DAX Formulas. Create Multiple Data Model PivotTables and a Data Model Chart..
) Create Measures for Gross Profit and Gross Profit %.
) Continue making more Data Model PivotTables..
) Make Data Model Pivot Chart..
) Conditional Formatting for Data Model PivotTable..
) DAX Text Formula for title of Dashboard.
) CUBE Function to Convert Data Model PivotTable to Excel Spreadsheet Formulas..
) Adding New Data and Refreshing. .
) Update Excel Power Pivot Automatic Date (Calendar) Table. Clue is the blank in the Dimension Table Filter..
) How to Double Check that a DAX Formula is yielding the correct answer?.
) DAX Table Functions. See CALCULATETABLE DAX Function..
) DAX Studio to visualize DAX Table Functions, and to efficiently create DAX Formulas.
) Existing Connections to import data from Data Model into an Excel Sheet.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

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.