[LEGACY ]Microsoft Power BI - A Complete Introduction
Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Service and Power BI Developer
Watch Promo Enroll in Course
You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?
Then the Power BI tools are the tools to choose for you!
In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.
This is what you will learn:
- Get to know the different tools of the Power BI universe and learn how to use them
- Understand Power BI Desktop and its components
- Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
- How to work in the different views of the Data Model
- How to create calculated columns and measures
- How to build relationships between different tables
- How to create a report with different interactive visualization types
- Learn how to use Power BI Service to create dashboards and to share and publish your results
- How to access your results from multiple devices using Power BI Mobile
- How to create custom visuals using typescript and the Power BI Developer Tools
- And more!
10+
hours
100+
lessons
Course Curriculum
-
PreviewWelcome to this Course! (1:27)
-
PreviewWhat is Power BI? (7:28)
-
PreviewFirst Project 1/3: Installing Power BI Desktop & Source File Connection (11:11)
-
PreviewFirst Project 2/3: Working in the Query Editor (9:19)
-
PreviewFirst Project 3/3: The Data View & Creating our First Visuals (8:11)
-
PreviewCourse Outline - What's Inside the Course? (5:23)
-
PreviewHow to Get the Most out of the Course (3:53)
-
PreviewUseful Resources & Links
-
StartThe Academind Pro Referral Program
-
StartModule Introduction (1:36)
-
StartUsing the Attached Project Files (4:01)
-
StartUnderstanding the Power BI Desktop Workflow (2:34)
-
StartExploring the Data Model Interface (6:05)
-
StartUnderstanding the Query Editor Interface (4:48)
-
StartImportant! Creating the Project File & Recommended Settings (4:10)
-
StartCourse Slides
-
StartUseful Resources & Links
-
StartModule Introduction (1:48)
-
StartConnecting Power BI Desktop to Source Files (7:08)
-
StartKeeping & Removing Rows (6:19)
-
StartWorking with Filters (4:18)
-
StartRemoving Empty Rows (5:08)
-
StartSaving the Project Draft (3:23)
-
StartAppending Queries (7:08)
-
StartWorking with Columns (5:22)
-
StartReplacing Values (5:34)
-
StartFormatting Data & Handling Formatting Errors (8:09)
-
StartPivoting & Unpivoting Data (10:18)
-
StartSplitting Columns (8:15)
-
StartCreating Groups & Cleaning Up our Project (5:16)
-
StartWhat we Achieved & How to Continue (1:04)
-
StartTheory Time: The Star Schema (5:27)
-
StartHow we Use the Star Schema in our Project (2:24)
-
StartQuery Duplicates vs References (7:20)
-
StartCreating the DIM-Region Table & Removing Duplicates (9:33)
-
StartCreating Tables Manually (4:03)
-
StartTheory Time: Merging Queries (5:14)
-
StartUnderstanding "Join Kind" (4:40)
-
StartMerging Queries Applied (7:24)
-
StartFinishing the DIM-Region Table (10:45)
-
StartThe Next Steps (1:05)
-
StartCreating the DIM-Age Table (6:51)
-
StartUnderstanding "Extract" (5:37)
-
StartWorking with Conditional Columns (4:04)
-
StartCreating the FACT-Table (4:46)
-
StartUnderstanding Basic Mathematical Operations (2:04)
-
StartPerformance Optimization (6:50)
-
StartAssignment - Query Editor (Problem) (0:53)
-
StartAssignment - Query Editor (Solution) (10:20)
-
StartWrap Up (2:53)
-
StartUseful Resources & Links
Course Prerequisites
NO prior Power BI knowledge is required
For the majority of the course you must have a computer with Windows as operating system
Basic understanding of data analysis is a plus but not required
For multiple modules of this course a work or school email address is required to sign up
All pre-requisites are covered by courses in our "Academind Pro" Membership.
Don't take my word for it - here's what other students are saying.
SHARIF ALHUMAID
Benefitted a lot from attending this comprehensive course, which deals with data extraction, cleaning and formatting the data, and reporting. It is well paced course, with assignments in between. Also, lecture files are put again, so you can start at any phase without having to start from scratch.
Raghunandan Cumbakonam
The content was very well laid out and the concepts were explained in detail. The demos were easier to follow along and the exercises really helped to put the learning to test.
Sbongile Sibiya
Easy to follow, the definitions of the terms were explained very well. I was able to follow with each lecture, the course just made learning power bi super easy.
30 Day Money Back Guarantee - No Questions Asked!
Our courses helped thousands of students learn something new and improve their lives.
We're so convinced by our course quality that we guarantee your success and provide a full refund within the first 30 days if you're not happy with the course.
Your Instructor
Having worked as a business analyst in both a major consultancy and an investment bank, I always found myself confronted with both various and complex problem sets and challenging client demands. The rapid development of technology and business requirements forces everyone to constantly adapt and to continue learning.
Since I always found it hard to find high quality, understandable and comprehensive learning materials, I decided to create such materials on my own. Together with Maximilian Schwarzmüller I founded Academind to offer the best possible learning experience on web development and data science to our more than 1,000,000 students worldwide.
Frequently Asked Questions
Join 10052 happy students!
Single-Course License
Full access to "[LEGACY ]Microsoft Power BI - A Complete Introduction"
$99
Access to this course only.
This is a one-time payment that grants access to this course only, not to any other courses.
Academind Pro Membership
Unlimited access to this and all other current & future courses!