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