Discover how to use Microsoft’s Power BI tools, including Power BI Desktop, Power BI Pro (Service), and Power BI Developer
Learn to achieve your business intelligence goals with Power BI’s comprehensive tools in this video course. Whether you need to analyze data from single or multiple sources, create captivating visualizations, or share results with colleagues, Power BI has you covered.
Starting with the course objectives and an introduction to Power BI Desktop, you’ll explore connecting Power BI to various source types using the Query Editor. Understand the data model and establish relationships between tables. Develop visuals in the report view and efficiently share your work using Power BI Pro. Practical hands-on assignments will reinforce your learning and application of concepts.
Advance your skills by mastering data import from JSON, REST APIs, and MySQL Server. Discover tips to excel in the Power BI world and create custom visuals using TypeScript and Power BI Developer tools. Engage in exciting projects and revise previous topics to solidify your knowledge.
Even if you are a complete beginner, don’t worry! The course includes a brief crash course on Power BI Desktop, making it accessible to all levels of learners.
By the end of this course, you’ll confidently analyze data from various sources, build your datasets, and adeptly navigate the Power BI universe, understanding how its tools synergize. Propel your business intelligence journey with Power BI expertise!
This is the code repository for Microsoft Power BI - A Complete Introduction [Video], published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.
You may use these resources to compare your project state against our project (e.g., to find + fix errors) or to download and view the slides shown in the lectures.
The resources are organized into various branches. Every branch (except for the "main" branch) belongs to a specific course section - the branch name indicates which section it belongs to. For example, the branch 01-getting-started belongs to the first course section "Getting Started".
The "main" branch contains all source files used in the course and the course slides.
Inside the branches for a specific module, you will find the project files for different lectures in the corresponding section.
Section 1: Getting Started
Section 2: Understanding the Power BI Desktop Basics and Preparing the Course Project
Section 3: Data Preparation in the Power Query Editor
Section 4: Data Transformation in the Power Query Editor
Section 5: The Data Model - Working with Relationships and DAX (Data Analysis Expressions)
Section 6: Creating Visuals in the Report View
Section 7: Power BI Pro and Mobile: Sharing and Collaborating with Workspaces and Apps
Section 8: Other Data Sources
Section 9: How to Stay Up-To-Date in the Power BI World
Section 10: Course Round-Up
Section 11: Optional - Power BI Desktop Crash Course (Introduction and Summary)
Section 12: Bonus - Selected Features by Example and Refresher Project
After switching to a specific branch, you will find the project snapshots in this branch.
You can download the files inside a branch via the "Code" button. After reconnecting the .pbix file to the corresponding files in the "source-files" folder in the "main" branch, you can continue working on the project.
More information on how to reconnect the source files after downloading data from GitHub can be found at the end of the first course module.