Completed
) First look at Power Query’s Functional Language: M Code
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel & Power BI Data Analysis Complete Class in One Video
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What is Data Analysis?
- 3 ) Sorting and Filtering. Example 1 & 2
- 4 ) FlashFill. Example 3.
- 5 ) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4.
- 6 ) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5.
- 7 ) First look at Power Query’s Functional Language: M Code
- 8 ) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6.
- 9 ) Excel Line Chart Visualization based on PivotTable
- 10 ) Data Modeling for Examples 7, 8 & 9
- 11 ) XLOOKUP function, PivotTable and Excel Charts to build report and visualization. Example 7.
- 12 ) Power Pivot, Data Model, Relationships and DAX Formulas to build Data Model PivotTable Reports. Power Query to import Excel data. Complete Introduction to Power Pivot. Example 8.
- 13 ) Sort By Column Feature for Data Field in Data Table
- 14 ) Filter Context for DAX Formulas in Data Model
- 15 ) Implicit Measures and Automatic Date Grouping: Dangers of Data Models
- 16 ) Mark As Date Table
- 17 ) Send Data Model to Power BI Desktop to make Interactive & Sharable Dashboard. Example 9.
- 18 ) Complete Introduction to Power BI Desktop, Including how to download free app
- 19 ) Building Interactive Visuals
- 20 ) Stacked Bar/Chart Vs. Clustered Bar/Chart
- 21 ) Complete Introduction Power BI Online and Workspaces to share Power BI Desktop files, Excel files, dashboards and data models easily online.
- 22 ) What is a Dashboard?
- 23 ) Connect to Data Models stored at Power BI Online in Excel and Power BI Desktop
- 24 ) Refresh Excel Power Pivot, Power BI Desktop and Power BI Online when Source Data Changes
- 25 ) Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard. Example 10.
- 26 ) What is a Columnar Database?
- 27 ) Idea behind DAX Revenue Formula (Measure)
- 28 ) Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop
- 29 ) Build DAX Date Table
- 30 ) Row Context in DAX Calculated Columns and DAX Iterator Functions
- 31 ) Hide Fields in Report View
- 32 ) Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions
- 33 ) One-Step DAX Revenue Measure using SUMX DAX function
- 34 ) Compare One-Step and Two-Step Measures. Which is better?
- 35 ) Create four Remaining Measures in Report View
- 36 ) What is Gross Profit? Two Measures for Gross Profit.
- 37 ) Create Two Power BI Reports, including Map Report
- 38 ) Map Visual
- 39 ) Conclusion
- 40 ) Closing and Video Links
