Data Analysis and Visualization with Power BI

Data Analysis and Visualization with Power BI

This course is part of multiple programs.

Instructor: Microsoft

Access provided by Amgen

146,452 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

1,037 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.

1,037 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 subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

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

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.

This module introduces core reporting capabilities in Microsoft Power BI, focusing on selecting and building appropriate visualizations for data representation. You will learn to create, customize, and organize reports using various chart types, apply formatting, and design visuals that effectively communicate insights to stakeholders.

What's included

15 videos20 readings6 assignments

15 videosTotal 95 minutes

Analysis for Business Intelligence7 minutes
What are visualizations?7 minutes
Common visualizations7 minutes
Creating a basic report7 minutes
Table visualization5 minutes
Bar and column charts7 minutes
Line and area charts7 minutes
Combo charts6 minutes
Pie and donut charts6 minutes
Treemaps6 minutes
Displaying Key Performance Indicators5 minutes
Ribbon and waterfall charts6 minutes
Funnel charts6 minutes
Scatter charts8 minutes
Module summary: Creating Reports5 minutes

20 readingsTotal 230 minutes

Course syllabus10 minutes
Setting up your Power BI environment20 minutes
Setting up Power BI Service10 minutes
Business intelligence cheatsheet10 minutes
Additional resources: Key concepts5 minutes
Explore business report types10 minutes
Report Editor in Power BI10 minutes
Visualizations pane10 minutes
Exercise: Create a sales report30 minutes
Exemplar: Create a sales report10 minutes
Pinning visualizations10 minutes
Additional resources: Introducing Visualizations5 minutes
Activity: Using bars, columns, and lines10 minutes
Activity: Enhancing the Report with a Product Category Breakdown10 minutes
Targeted use of charts10 minutes
Additional resources: Basic Visualizations5 minutes
Exercise: Indicating business performance30 minutes
Exemplar: Indicating business performance10 minutes
Matrix visualization10 minutes
Additional resources: Specialist Visualizations5 minutes

6 assignmentsTotal 94 minutes

Module quiz: Creating Reports30 minutes
Self-review: Create a sales report9 minutes
Knowledge check: Introducing Visualizations15 minutes
Knowledge check: Basic Visualizations15 minutes
Self-review: Indicating business performance10 minutes
Knowledge check: Specialist Visualizations15 minutes

This module focuses on enhancing user experience by designing accessible, interactive, and easy-to-navigate reports. You will apply formatting techniques, implement filters, slicers, and drill through features, and use navigation tools like bookmarks and buttons to create intuitive and user-friendly reporting experiences.

What's included

15 videos10 readings5 assignments1 discussion prompt

15 videosTotal 90 minutes

Accessibility in reports7 minutes
Formatting and configuring visualizations7 minutes
Conditional formatting6 minutes
Working with themes6 minutes
Adding custom tooltips7 minutes
Report hierarchies7 minutes
Report drillthrough5 minutes
Sorting and filtering data in reports7 minutes
Cross-filter and cross-highlight6 minutes
Adding slicers7 minutes
Adding buttons5 minutes
Adding bookmarks5 minutes
Group and layer visuals5 minutes
DAX filter context in visualizations6 minutes
Module summary: Navigation and Accessibility6 minutes

10 readingsTotal 125 minutes

Design best practices10 minutes
Activity: Creating an accessible report30 minutes
Activity: Improving accessibility with tooltips10 minutes
Additional resources: Designing an Accessible Report5 minutes
Activity: Sorting and filtering a report10 minutes
Additional resources: Report Navigation and Filtering5 minutes
Adding URLs10 minutes
Exercise: Creating an interactive report30 minutes
Exemplar: Creating an interactive report10 minutes
Additional resources: Interactive Report5 minutes

5 assignmentsTotal 85 minutes

Module quiz: Navigation and Accessibility30 minutes
Knowledge check: Designing an Accessible Report15 minutes
Knowledge check: Report Navigation and Filtering15 minutes
Self-review: Creating an interactive report10 minutes
Knowledge check: Interactive Report15 minutes

1 discussion promptTotal 10 minutes

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

This module explores how to deliver insights effectively through dashboards and sharing mechanisms. You will learn to design dashboards, publish and export reports, and optimize performance using tools like DAX tuning and performance analyzer, ensuring efficient and scalable data delivery to stakeholders.

