Filename Size 1. Getting Started/1. Welcome to this Course.mp4 11.2 MB 1. Getting Started/1. Welcome to this Course.vtt 3.2 KB 1. Getting Started/2. Understanding the Power BI Tools.mp4 12.2 MB 1. Getting Started/2. Understanding the Power BI Tools.vtt 8.5 KB 1. Getting Started/3. Join our Online Learning Community.html 731 B 1. Getting Started/4. Initial Project 13 Installing Power BI Desktop and Connecting to Data.mp4 77 MB 1. Getting Started/4. Initial Project 13 Installing Power BI Desktop and Connecting to Data.vtt 8.3 KB 1. Getting Started/5. Important The Locale Used in This Course.html 1.3 KB 1. Getting Started/6. Initial Project 23 Working in the Query Editor.mp4 107.3 MB 1. Getting Started/6. Initial Project 23 Working in the Query Editor.vtt 8.5 KB 1. Getting Started/7. Initial Project 33 Working in the Data Model and Creating a Visualization.mp4 19.4 MB 1. Getting Started/7. Initial Project 33 Working in the Data Model and Creating a Visualization.vtt 7.6 KB 1. Getting Started/8. Course Outline.mp4 4.4 MB 1. Getting Started/8. Course Outline.vtt 3.8 KB 1. Getting Started/9. How to use the Attached Project Files.mp4 5.8 MB 1. Getting Started/9. How to use the Attached Project Files.vtt 3.9 KB 2. An Introduction to Power BI Desktop/1. An Overview of the Workflow in Power BI Desktop.mp4 5 MB 2. An Introduction to Power BI Desktop/1. An Overview of the Workflow in Power BI Desktop.vtt 3.1 KB 2. An Introduction to Power BI Desktop/2. Introducing the Different Views of the Data Model.mp4 16.5 MB 2. An Introduction to Power BI Desktop/2. Introducing the Different Views of the Data Model.vtt 9 KB 2. An Introduction to Power BI Desktop/2.1 01-01-Project-GDP-Finished.zip.zip 148 KB 2. An Introduction to Power BI Desktop/3. Taking a Closer Look at the Query Editor Interface.mp4 16.4 MB 2. An Introduction to Power BI Desktop/3. Taking a Closer Look at the Query Editor Interface.vtt 4.9 KB 2. An Introduction to Power BI Desktop/4. Important! Before we Dive Deeper Required Power BI Settings.mp4 7 MB 2. An Introduction to Power BI Desktop/4. Important! Before we Dive Deeper Required Power BI Settings.vtt 3.8 KB 2. An Introduction to Power BI Desktop/5. Course Slides.html 282 B 2. An Introduction to Power BI Desktop/5.1 power-bi-complete-guide-slides.pdf.pdf 154.1 KB 3. An Introduction to the Query Editor/1. Just to be sure What is the Query Editor.mp4 6.8 MB 3. An Introduction to the Query Editor/1. Just to be sure What is the Query Editor.vtt 4.1 KB 3. An Introduction to the Query Editor/10. Splitting Columns.mp4 7.9 MB 3. An Introduction to the Query Editor/10. Splitting Columns.vtt 3.8 KB 3. An Introduction to the Query Editor/11. Creating a New Group for our Queries.mp4 3.3 MB 3. An Introduction to the Query Editor/11. Creating a New Group for our Queries.vtt 1.7 KB 3. An Introduction to the Query Editor/12. What we Achieved until Now and How to Continue.mp4 1.3 MB 3. An Introduction to the Query Editor/12. What we Achieved until Now and How to Continue.vtt 847 B 3. An Introduction to the Query Editor/13. Introducing the Star Schema.mp4 19.4 MB 3. An Introduction to the Query Editor/13. Introducing the Star Schema.vtt 7.7 KB 3. An Introduction to the Query Editor/14. Duplicating and Referencing Queries.mp4 7.4 MB 3. An Introduction to the Query Editor/14. Duplicating and Referencing Queries.vtt 4.4 KB 3. An Introduction to the Query Editor/14.1 03-02-Project-Population-After Groups.zip.zip 36.6 MB 3. An Introduction to the Query Editor/15. Creating the DIM Region Table.mp4 16.1 MB 3. An Introduction to the Query Editor/15. Creating the DIM Region Table.vtt 9.1 KB 3. An Introduction to the Query Editor/15.1 03-02.01-Project-Population-After Creating DIM Region.zip.zip 36.4 MB 3. An Introduction to the Query Editor/16. Entering Data Manually.mp4 7.5 MB 3. An Introduction to the Query Editor/16. Entering Data Manually.vtt 4.5 KB 3. An Introduction to the Query Editor/16.1 03-02.02-Project-Population-After Entering Data Manually.zip.zip 36.4 MB 3. An Introduction to the Query Editor/17. Merging Queries.mp4 20.4 MB 3. An Introduction to the Query Editor/17. Merging Queries.vtt 13.2 KB 3. An Introduction to the Query Editor/17.1 03-02.03-Project-Population-After Merging Queries.zip.zip 36.4 MB 3. An Introduction to the Query Editor/18. Finishing the DIM Region Table.mp4 19 MB 3. An Introduction to the Query Editor/18. Finishing the DIM Region Table.vtt 11.2 KB 3. An Introduction to the Query Editor/18.1 03-02.04-Project-Population-After Finishing DIM Region.zip.zip 36.4 MB 3. An Introduction to the Query Editor/19. Introducing the DIM AgeGroup Table.mp4 1.9 MB 3. An Introduction to the Query Editor/19. Introducing the DIM AgeGroup Table.vtt 1.3 KB 3. An Introduction to the Query Editor/2. Before we Start - About the Attached Project Files.html 1.4 KB 3. An Introduction to the Query Editor/20. Creating an Index Column.mp4 8.2 MB 3. An Introduction to the Query Editor/20. Creating an Index Column.vtt 4.7 KB 3. An Introduction to the Query Editor/21. Duplicating Columns and Extracting Information.mp4 12 MB 3. An Introduction to the Query Editor/21. Duplicating Columns and Extracting Information.vtt 7 KB 3. An Introduction to the Query Editor/22. Creating Conditional Columns.mp4 8.1 MB 3. An Introduction to the Query Editor/22. Creating Conditional Columns.vtt 4.6 KB 3. An Introduction to the Query Editor/23. Creating the FACT Population Table.mp4 10.3 MB 3. An Introduction to the Query Editor/23. Creating the FACT Population Table.vtt 5.3 KB 3. An Introduction to the Query Editor/24. Performing Basic Mathematical Operations.mp4 4.1 MB 3. An Introduction to the Query Editor/24. Performing Basic Mathematical Operations.vtt 2.4 KB 3. An Introduction to the Query Editor/25. Improving Performance and Loading Data into the Data Model.mp4 35.9 MB 3. An Introduction to the Query Editor/25. Improving Performance and Loading Data into the Data Model.vtt 12.2 KB 3. An Introduction to the Query Editor/26. Module Summary.mp4 1.2 MB 3. An Introduction to the Query Editor/26. Module Summary.vtt 795 B 3. An Introduction to the Query Editor/26.1 03-03-Project-Population-Module-Finished.zip.zip 17.9 MB 3. An Introduction to the Query Editor/27. Time to Practice - Query Editor.html 141 B 3. An Introduction to the Query Editor/28. [OPTIONAL] Assignment Instructions.html 375 B 3. An Introduction to the Query Editor/28.1 Assignment-01-01-Start.zip.zip 81.6 KB 3. An Introduction to the Query Editor/29. [OPTIONAL] Assignment Solution.mp4 129.2 MB 3. An Introduction to the Query Editor/29. [OPTIONAL] Assignment Solution.vtt 11.1 KB 3. An Introduction to the Query Editor/29.1 Assignment-01-02-Solution.zip.zip 149 KB 3. An Introduction to the Query Editor/3. Connecting Power BI Desktop to our Data Sources.mp4 18.8 MB 3. An Introduction to the Query Editor/3. Connecting Power BI Desktop to our Data Sources.vtt 6.1 KB 3. An Introduction to the Query Editor/3.1 03-01-Project-Population-Start.zip.zip 9 MB 3. An Introduction to the Query Editor/4. Editing Rows.mp4 38 MB 3. An Introduction to the Query Editor/4. Editing Rows.vtt 12.8 KB 3. An Introduction to the Query Editor/4.1 03-01-00-Project-Population-After-Rows.zip.zip 27.4 MB 3. An Introduction to the Query Editor/5. Understanding Append Queries.mp4 13.4 MB 3. An Introduction to the Query Editor/5. Understanding Append Queries.vtt 7.2 KB 3. An Introduction to the Query Editor/5.1 03-01-01-Project-Population-After-Append.zip.zip 43.5 MB 3. An Introduction to the Query Editor/6. Editing Columns.mp4 11.5 MB 3. An Introduction to the Query Editor/6. Editing Columns.vtt 6.4 KB 3. An Introduction to the Query Editor/7. Replacing Values.mp4 7.3 MB 3. An Introduction to the Query Editor/7. Replacing Values.vtt 3.5 KB 3. An Introduction to the Query Editor/7.1 03-01-02-Project-Population-After-Replace.zip.zip 43.5 MB 3. An Introduction to the Query Editor/8. Formatting Data.mp4 14.1 MB 3. An Introduction to the Query Editor/8. Formatting Data.vtt 7.1 KB 3. An Introduction to the Query Editor/8.1 03-01-03-Project-Population-After-Formatting.zip.zip 43.1 MB 3. An Introduction to the Query Editor/9. Pivoting and Unpivoting Columns.mp4 10.6 MB 3. An Introduction to the Query Editor/9. Pivoting and Unpivoting Columns.vtt 5.1 KB 4. Working on our Data Model Data & Relationship View/1. Module Introduction.mp4 1.2 MB 4. Working on our Data Model Data & Relationship View/1. Module Introduction.vtt 883 B 4. Working on our Data Model Data & Relationship View/10. M vs. DAX Conclusion.mp4 1.9 MB 4. Working on our Data Model Data & Relationship View/10. M vs. DAX Conclusion.vtt 1.4 KB