~Get Your Files Here !/06 - Common DAX Formulas & Functions/021 DAX Demo Time Intelligence Formulas.mp4 139.2 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/007 DAX Demo Logical Functions (IFANDOR).mp4 126.0 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/007 Power Query Demo Text Tools.mp4 84.7 MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/011 Step-by-Step DAX Measure Calculation.mp4 80.6 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/009 DAX Demo Common Text Functions.mp4 79.1 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/011 DAX Demo CALCULATE.mp4 79.0 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/013 DAX Demo Adding Filter Context with FILTER (Part 2).mp4 77.6 MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/005 Understanding DAX Calculated Columns.mp4 74.7 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/005 DAX Demo COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp4 69.0 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/017 Power Query Demo Connecting to a Folder of Files.mp4 68.1 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/008 Power Query Demo Number & Value Tools.mp4 66.6 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/006 Applying Basic Table Transformations with Power Query.mp4 63.6 MB
~Get Your Files Here !/02 - Intro to “Power Excel/002 Power Query + Power Pivot Best Thing to Happen to Excel in 20 Years.mp4 62.4 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/015 Merging Queries with Power Query.mp4 60.7 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/004 DAX Demo Basic Math & Stats Functions.mp4 58.1 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/017 DAX Demo Iterating with SUMX.mp4 55.1 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/013 Power Query Demo Pivoting & Unpivoting Data.mp4 54.1 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/011 Power Query Demo Generating Index & Conditional Columns.mp4 51.4 MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/020 DAX Demo Basic Date & Time Functions.mp4 47.2 MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/009 Power Query Demo Date & Time Tools.mp4 45.5 MB
~Get Your Files Here !/2. Module 2 Automating Reports using Pivot Table/2. Creating Income Statement & Balance Sheet Using Pivot Table Method - Part 2.mp4 255.1 MB
~Get Your Files Here !/2. Module 2 Automating Reports using Pivot Table/1. Creating Income Statement & Balance Sheet Using Pivot Table Method.mp4 207.2 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/11. Creating Notes To The Accounts Sales & COGS - Part 2.mp4 194.4 MB
~Get Your Files Here !/4. Module 4 Managing Future Years Data/1. Updating Year 4 Data To Financial Statement - Part 1.mp4 194.3 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/7. Creating Notes To The Accounts Fixed Assets & Depreciation - Part 3.mp4 183.1 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/1. Creating Income Statement & Balance Sheet Using Formula Method - Part 1.mp4 180.4 MB
~Get Your Files Here !/1. Module 1 Data Manipulation/2. Load & Transform Data Trial Balance – 3 Years Data.mp4 150.5 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/10. Creating Notes To The Accounts Sales & COGS - Part 1.mp4 129.6 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/5. Creating Notes To The Accounts Fixed Assets & Depreciation - Part 1.mp4 127.6 MB
~Get Your Files Here !/1. Module 1 Data Manipulation/5. Load & Transform Data Date Map.mp4 126.7 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/4. Creating Cash Flow Statement - Indirect Method Using Formula Method - Part 2.mp4 120.2 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/8. Creating Notes To The Accounts Loan Calculation - Part 1.mp4 118.2 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/9. Creating Notes To The Accounts Loan Calculation - Part 2.mp4 114.0 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/2. Creating Income Statement & Balance Sheet Using Formula Method - Part 2.mp4 92.6 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/3. Creating Cash Flow Statement - Indirect Method Using Formula Method - Part 1.mp4 88.6 MB
~Get Your Files Here !/1. Module 1 Data Manipulation/3. Load & Transform Data GL Map.mp4 84.8 MB
~Get Your Files Here !/4. Module 4 Managing Future Years Data/2. Updating Year 4 Data To Financial Statement - Part 2.mp4 65.1 MB
~Get Your Files Here !/1. Module 1 Data Manipulation/4. Merge Query GL Map To TB_3Yr.mp4 58.7 MB
~Get Your Files Here !/1. Module 1 Data Manipulation/6. Merge Query Date Map To TB_3Yr.mp4 53.9 MB
~Get Your Files Here !/3. Module 3 Automating Reports using Functions and Formula/6. Creating Notes To The Accounts Fixed Assets & Depreciation - Part 2.mp4 26.8 MB
~Get Your Files Here !/5. Summary and final test/2. SELECT course final test answers.mp4 163.7 MB
~Get Your Files Here !/2. Downloading and installing the required software and data/4. Option 1 - Install AdventureWorks from a backup.mp4 85.7 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/4. FROM Clause - Test Answers.mp4 81.2 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/27. GROUP BY Clause - Test Answers.mp4 75.4 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/3. FROM clause - Demonstration.mp4 67.1 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/7. WHERE Clause - Part 1 - Demonstration.mp4 60.6 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/22. JOIN Clause - Part 2 - Joining multiple tables - Test Answers.mp4 59.1 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/13. WHERE Clause - Test Answers.mp4 54.1 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/18. JOIN Clause - Part 1 - Demonstration.mp4 45.6 MB
~Get Your Files Here !/2. Downloading and installing the required software and data/5.1 00 - create database and tables V1.sql 44.1 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/19. JOIN Clause - Part 1 - Test Answers.mp4 40.9 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/8. A Note about Dates.mp4 39.6 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/12. WHERE Clause - Part 3 - Combining clauses - Demonstration.mp4 37.4 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/16. ORDER BY Clause - Test Answers.mp4 37.1 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/1. SELECT clause - Introduction and Demonstration.mp4 36.3 MB
~Get Your Files Here !/2. Downloading and installing the required software and data/2. Download and Install SQL Server Management Studio (SSMS).mp4 34.8 MB
~Get Your Files Here !/2. Downloading and installing the required software and data/1. Download and Install SQL Server Express.mp4 33.6 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/15. ORDER BY Clause - Demonstration.mp4 33.6 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/17. JOIN Clause - Part 1 - Introduction.mp4 32.9 MB
~Get Your Files Here !/4. SQL Server SELECT query foundations/30. HAVING Clause - Test Answers.mp4 32.1 MB