1 ) Intro 0:37
2 ) Overview of data and visuals we will do in Power BI 1:26
3 ) Overview of SQL data and reports we will build in Power Pivot 0:52
4 ) Start of Power BI Big Data CSV file Example 0:13
5 ) Download 911 Seattle data from web site: https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj 0:43
6 ) Power Query to Import and transform csv file 0:33
7 ) Data Source Settings 0:44
8 ) Data Modeling in Power Query: create foreign key columns in Fact Table 2:11
9 ) Remove fields not needed to make Columnar Database smaller. 0:46
10 ) Close and Apply data to Data Model 0:21
11 ) Create Date and Time Dimension Tables 0:10
12 ) copy GENERATE and ROW DAX Formula from last video to create the Data Table. 1:06
13 ) GENERATESERIES DAX Function to create Hour Dimension Table 0:40
14 ) Create Serial Number Time DAX Calculated Field 0:22
15 ) Create Hour DAX Calculated Field 0:37
16 ) Sort Hour Field by Hour ID field 0:09
17 ) Sort Month Name in Data Table by Date field 0:07
18 ) Set Hour field to NOT sum 0:06
19 ) Create Relationships 0:21
20 ) Hide fields 0:11
21 ) Mark data table as Date Table 0:24
22 ) Create DAX Measure for counting using COUNTROWS DAX Function. 0:59
23 ) Hide Foreign keys in Fact Table 0:30
24 ) Create Table Visuals to show counts 0:35
25 ) Sort fields in tables 0:29
26 ) Add Slicers 0:27
27 ) Create a Card Visual to show Measure result 1:28
28 ) Understanding Filter Context 1:11
29 ) Create DAX Measure for % of Grand Total using CALCULATE, ALL & DIVIDE functions 2:50
30 ) () Create DAX Measure for % of Filtered Grand Total using CALCULATE, ALLSELECTED and DIVIDE functions 0:35
31 ) Difference between ALL and ALLSELECTED DAX functions 1:02
32 ) “See” Filtered Total created by ALLSELECTED function 1:29
33 ) Create MAP Visual to show location of 911 calls 1:45
34 ) Create Word Cloud 0:59
35 ) ArcGIS Time Movie Map Visual 1:50
36 ) Update when new data arrives 0:28
37 ) Power BI Project conclusion 0:53
38 ) Start of Power Pivot Big Data SQL Database Example 0:06
39 ) Reporting Goal explained 0:16
40 ) SQL Database explained 0:35
41 ) Look at tables and data for project 0:45
42 ) Credentials to connect to the SQL Database 1:35
43 ) Navigator dialog box 0:32
44 ) Power Query Editor for the three SQL tables 0:18
45 ) Extra Columns from related tables 1:11
46 ) Look at Fact Table and adjust Data Types, including “Using Locale” option for dates with different settings 0:57
47 ) View Native Query inside Power Query Applied Steps to see which steps are sent back to SQL database (folding) 1:21
48 ) Load tables to Power Pivot Data Model’s Columnar Database 1:27
49 ) Create Power Pivot Date Table 2:03
50 ) Create Relationships 0:32
51 ) Create DAX Measures 0:16
52 ) Compare DAX Calculated Columns to DAX Measures. 1:03
53 ) Total Revenue Measure using SUMX DAX function 0:42
54 ) What is Revenue Discount? How to use in formula? 1:12
55 ) Use Filter Dropdown to see a unique list 0:32
56 ) What is Net Standard Cost, or Net Cost Equivalent? How to use in formula? 1:13
57 ) Total COGS Measure using SUMX DAX function 1:09
58 ) Gross Profit ($) DAX Measure 0:37
59 ) Gross Profit % DAX Measure 0:36
60 ) Average Daily Gross Profit DAX Measure. Discuss Pre-aggregating at the day grain before averaging the daily totals 1:49
61 ) Why are $ signs in Measure name, rather than using Number Formatting with dollar signs? 0:31
62 ) Hide Fields from Client Tool 0:33
63 ) Build Data Model PivotTable Gross Profit Report 0:47
64 ) Add Slicer to Data Model PivotTable 0:23
65 ) Create Line Chart to show Gross Profit over Year and Month 1:05
66 ) Create Custom Number Format in Chart 0:39
67 ) Change Chart type from Column to Line 0:13
68 ) Add series of numbers to Secondary Axis 0:12
69 ) Connect Chart to Slicer with Report Connections 0:27
70 ) Power Pivot Project Conclusion 0:21
71 ) Conclusion for whole video (both movies)