Data Analysis and Visualization with Power BI

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

Access provided by Inter IKEA

132,133 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

994 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

994 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

What you'll learn

How to add visualizations to reports and dashboards.
How to design accessible reports and dashboards.
How to use visualizations to perform data analysis.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

26 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

Build your Data Analysis expertise

This course is part of the Microsoft Power BI Data Analyst Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 5 modules in this course

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI.

In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. You will explore how to get a statistical summary for your data and how to create and export reports in Power BI. You will also perform advanced analytics in Power BI to get deeper and more meaningful data insights. After completing this course, you'll be able to: ● Recognize the different types of visualizations in Power BI ● Add visualizations to reports and dashboards ● Apply formatting choices to visuals ● Add useful navigation techniques to the Power BI report ● Design accessible reports and dashboards ● Use visualizations to perform data analysis This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

In this module, you'll be introduced to using visualization and reports in Microsoft Power BI to present data to stakeholders.

What's included

15 videos24 readings6 assignments2 discussion prompts

15 videos Total 95 minutes

Analysis for Business Intelligence 7 minutes
What are visualizations? 7 minutes
Common visualizations 7 minutes
Creating a basic report 7 minutes
Table visualization 5 minutes
Bar and column charts 7 minutes
Line and area charts 7 minutes
Combo charts 6 minutes
Pie and donut charts 6 minutes
Treemaps 6 minutes
Displaying Key Performance Indicators 5 minutes
Ribbon and waterfall charts 6 minutes
Funnel charts 6 minutes
Scatter charts 8 minutes
Module summary: Creating Reports 5 minutes

24 readings Total 260 minutes

Course syllabus 10 minutes
How to be successful in this course 10 minutes
How to open an image in a new tab 10 minutes
Setting up your Power BI environment 10 minutes
Setting up Power BI Service 10 minutes
New name for Power BI datasets 10 minutes
Business intelligence cheatsheet 10 minutes
How to locate your downloaded files 10 minutes
Additional resources: Key concepts 5 minutes
Explore business report types 10 minutes
Report Editor in Power BI 10 minutes
Visualizations pane 10 minutes
Exercise: Create a sales report 30 minutes
Exemplar: Create a sales report 10 minutes
Pinning visualizations 10 minutes
Additional resources: Introducing Visualizations 5 minutes
Activity: Using bars, columns, and lines 10 minutes
Activity: Enhance the report with brand information 10 minutes
Targeted use of charts 10 minutes
Additional resources: Basic Visualizations 5 minutes
Exercise: Indicating business performance 30 minutes
Exemplar: Indicating business performance 10 minutes
Matrix visualization 10 minutes
Additional resources: Specialist Visualizations 5 minutes

6 assignments Total 94 minutes

Module quiz: Creating Reports 30 minutes
Self-review: Create a sales report 9 minutes
Knowledge check: Introducing Visualizations 15 minutes
Knowledge check: Basic Visualizations 15 minutes
Self-review: Indicating business performance 10 minutes
Knowledge check: Specialist Visualizations 15 minutes

2 discussion prompts Total 20 minutes

Discussion prompt: What do you hope to learn? 10 minutes
How would visualizing data help in business scenarios? 10 minutes

In this module, you will discover how to improve accessibility and user experience in reports.

What's included

15 videos10 readings5 assignments1 discussion prompt

15 videos Total 90 minutes

Accessibility in reports 7 minutes
Formatting and configuring visualizations 7 minutes
Conditional formatting 6 minutes
Working with themes 6 minutes
Adding custom tooltips 7 minutes
Report hierarchies 7 minutes
Report drillthrough 5 minutes
Sorting and filtering data in reports 7 minutes
Cross-filter and cross-highlight 6 minutes
Adding slicers 7 minutes
Adding buttons 5 minutes
Adding bookmarks 5 minutes
Group and layer visuals 5 minutes
DAX filter context in visualizations 6 minutes
Module summary: Navigation and Accessibility 6 minutes

10 readings Total 125 minutes

Design best practices 10 minutes
Activity: Creating an accessible report 30 minutes
Activity: Improving accessibility with tooltips 10 minutes
Additional resources: Designing an Accessible Report 5 minutes
Activity: Sorting and filtering a report 10 minutes
Additional resources: Report Navigation and Filtering 5 minutes
Adding URLs 10 minutes
Exercise: Creating an interactive report 30 minutes
Exemplar: Creating an interactive report 10 minutes
Additional resources: Interactive Report 5 minutes

5 assignments Total 85 minutes

