Data Analysis and Visualization with Power BI

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

Instructor: Microsoft

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.

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

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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

16 videos24 readings6 assignments2 discussion prompts

16 videosTotal 100 minutes

Course introduction5 minutesPreview module
Analysis for Business Intelligence6 minutes
What are visualizations?7 minutes
Common visualizations7 minutes
Creating a basic report7 minutes
Table visualization5 minutes
Bar and column charts6 minutes
Line and area charts7 minutes
Combo charts5 minutes
Pie and donut charts6 minutes
Treemaps5 minutes
Displaying Key Performance Indicators5 minutes
Ribbon and waterfall charts6 minutes
Funnel charts5 minutes
Scatter charts7 minutes
Module summary: Creating Reports4 minutes

24 readingsTotal 260 minutes

Course syllabus10 minutes
How to be successful in this course10 minutes
How to open an image in a new tab10 minutes
Setting up your Power BI environment10 minutes
Setting up Power BI Service10 minutes
New name for Power BI datasets10 minutes
Business intelligence cheatsheet10 minutes
How to locate your downloaded files10 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: Enhance the report with brand information10 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

2 discussion promptsTotal 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 videosTotal 90 minutes

Accessibility in reports7 minutesPreview module
Formatting and configuring visualizations6 minutes
Conditional formatting5 minutes
Working with themes6 minutes
Adding custom tooltips6 minutes
Report hierarchies6 minutes
Report drillthrough4 minutes
Sorting and filtering data in reports6 minutes
Cross-filter and cross-highlight5 minutes
Adding slicers7 minutes
Adding buttons5 minutes
Adding bookmarks4 minutes
Group and layer visuals4 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

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 videosTotal 70 minutes

What is a dashboard?6 minutesPreview module
Creating a dashboard5 minutes
Improving usability in dashboards6 minutes
Limitations of pinned visuals5 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 User7 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

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 videos15 readings6 assignments1 discussion prompt

13 videosTotal 78 minutes

Introduction to analytics6 minutesPreview module
Statistical summary6 minutes
Group and bin data for analysis6 minutes
Histograms and Top N6 minutes
Clustering techniques6 minutes
Continuous and categorical axes5 minutes
Using the Analyze feature6 minutes
Conducting a time series analysis5 minutes
Creating reference lines6 minutes
Forecasting6 minutes
Key Influencers4 minutes
Decomposition trees6 minutes
Module summary: Identifying Patterns and Trends3 minutes

15 readingsTotal 195 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
Copy of 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

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

2 videos4 readings2 assignments1 discussion prompt

2 videosTotal 11 minutes

Course recap: Data Analysis and Visualization with Power BI7 minutesPreview module
Congratulations4 minutes

4 readingsTotal 60 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
Next steps10 minutes