What's included

11 videos13 readings7 assignments1 discussion prompt

11 videosTotal 71 minutes

What is a dashboard?6 minutes
Creating a dashboard5 minutes
Improving usability in dashboards6 minutes
Limitations of pinned visuals6 minutes
Publishing reports4 minutes
Pagination and exporting reports4 minutes
Introduction to the Performance Analyzer6 minutes
Resolving performance issues in DAX8 minutes
Using variables for performance8 minutes
Using variables for troubleshooting8 minutes
Module summary: Bringing Data to the User8 minutes

13 readingsTotal 180 minutes

Activity: Preparing a simple workspace10 minutes
Exercise: Building a dashboard30 minutes
Exemplar: Building a dashboard10 minutes
Additional resources: Creating Dashboards5 minutes
Report page properties10 minutes
Exercise: Sharing a report30 minutes
Exemplar: Sharing a report10 minutes
Activity: Analyze in Excel10 minutes
Additional resources: Sharing with Stakeholders10 minutes
Tuning report performance10 minutes
Exercise: Improving DAX performance30 minutes
Exemplar: Improving DAX performance10 minutes
Additional resources: Optimizing Reports5 minutes

7 assignmentsTotal 105 minutes

Module quiz: Bringing Data to the User30 minutes
Self-review: Building a dashboard10 minutes
Knowledge check: Creating Dashboards15 minutes
Self-review: Sharing a report10 minutes
Knowledge check: Sharing with Stakeholders15 minutes
Self-review: Improving DAX performance10 minutes
Knowledge check: Optimizing Reports15 minutes

1 discussion promptTotal 10 minutes

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

This module introduces analytical capabilities in Power BI, enabling you to derive insights from data using statistical summaries, clustering, and time-series analysis. You will also leverage AI-powered visuals such as key influencers and decomposition trees to uncover patterns, trends, and root causes in data.

What's included

13 videos14 readings6 assignments1 discussion prompt

13 videosTotal 79 minutes

Statistical summary7 minutes
Introduction to analytics7 minutes
Group and bin data for analysis7 minutes
Histograms and Top N7 minutes
Clustering techniques7 minutes
Continuous and categorical axes6 minutes
Using the Analyze feature6 minutes
Conducting a time series analysis6 minutes
Creating reference lines7 minutes
Forecasting6 minutes
Key Influencers5 minutes
Decomposition trees6 minutes
Module summary: Identifying Patterns and Trends4 minutes

14 readingsTotal 185 minutes

Statistics cheatsheet10 minutes
Activity: Performing an analysis10 minutes
Additional resources: Perform Analytics in Power BI5 minutes
Time series analysis10 minutes
Activity: Using the Play Axis visualization30 minutes
Error bars10 minutes
Exercise: Explaining the increase30 minutes
Exemplar: Explaining the increase10 minutes
Activity: Forecasting sales10 minutes
Additional resources: Analytical Tools in Power BI5 minutes
Q&A visualization10 minutes
Exercise: Root cause analysis30 minutes
Exemplar: Root cause analysis10 minutes
Additional resources: Working with AI Visuals5 minutes

6 assignmentsTotal 102 minutes

Module quiz: Identifying Patterns and Trends30 minutes
Knowledge check: Perform Analytics in Power BI15 minutes
Self-review: Explaining the increase12 minutes
Knowledge check: Analytical Tools in Power BI15 minutes
Self-review: Root cause analysis15 minutes
Knowledge check: Working with AI Visuals15 minutes

1 discussion promptTotal 10 minutes

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

This module consolidates learning through a comprehensive project where you design and present a complete data analysis solution. You will apply reporting, visualization, navigation, and analytical techniques to create an executive-level output, followed by a final assessment to evaluate your overall proficiency.

What's included

1 video3 readings2 assignments1 discussion prompt

1 videoTotal 7 minutes

Course recap: Data Analysis and Visualization with Power BI7 minutes

3 readingsTotal 50 minutes

About the final project and assessment: Data Analysis and Visualization with Power BI10 minutes
Exercise: Adventure Works executive summary30 minutes
Exemplar: Adventure Works executive summary10 minutes