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
- And more!
PreviewWelcome to This Course (0:55)
PreviewWhat is Power BI? (5:46)
PreviewInstalling Power BI Desktop (3:33)
PreviewConnecting Power BI Desktop to Source Files (8:46)
PreviewCreating our First Visuals (7:34)
PreviewComparing Excel & Power BI (3:20)
PreviewCourse Outline (5:30)
StartThe Two Ways (Paths) Of Taking This Course (2:22)
PreviewHow to Get the Most Out of This Course (3:14)
PreviewImportant: How to Access Course Resources, Project Files & Slides (9:48)
StartModule Introduction (1:12)
StartUnderstanding Data Preparation / Cleaning / Cleansing (4:50)
StartConnecting Power BI Desktop to Source Files (10:35)
StartHow Power BI Queries Data (5:00)
StartUnderstanding Basic Row Operations (9:07)
StartFiltering Data (5:59)
StartAnalyzing Columns & Removing Blank Fields (10:59)
StartUnderstanding & Using the Append Feature (8:27)
StartChoosing & Removing Columns (7:05)
StartAppend Behind the Scenes (2:50)
StartUnderstanding the Transpose Feature (2:58)
StartReplacing Values (7:35)
StartWorking with Dates - The Basics (6:50)
StartUnderstanding Data Formats (5:50)
StartHandling Data Format Errors (8:18)
StartUnderstanding Pivoting & Unpivoting (4:30)
StartApplying Pivoting & Unpivoting (3:55)
StartFixing a Sorting Problem (2:11)
StartExtracting Data, Splitting Columns & Sorting Multiple Columns (9:24)
StartIntroducing the "Group By" Feature (4:20)
StartImproving the Project Structure (3:16)
StartWrap Up (3:06)
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.
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.
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.
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.
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 3853 happy students!
Full access to "Microsoft Power BI - The Practical Guide"
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!