Harnessing the Power of Data with Power BI

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

Instructor: Microsoft

Access provided by SGCSRC

174,278 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

1,918 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

3 modules

Gain insight into a topic and learn the fundamentals.

1,918 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

What you'll learn

How to recognize and use the key data analysis components of Microsoft Power BI.
Understand a Power BI data analyst's skills, tasks, and tools.
Describe the different stages in the data analysis process that result in data-driven decisions.

Skills you'll gain

Tools you'll learn

Power BI

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

13 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 3 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’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI. After completing this course, you’ll be able to:   • Describe how data is produced and gathered in businesses and organizations.  • Outline the role of data in creating data-driven decisions and successful business outcomes.  • Classify key stages in the data analysis process.  • Recognize the skills needed by a Power BI analyst and the tools they use.  • List the tasks performed by a Power BI Data Analyst.  • Recognize the components of Power BI.  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.

Are you ready to transform raw data into powerful business stories? In this module, you will kickstart your journey by mastering the five pillars of the professional data analysis process: Prepare, Model, Visualize, Analyze, and Maintain. You will explore the essential Power BI trio—Desktop, Service, and Mobile—learning exactly how to move from authoring a report to sharing insights with global teams. By the end of this module, you will navigate the ecosystem like a seasoned analyst, ready to turn information into impact.

What's included

10 videos23 readings4 assignments1 discussion prompt

10 videosTotal 51 minutes

Course introduction7 minutes
What is the role of a Data Analyst?5 minutes
Roles working with data5 minutes
Essential data analyst skills5 minutes
Gathering the right data5 minutes
Processing and analyzing the data4 minutes
How data insights drive business5 minutes
Introduction to Power BI6 minutes
Analyzing data with Power BI5 minutes
Module summary: Data analysis in business3 minutes

23 readingsTotal 295 minutes

Course syllabus10 minutes
How to be successful in this course10 minutes
New name for Power BI datasets10 minutes
How to locate your downloaded files10 minutes
Additional resources: Welcome to the course10 minutes
Using data to solve a business problem10 minutes
Tasks of a data analyst10 minutes
Exercise: Identifying stakeholders30 minutes
Exemplar: Identifying stakeholders10 minutes
Additional resources: The role of the Data Analyst5 minutes
Sharing data insights10 minutes
Stakeholder experience10 minutes
Exercise: Stakeholder experience30 minutes
Exemplar: Stakeholder experience10 minutes
Exercise: Evaluating an analysis process30 minutes
Exemplar: Evaluating an analysis process10 minutes
Additional resources: Stages in data analysis5 minutes
Power BI Desktop, service, and Mobile10 minutes
Setting up your Power BI environment10 minutes
Activity: How to view a report10 minutes
Exercise: Generate a visualization30 minutes
Exemplar: Generate a visualization10 minutes
Additional resources: Introduction to Power BI5 minutes

4 assignmentsTotal 75 minutes

Module quiz: Data analysis in business30 minutes
Knowledge check: The role of the Data Analyst15 minutes
Knowledge check: Stages in data analysis15 minutes
Knowledge check: Introduction to Power BI15 minutes

1 discussion promptTotal 10 minutes

What do you hope to learn?10 minutes

Real-world data is often messy—but you will learn how to tame it. In this module, you will dive into the engine room of Power BI: Power Query. You will master the art of Extract, Transform, and Load (ETL) to ensure your data is clean, accurate, and ready for analysis. By focusing on data integrity within organizational contexts, you will gain the hands-on skills needed to solve common data pitfalls and build a foundation of trust for every report you create.

What's included

8 videos11 readings7 assignments1 discussion prompt

8 videosTotal 46 minutes

Identifying and evaluating required data6 minutes
Workflow in Power BI5 minutes
The ETL (Extract, Transform, Load) process6 minutes
Ingesting and gathering data6 minutes
Storing and managing data6 minutes
Transforming and cleaning data6 minutes
What is Power Query?6 minutes
Module summary: The right tools for the job5 minutes

11 readingsTotal 155 minutes

Exercise: Dataset30 minutes
Exemplar: Dataset10 minutes
Additional resources: Data collection5 minutes
Exercise: Data storage and management30 minutes
Exemplar: Data storage and management10 minutes
Additional resources: Introduction to the ETL process5 minutes
Cleaning at source in Excel10 minutes
Data transformed in Power BI10 minutes
Exercise: Evaluating data for transformation30 minutes
Exemplar: Evaluating data for transformation10 minutes
Additional resources: Introduction to transforming data5 minutes

7 assignmentsTotal 105 minutes

Module quiz: The right tools for the job30 minutes
Self-Review: Dataset10 minutes
Knowledge check: Data collection15 minutes
Self-Review: Data storage and management10 minutes
Knowledge check: Introduction to the ETL process15 minutes
Self-Review: Evaluating data for transformation10 minutes
Knowledge check: Introduction to transforming data15 minutes

1 discussion promptTotal 10 minutes

What other business scenarios would require data transformation?10 minutes

This is where your skills come to life! In this final capstone experience, you will design and construct a comprehensive Business Intelligence solution from scratch. You will connect to live data, perform complex cleaning in Power Query, and build a high-impact report that solves a real business challenge. Beyond the technical build, you will map your new expertise to specific BI career paths, ensuring you are ready to step into the industry with a professional-grade portfolio.

What's included

2 videos4 readings2 assignments1 discussion prompt

2 videosTotal 10 minutes

Course Recap: Harnessing the Power of Data6 minutes
Congratulations4 minutes

4 readingsTotal 60 minutes

About the final project and assessment: Harnessing the Power of Data in Power BI10 minutes
Exercise: Product launch analysis30 minutes
Exemplar: Product launch analysis10 minutes
Next steps10 minutes