Module quiz: Navigation and Accessibility 30 minutes
Knowledge check: Designing an Accessible Report 15 minutes
Knowledge check: Report Navigation and Filtering 15 minutes
Self-review: Creating an interactive report 10 minutes
Knowledge check: Interactive Report 15 minutes

1 discussion prompt Total 10 minutes

What type of reports will you create for the different types of users that you interact with? 10 minutes

In this module, you'll be introduced to dashboards and how they differ from reports, as well as publishing and exporting reports.

What's included

11 videos13 readings7 assignments1 discussion prompt

11 videos Total 71 minutes

What is a dashboard? 6 minutes
Creating a dashboard 5 minutes
Improving usability in dashboards 6 minutes
Limitations of pinned visuals 6 minutes
Publishing reports 4 minutes
Pagination and exporting reports 4 minutes
Introduction to the Performance Analyzer 6 minutes
Resolving performance issues in DAX 8 minutes
Using variables for performance 8 minutes
Using variables for troubleshooting 8 minutes
Module summary: Bringing Data to the User 8 minutes

13 readings Total 180 minutes

Activity: Preparing a simple workspace 10 minutes
Exercise: Building a dashboard 30 minutes
Exemplar: Building a dashboard 10 minutes
Additional resources: Creating Dashboards 5 minutes
Report page properties 10 minutes
Exercise: Sharing a report 30 minutes
Exemplar: Sharing a report 10 minutes
Activity: Analyze in Excel 10 minutes
Additional resources: Sharing with Stakeholders 10 minutes
Tuning report performance 10 minutes
Exercise: Improving DAX performance 30 minutes
Exemplar: Improving DAX performance 10 minutes
Additional resources: Optimizing Reports 5 minutes

7 assignments Total 105 minutes

Module quiz: Bringing Data to the User 30 minutes
Self-review: Building a dashboard 10 minutes
Knowledge check: Creating Dashboards 15 minutes
Self-review: Sharing a report 10 minutes
Knowledge check: Sharing with Stakeholders 15 minutes
Self-review: Improving DAX performance 10 minutes
Knowledge check: Optimizing Reports 15 minutes

1 discussion prompt Total 10 minutes

How will you use Power BI to share your data effectively? 10 minutes

In this module, you'll be introduced to data analysis. You'll explore how to use visualizations and AI in Microsoft Power BI to perform an analysis of data.

What's included

13 videos14 readings6 assignments1 discussion prompt

13 videos Total 79 minutes

Statistical summary 7 minutes
Introduction to analytics 7 minutes
Group and bin data for analysis 7 minutes
Histograms and Top N 7 minutes
Clustering techniques 7 minutes
Continuous and categorical axes 6 minutes
Using the Analyze feature 6 minutes
Conducting a time series analysis 6 minutes
Creating reference lines 7 minutes
Forecasting 6 minutes
Key Influencers 5 minutes
Decomposition trees 6 minutes
Module summary: Identifying Patterns and Trends 4 minutes

14 readings Total 185 minutes

Statistics cheatsheet 10 minutes
Activity: Performing an analysis 10 minutes
Additional resources: Perform Analytics in Power BI 5 minutes
Time series analysis 10 minutes
Activity: Using the Play Axis visualization 30 minutes
Error bars 10 minutes
Exercise: Explaining the increase 30 minutes
Exemplar: Explaining the increase 10 minutes
Activity: Forecasting sales 10 minutes
Additional resources: Analytical Tools in Power BI 5 minutes
Q&A visualization 10 minutes
Exercise: Root cause analysis 30 minutes
Exemplar: Root cause analysis 10 minutes
Additional resources: Working with AI Visuals 5 minutes

6 assignments Total 102 minutes

Module quiz: Identifying Patterns and Trends 30 minutes
Knowledge check: Perform Analytics in Power BI 15 minutes
Self-review: Explaining the increase 12 minutes
Knowledge check: Analytical Tools in Power BI 15 minutes
Self-review: Root cause analysis 15 minutes
Knowledge check: Working with AI Visuals 15 minutes

1 discussion prompt Total 10 minutes

How will you use data visualization to bring your data to life? 10 minutes

In this module, you will be assessed on the key skills covered in the Course. This module provides a summary of the course and reflects on the primary learning objectives. The module also contains the project for the course which encapsulates the learning into a practical whole.

What's included

1 video3 readings2 assignments1 discussion prompt

1 video Total 7 minutes

Course recap: Data Analysis and Visualization with Power BI 7 minutes

3 readings Total 50 minutes

About the final project and assessment: Data Analysis and Visualization with Power BI 10 minutes
Exercise: Adventure Works executive summary 30 minutes
Exemplar: Adventure Works executive summary 10 minutes