Microsoft Power BI Desktop - The Practical Bootcamp

4 days left! Gain next-level skills with Coursera Plus for $199 (regularly $399). Save now.

Microsoft Power BI Desktop - The Practical Bootcamp

Instructor: Nikolai Schuler

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Create impressive reports with Power BI
Master Power BI Desktop from end-to-end
Transform data and create a data model in Power BI Desktop

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

✓ Master Power BI Desktop from end-to-end

✓ Create impressive reports with Power BI ✓ Work professionally with Power BI Microsoft Power BI Desktop is the perfect tool for creating impressive reports, and this course will teach you everything you need to know to become an advanced report creator. Whether you're new to Power BI or already have some basic knowledge, this course will help you dive deeper into the universe of Power BI and gain a thorough understanding of the software. Throughout the course, you will learn how to connect different data sources, create your data model, and use all the important tools properly. You'll also learn how to effectively visualize your data through storytelling with data and create interactive visualizations with drill throughs and drill downs. In addition, this course covers advanced analytics such as forecasting, which can be helpful in data science. If you're struggling to get on track with Power BI, this course offers practical techniques to help you master tough subjects. If you're already an expert, you'll find ideas for turbocharging successful learning. Enroll now to gain lifelong access to this course and become an advanced report developer in Power BI.

In this module, we will download and install Power BI Desktop. We will set everything up, and get to know Power BI Desktop.

What's included

10 videos1 assignment

10 videos Total 46 minutes

Welcome to Power BI! 0 minutes
What is Power BI? 3 minutes
Download & Install Power BI Desktop 4 minutes
Quick Interface Tour 5 minutes
Transform Data 9 minutes
Visualize Data 6 minutes
Data Modeling 8 minutes
Roadmap of this course 3 minutes
Create initial project file 4 minutes
Working with attached project files 4 minutes

1 assignment Total 1 minute

Working with the attached .pbix files 1 minute

In this module, you will learn how to transform data in Power BI by using the Power Query Editor.

What's included

25 videos2 readings2 assignments

25 videos Total 167 minutes

Exploring the Query Editor 6 minutes
Connecting to data source 7 minutes
Editing rows 8 minutes
Changing data types 8 minutes
Replacing values 3 minutes
Close & Apply 3 minutes
Connect to a csv file 3 minutes
Connect to web page 5 minutes
Extracting characters 6 minutes
Splitting & merging columns 9 minutes
Creating conditional columns 6 minutes
Creating columns from examples 9 minutes
Merging Queries 17 minutes
Pivoting & Unpivoting 6 minutes
Appending Queries 8 minutes
Practice: Data Transformation 15 minutes
Fact-Dimension-Model 9 minutes
Practice: Dimension table 4 minutes
Organizing queries in groups 3 minutes
Enter data manually 5 minutes
Create index column 3 minutes
More transformations 5 minutes
Module Summary 5 minutes
Data Transformation Practice 2 minutes
Data Transformation Solution 11 minutes

2 readings Total 20 minutes

Note regarding next lecture 10 minutes
Text to be used in next video 10 minutes

2 assignments Total 6 minutes

Query Editor 3 minutes
Data Transformation 3 minutes

In this module, you will learn more advanced data transformations in Power BI by using the Power Query Editor. These advanced transformation tools include the advanced editor, performance optimization, and transforming data dynamically using parameters.

What's included

8 videos

In this module, you will learn how to create a data model in Power BI. You will learn why it is important and everything about creating and managing relationships in the data model.

What's included

9 videos1 assignment

9 videos Total 44 minutes

Why do we need a data model? 5 minutes
Create and edit relationships 6 minutes
One-to-many & one-to-one relationships 6 minutes
Many-to-Many relationship 8 minutes
Cross filter direction 6 minutes
Activate & deactivate relationships 6 minutes
Module summary 3 minutes
Practice: Data Modeling 2 minutes
Solution: Data Modeling 2 minutes

1 assignment Total 5 minutes

Data Model 5 minutes

In this module, you will learn about how to create dashboards, how to create visualizations, and format those visualizations in Power BI.

What's included

28 videos

28 videos Total 175 minutes

First visual 8 minutes
Formatting a visual 12 minutes
Understanding Tables 10 minutes
Conditional formatting 9 minutes
Pie Chart 6 minutes
Slicer visual 13 minutes
Filter pane 9 minutes
Cross filtering & edit interactions 4 minutes
Practice Data Visualization 1 minute
Solution Data Visualization 6 minutes
Sync slicers 7 minutes
Creating drill downs 8 minutes
Creating drill throughs 7 minutes
Tree map visual 7 minutes
Decomposition tree 5 minutes
Matrix visual 5 minutes
Editing pages 7 minutes
Buttons & actions 9 minutes
Bookmarks to customize report 10 minutes
Analytics with line charts 10 minutes
Visualization best practices 1 minute
Empathy 3 minutes
Most suitable KPI 2 minutes
Most effective visual 4 minutes
Natural reading patterns 3 minutes
Visual cues and storytelling 5 minutes
Avoid chaos & group information 2 minutes
Summary 2 minutes

Instructor

Instructor ratings

(6 ratings)

Nikolai Schuler

4 Courses 5,600 learners

Offered by

Nikolai Schuler

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.