Power BI Desktop - Data Modeling & Interactive Visualizations

Power BI Desktop - Data Modeling & Interactive Visualizations

ExcelIsFun via YouTube Direct link

) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.

14 of 20

14 of 20

) 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. 1 ) Introduction to Power BI and Interactive Visuals
  2. 2 ) Download Files
  3. 3 ) Overview of Power BI project
  4. 4 ) Excel PowerPivot or Power BI Desktop?
  5. 5 ) Power BI History
  6. 6 ) Different Versions of Power BI
  7. 7 ) Download Free Power BI
  8. 8 ) Open Blank File and name “.pbix” file.
  9. 9 ) First Look at Power BI Desktop User Interface.
  10. 10 ) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
  11. 11 ) Import Dimension tables from single Excel Workbook.
  12. 12 ) Create Relationships between Dimension & Fact Tables
  13. 13 ) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,
  14. 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. 15 ) Hide Tables and Fields that are not used in Reports and Visualizations
  16. 16 ) Add new Tabs, Sheets, Pages (all synonyms)
  17. 17 ) Create Gross Profit Interactive Visualization
  18. 18 ) Create Units Analysis Interactive Visualizations.
  19. 19 ) Create Hierarchy
  20. 20 ) Summary

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.