Completed
) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
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
