Completed
) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power BI Desktop - Data Modeling & Interactive Visualizations
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to Power BI and Interactive Visuals
- 2 ) Download Files
- 3 ) Overview of Power BI project
- 4 ) Excel PowerPivot or Power BI Desktop?
- 5 ) Power BI History
- 6 ) Different Versions of Power BI
- 7 ) Download Free Power BI
- 8 ) Open Blank File and name “.pbix” file.
- 9 ) First Look at Power BI Desktop User Interface.
- 10 ) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
- 11 ) Import Dimension tables from single Excel Workbook.
- 12 ) Create Relationships between Dimension & Fact Tables
- 13 ) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,
- 14 ) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.
- 15 ) Hide Tables and Fields that are not used in Reports and Visualizations
- 16 ) Add new Tabs, Sheets, Pages (all synonyms)
- 17 ) Create Gross Profit Interactive Visualization
- 18 ) Create Units Analysis Interactive Visualizations.
- 19 ) Create Hierarchy
- 20 ) Summary