Completed
) Why the From Folder Power Query option when you have Excel files is more complicated than when you have Text files
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Data Analysis - Power BI Desktop, DAX Formulas, Relationships, Data Modeling & Visuals
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Intro & Overview
- 2 ) Look at data for project
- 3 ) Look at New Power BI file and tour of Power BI user interface
- 4 ) Power Query to import two tables from one Excel file
- 5 ) Import and append data from multiple Excel files
- 6 ) Why the From Folder Power Query option when you have Excel files is more complicated than when you have Text files
- 7 ) Power Query Excel.Workbook function to get Objects from an Excel file, using a Custom Column
- 8 ) Append all tables from Excel files
- 9 ) Using Locale Data Type feature to match imported dates with Regional Settings on Computer. Allows any country to use any other country’s dates and number settings
- 10 ) Close & Apply Fact Table to Data Model and watch Relationships that are automatically created
- 11 ) Create Date or Calendar Table using DAX Table functions. CALENDAR function. Also see DATE, YEAR, MIN and MAX functions
- 12 ) Definition of Date Table
- 13 ) Mark Date Table as a Date Table
- 14 ) Create DAX Calculated Columns in the Date Table for Month, Month Number and Year
- 15 ) Row Context in a Calculated Column
- 16 ) FORMAT function to create Month Name
- 17 ) Sort BY Column feature to get Month Names to sort correctly
- 18 ) Create Relationship for Date field
- 19 ) Create Date Table with GENERATE and ROW functions. See variables and fiscal period formulas in this DAX Table Function. Amazing formula!!!!
- 20 ) Create Total Sales Measure in Data View (Table View) using the SUMX & RELATED functions
- 21 ) Measure Icons in Power BI and Power Pivot
- 22 ) Create Measures in Report View on a Test Measure Page
- 23 ) Matrix Visualization is VERY similar to a PivotTable!
- 24 ) First look at the Format area and the Paint Roller option
- 25 ) Move Totals from Top to Bottom
- 26 ) Total Units Measure
- 27 ) Frequency Measure with COUNTROWS function
- 28 ) EOMONTH function in DAX Calculated Column in Date Table
- 29 ) Why we need EOMONTH function for accurate average monthly sales formula
- 30 ) Average Monthly Sales Measure with AVERAGEX, VALUES function
- 31 ) YOY % Change DAX Measure using Variables, CALCULATE, SAMEPERIODLASTYEAR, IF and HASONEVALUES DAX functions
- 32 ) Introduction to ALL and ALLEXCEPT DAX functions
- 33 ) % of Sales Grand Total Measure using CALCULATE, DIVIDE and ALL DAX functions.
- 34 ) Why ALL on Fact Table removes all filters in the Data Model
- 35 ) % of Year Sales Measure using CALCULATE, DIVIDE and ALLEXCEPT, IF and HASONEVALUE DAX functions
- 36 ) Hide fields in tables from the Report View
- 37 ) What Relationships do
- 38 ) Visualizations in Power BI
- 39 ) Create Year Month Total Sales Matrix and Line Chart
- 40 ) Turn off concatenated
- 41 ) Measures in Tooltips
- 42 ) Edit Visualization Title, especially when you use Tooltips
- 43 ) Amazing Filter Pane in Power BI!
- 44 ) Edit Interactions between visualizations for Matrix and Line Chart
- 45 ) Drill Up, Drill Down, and move to a new Level
- 46 ) What Line Charts do
- 47 ) What is a Dashboard? Define Dashboard and what a Dashboard is in Online Power BI
- 48 ) Create Year Metric “Dashboard” on a Page in a Power BI Desktop Report file
- 49 ) What Tables or Matrix visuals do that is different than a chart or other visuals
- 50 ) What Column and Bar Charts do = Compare differences across categories.
- 51 ) Difference between the Clustered Column/Bar and the Stacked Column/Bar
- 52 ) Moving Visualizations
- 53 ) Add Data Labels
- 54 ) Edit Interactions between visualizations for Matrix and Column or Bar Chart: Filtered, Highlight or No Filter
- 55 ) Publish Power BI Report to Power BI Online
- 56 ) Hide Measure Page
- 57 ) What is a Workspace?
- 58 ) Open Power BI Online
- 59 ) Tour of Power BI Online
- 60 ) Sharing reports and dashboards with Power BI Online
- 61 ) Build a new Workspace
- 62 ) Create a report from a dataset
- 63 ) One Source of Truth Data Sets for Excel PivotTable
- 64 ) Creating Dashboards in Power BI Online, including sharing a dashboard
- 65 ) Add new Excel and update
- 66 ) Summary
- 67 ) What’s in next video
