Completed
) Create Calendar Table using DAX CALENDAR Table Function
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power BI for Accountants - Complete Introduction to Power BI Desktop to Build Reports & Dashboards
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Download Files
- 2 ) Video Introduction and review of Topics covered in video
- 3 ) Introduction to Power BI Desktop
- 4 ) Overview of process of using Power BI Desktop to build our specific Reports and Dashboards
- 5 ) Open and Save Power BI File
- 6 ) Import Excel dProduct Lookup Tables
- 7 ) Import and Append Multiple Text Files with Sales Data
- 8 ) Clean Data
- 9 ) Discussion of Relationships and why they are important
- 10 ) Create Calendar Table using DAX CALENDAR Table Function
- 11 ) Create Calculated Columns with DAX Functions: MONTH, FORMAT and YEAR
- 12 ) Create Relationships and discuss more about Relationships
- 13 ) Save As to save Power BI File
- 14 ) Create Cross Tabulated Power BI Report
- 15 ) Show Values As % of Column Total
- 16 ) Create Gross Profit Dash Board
- 17 ) DAX Measure for Gross Profit %
- 18 ) Column and Bar Chart as Slicer for Gross Profit Dashboard
- 19 ) Dashboard Interactivity
- 20 ) Add New Data And Watch Dashboard Update
- 21 ) Conclusion & Summary
