Downloadable Materials

January 27, 2020

For each lesson of this course, you will find a .zip file containing useful files for your Power BI journey. There will be a Power BI file (.pbix) for use at the start of each lesson and a file containing the finished solution following lesson completion. These are good resources to have. You can challenge yourself by trying to use your personal Power BI file continuously throughout the course, knowing that you can always start fresh with the PBIX file from the downloadable materials!

Syllabus

Introduction
- Power BI Beginner Course Outline
- Sneak Peek of Finished Product
- A Tour of Power BI
- Installing Power BI Desktop
- Downloadable Materials
Building Your First Report
- Getting Data from SQL Server Database
- Editing Data with Power Query
- Creating Relationships Between Tables
- Visualizing Data
Report Design Basics
- Report Styling Basics
- Conditional Formatting
- Editing Interactions
- Themes
Advanced Analysis with DAX
- Calculated Columns
- Introduction to Measures
- Advanced Measures
- DAX Functions Reference
Publishing to Power BI Service
- Creating a Power BI Account
- Setting up a Workspace and Publishing
- 4 Ways to Share Reports
- Setting Up Automatic Data Refreshes
- Subscriptions
- Dashboards vs Reports
Final Words
- Congratulations and Next Steps
- Course Feedback