Microsoft Excel Business Intelligence w Power Query & DAX

Files Included :

1 - Course Structure Outline.mp4 (42 MB)
MP4
2 - IMPORTANT Versions Compatibility.mp4 (19.96 MB)
MP4
4 - Introducing the Course Project.mp4 (4.58 MB)
MP4
6 - Setting Expectations.mp4 (6.84 MB)
MP4
7 - Understanding the Power Excel Workflow.mp4 (13.56 MB)
MP4
8 - Power Query Power Pivot Best Thing to Happen to Excel in 20 Years.mp4 (67.57 MB)
MP4
9 - When to use Power Query Power Pivot.mp4 (2.23 MB)
MP4
11 - Introduction.mp4 (2.69 MB)
MP4
12 - Getting to Know Power Query in Excel.mp4 (11.64 MB)
MP4
13 - Exploring Excels Power Query Editor.mp4 (17.67 MB)
MP4
14 - Power Query Data Loading Options.mp4 (4.57 MB)
MP4
16 - Applying Basic Table Transformations with Power Query.mp4 (102.14 MB)
MP4
17 - Power Query Demo Text Tools.mp4 (135.89 MB)
MP4
18 - Power Query Demo Number Value Tools.mp4 (99.63 MB)
MP4
19 - Power Query Demo Date Time Tools.mp4 (71.45 MB)
MP4
20 - PRO TIP Creating a Rolling Calendar with Power Query.mp4 (18.61 MB)
MP4
21 - Power Query Demo Generating Index Conditional Columns.mp4 (82.44 MB)
MP4
22 - Power Query Demo Grouping Aggregating Records.mp4 (40.12 MB)
MP4
23 - Power Query Demo Pivoting Unpivoting Data.mp4 (63.48 MB)
MP4
24 - Modifying Excel Workbook Queries.mp4 (26.72 MB)
MP4
25 - Merging Queries with Power Query.mp4 (91.31 MB)
MP4
26 - Appending Queries with Power Query.mp4 (49.14 MB)
MP4
27 - Power Query Demo Connecting to a Folder of Files.mp4 (99.66 MB)
MP4
28 - PRO TIP Additional Data Connectors Excel MySQL PDF Web.mp4 (41.53 MB)
MP4
29 - Excel Power Query Best Practices.mp4 (9.74 MB)
MP4
31 - Introduction.mp4 (2.81 MB)
MP4
32 - Meet Excels Data Model.mp4 (29.36 MB)
MP4
34 - Principles of Database Normalization.mp4 (16.59 MB)
MP4
35 - Understanding Data Tables vs Lookup Tables.mp4 (30.87 MB)
MP4
36 - Benefits of Relationships vs Merged Tables.mp4 (8.53 MB)
MP4
37 - Creating Table Relationships in Excels Data Model.mp4 (30.74 MB)
MP4
38 - Modifying Data Model Table Relationships.mp4 (11.13 MB)
MP4
39 - Managing Active vs Inactive Table Relationships.mp4 (17.4 MB)
MP4
40 - Understanding Relationship Cardinality.mp4 (24.43 MB)
MP4
41 - Connecting Multiple Data Tables in the Data Model.mp4 (42.1 MB)
MP4
42 - Understanding Filter Flow.mp4 (18.66 MB)
MP4
43 - Hiding Fields from Excel Client Tools.mp4 (17.01 MB)
MP4
44 - Defining Hierarchies in a Data Model.mp4 (12.7 MB)
MP4
45 - Excel Data Model Best Practices.mp4 (4.21 MB)
MP4
47 - Introduction.mp4 (4.32 MB)
MP4
48 - Creating a Power Pivot Table.mp4 (24.84 MB)
MP4
49 - Power Pivots vs Normal Pivots in Excel.mp4 (13.31 MB)
MP4
50 - Introducing Data Analysis Expressions DAX.mp4 (4.16 MB)
MP4
51 - Understanding DAX Calculated Columns.mp4 (112.6 MB)
MP4
52 - Understanding DAX Measures.mp4 (7.05 MB)
MP4
53 - Creating Implicit DAX Measures.mp4 (7.04 MB)
MP4
54 - Creating Explicit DAX Measures with AutoSum.mp4 (56.23 MB)
MP4
55 - Creating Explicit DAX Measures with Power Pivot.mp4 (50.67 MB)
MP4
56 - Understanding DAX Filter Context.mp4 (54.19 MB)
MP4
57 - StepbyStep DAX Measure Calculation.mp4 (117.81 MB)
MP4
58 - RECAP Calculated Columns vs DAX Measures.mp4 (7.4 MB)
MP4
59 - Excel Power Pivot DAX Best Practices.mp4 (5.6 MB)
MP4
61 - Introduction.mp4 (2.67 MB)
MP4
62 - Understanding DAX Formula Syntax Operators.mp4 (13.56 MB)
MP4
63 - Common DAX Function Categories.mp4 (12.77 MB)
MP4
64 - DAX Demo Basic Math Stats Functions.mp4 (81.18 MB)
MP4
65 - DAX Demo COUNT COUNTA DISTINCTCOUNT COUNTROWS.mp4 (100.76 MB)
MP4
67 - DAX Demo Logical Functions IFANDOR.mp4 (185.17 MB)
MP4
68 - DAX Demo SWITCH SWITCHTRUE.mp4 (61.28 MB)
MP4
69 - DAX Demo Common Text Functions.mp4 (115.94 MB)
MP4
71 - DAX Demo CALCULATE.mp4 (115.44 MB)
MP4
72 - DAX Demo Adding Filter Context with FILTER Part 1.mp4 (49.7 MB)
MP4
73 - DAX Demo Adding Filter Context with FILTER Part 2.mp4 (109.34 MB)
MP4
74 - DAX Demo Removing Filter Context with ALL.mp4 (54.67 MB)
MP4
76 - DAX Demo Joining Data with RELATED.mp4 (18.25 MB)
MP4
77 - DAX Demo Iterating with SUMX.mp4 (78.81 MB)
MP4
78 - DAX Demo Iterating with RANKX.mp4 (64.34 MB)
MP4
80 - DAX Demo Basic Date Time Functions.mp4 (66.63 MB)
MP4
81 - DAX Demo Time Intelligence Formulas.mp4 (156.2 MB)
MP4
83 - DAX Speed Performance Considerations.mp4 (10.74 MB)
MP4
84 - DAX Best Practices.mp4 (5.66 MB)
MP4
85 - Introduction.mp4 (5.25 MB)
MP4
86 - Data Visualization Options in Excel.mp4 (13.22 MB)
MP4
87 - Sneak Peek Microsoft Power BI.mp4 (25.28 MB)
MP4