1 ) Files to download 0:07
2 ) Introduction 4:29
3 ) Import Related Tables from Access 0:59
4 ) Edit automatic Relationships Bi-directional Filtering to Single-directional Filtering 1:39
5 ) Import Text Files From Folder 1:13
6 ) Filter out file extensions that are NOT Text .txt 1:01
7 ) Use “Combine Binary” Icon to combine Text Files into one table 1:01
8 ) Look at “Combine Binary”: Query Creation Steps, including M Code and Power Query Function that is automatically created 1:42
9 ) Change Data Types in fSales (Fact Sales) Table 0:59
10 ) edit Relationship between fSales Product Table 0:50
11 ) Create Calendar Table in Excel 4:18
12 ) Create Frequency Distribution Category Table in Excel using Text Formula 3:05
13 ) Import tables from Excel File 1:12
14 ) Manually Create Relationships Between Tables 0:47
15 ) Create DAX Calculated Column for Net Revenue using the RELATED function (works like VLOOKUP Exact Match in Excel) & ROUND function. Net Revenue values are stored in the “In RAM Memory” Data Model 1:59
16 ) Discuss Convention for using Columns in formulas: ALWAYS USE TABLE NAME AND COLUMN/FIELD NAME IN SQUARE BRACKETS 0:43
17 ) Look at How REALTED works across relationships 0:42
18 ) Discussion of Row Context 2:17
19 ) Create Measure for Total Revenue. This Measure is a Measure that is based on values in a Calculated Column 1:49
20 ) Add Number Format to Measure so that every time the Measure is used the Number Format will appear 0:37
21 ) Learn about Measures that are not dependent on Calculated Columns. See how to create Measure that does not use a Calculated Column as a source for values. UseSUMX function 4:46
22 ) Compare creating: 1) Measures based on Calculated Columns and or Measures not based on Calculated 5:59
23 ) Discussion of Filter Context and how it helps DAX formulas calculate Quickly on Big Data. Filter Context: When a Conditions or Criteria are selected from the Lookup Tables (Dimension Tables) they f…
24 ) Discussion of how values created in Calculated Colum are stored in the Data Model Columnar Database and this uses RAM Memory 1:01
25 ) When you must use a Calculated Column: When you need to extend the data set and add a column that has Conditions or Criteria that you want to use to Filter the Data Set 1:11
26 ) Create Calculated Column For COGS using ROUND and RELATED Functions 1:43
27 ) Create Calculated Column for Gross Profit 1:44
28 ) Create Calculated Column on fSales Table that will create the Sales Categories “Retail” or “Wholesale” using IF & OR functions. Because it creates Criteria that will use as Filters for our Measures… 2:24
29 ) Measure for Total COGS 0:35
30 ) Measure for Total Gross Profit 0:43
31 ) Measure for Gross Profit Percentage. This is a Ratio of two numbers. This is an example of a Measure that can ONLY be created as a Measure. It cannot be created as a Measure based on a Calculated C… 1:14
32 ) Discuss Convention for using Measures in other Measures: USE SQUARE BRACKETS ONLY around the Measure name 1:16
33 ) Measure for Average (Mean) Gross Profit 0:27
34 ) Measure for Standard Deviation of the Gross Profit 0:48
35 ) Measure for Coefficient of Variation of the Gross Profit 1:33
36 ) Hide Unnecessary Columns from Report View 0:17
37 ) Sort Month Name Column by Month Number 1:17
38 ) Sort Category Column By Lower Limit 1:05
39 ) Add Data Category Image URL for Image File Paths 1:44
40 ) Create DAX Column to simulate Approximate Match Lookup using the FLOOR function 2:43
41 ) Manually Create Relationship For Category Table 0:23
42 ) Update Excel Table and Test to see if Power BI Report Updates when we Refresh 1:38
43 ) Create Product Analysis Visualization with the first visualization: Create Table with Product Pictures and Metrics. This is Page one of our Power BI Report. 1:15
44 ) Create Bar Chart For Mean and Standard Deviation of Gross Profit 0:25
45 ) Create Slicers to Filter Visualizations 0:31
46 ) Create Frequency Distribution Table & Measure to Count Transactions 1:23
47 ) Format Table, Chart and Slicers 2:09
48 ) Create second Page in Power BI Report with Product Revenue and COGS by Year & Month 1:19
49 ) Publish Power BI Report online 1:31
50 ) Generate Embed code for e-mailing Report and for embedding in web sites 1:00
51 ) Summary