Data Analysis and Visualization with Power BI

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

Instructor: Microsoft

Access provided by Vishwakarma Intitutes

138,853 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

1,010 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,010 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 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

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

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
Module quiz: Creating Reports30 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 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

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
Module quiz: Navigation and Accessibility30 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 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

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
Module quiz: Bringing Data to the User30 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 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

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
Module quiz: Identifying Patterns and Trends30 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

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