Power BI: Data Analytics and Data Preparation

Early bird sale! Unlock 10,000+ courses from Google, Microsoft, and more for £160/year. Save now.

Power BI: Data Analytics and Data Preparation

This course is part of Exam Prep PL-300: Microsoft Power BI Data Analyst Associate Specialization

Instructor: Whizlabs Instructor

Included with Coursera Plus

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

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 part of the Exam Prep PL-300: Microsoft Power BI Data Analyst Associate Specialization

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

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 3 modules in this course

This course is designed to provide a comprehensive foundation in Microsoft Data Analytics, equipping learners with essential skills in Power BI for data-driven decision-making. Participants will begin by exploring data sources, understanding how to connect, manage, and optimize various datasets for analysis.

The course progresses to data cleaning techniques, ensuring accuracy and consistency in raw data before visualization. Learners will gain expertise in data types and data combining, enhancing efficiency in integrating multiple datasets. Additionally, the course covers data transformation principles, allowing participants to refine and manipulate data for advanced modeling and reporting. This course is structured into multiple modules, each featuring lessons and video lectures that provide theoretical insights and hands-on practice. Participants will engage with approximately 3:00–4:00 hours of instructional content, ensuring both conceptual understanding and practical application. To reinforce learning, graded and ungraded assignments are included within each module to test the ability of learners in real-world scenarios. Module 1: Microsoft Data Analytics: Exploring Power BI Data Sources Module 2: Data Cleaning Techniques in Power BI Module 3: Data Types and Transformation Techniques in Power BI At the end of the course, learners will learn - Understand key concepts of the PL-300 certification and the role of a data analyst. - Learn to acquire, clean, and transform data using Power BI tools. - Develop proficiency in Power BI’s interface, modeling, and visualization. - Learn to manage columns and reduce rows for efficient data cleaning in Power BI. - Apply sorting, splitting, and replacing values to enhance dataset organization. - Utilize filters, including text, numerical, and date-based, for refined data analysis. - Develop practical skills for transforming raw data into structured insights in Power BI. - Understand different Power BI data types and their applications in data processing. - Learn to merge, append, and integrate datasets using various query techniques. - Apply transformation techniques like grouping, transposing, pivoting, and unpivoting for structured analytics. - Develop practical skills in error handling, renaming, and optimizing data workflows in Power BI This course is for Data Analysts, Data Engineers, Power BI Analyst, and Power BI Experts

This module provides a comprehensive understanding of Power BI and data analytics, focusing on key concepts, tools, and exam preparation strategies for PL-300 certification. It emphasizes the principles of data-driven decision-making, data modeling, and visualization techniques, fostering a strong foundation for practical implementation. Participants will gain valuable insights into Power BI’s capabilities, installation, and user interface, enabling them to connect and transform data from various sources like Excel, CSV, and Web using Power Query Editor. The module also covers roles in the data world, responsibilities of a data analyst, and best practices for preparing for the certification exam. By the end of this module, learners will be equipped with the technical knowledge and skills required to navigate Power BI, analyze datasets effectively, and apply industry-standard practices for real-world data analytics solutions.

What's included

15 videos2 readings3 assignments1 discussion prompt

15 videosTotal 85 minutes

Introduction to PL-300 Certification6 minutesPreview module
Exam Overview4 minutes
Introduction to Data Analytics9 minutes
Introduction to Power BI7 minutes
Get Started Building with Power BI8 minutes
Roles in Data World (The Data Team)5 minutes
Data Analyst (Roles and Responsibilities)5 minutes
Power BI - Download and Installation3 minutes
Uncovering Power BI User Interface5 minutes
Get Data from Excel in Power Bi4 minutes
Get Data from CSV in Power Bi2 minutes
Get Data from Web into Power BI2 minutes
What is Power Query Editor?4 minutes
Power Query Editor - Demo7 minutes
Module 1 Exam Tips6 minutes

2 readingsTotal 50 minutes

Welcome to the Course20 minutes
Microsoft Data Analytics: Exploring Power BI Data Sources - Overview30 minutes

3 assignmentsTotal 75 minutes

Get started with Microsoft Data Analytics - Practice Assignment20 minutes
Power BI: Data Sources - Practice Assignment25 minutes
Microsoft Data Analytics: Exploring Power BI Data Sources - Graded Assignment30 minutes

1 discussion promptTotal 10 minutes

Meet & Greet10 minutes

This module provides a comprehensive understanding of data cleaning techniques in Power BI, ensuring datasets are properly structured for analysis and visualization. Participants will explore managing columns, reducing rows, and applying sorting and filtering operations to refine data integrity. The module covers advanced transformation techniques, such as splitting columns, replacing values, and applying text, numerical, and date-based filters for enhanced accuracy. By the end of this module, learners will gain hands-on expertise in organizing, filtering, and preparing data efficiently within Power BI to drive better analytical insights.

What's included

11 videos1 reading2 assignments

11 videosTotal 58 minutes

Cleaning Data in Power BI (Manage Columns) Part 14 minutesPreview module
Cleaning Data in Power BI (Manage Columns) Part 23 minutes
Cleaning Data in Power BI (Reduce Rows) Part 15 minutes
Cleaning Data in Power BI (Reduce Rows) Part 26 minutes
Cleaning Data in Power BI(Sorting)3 minutes
Cleaning Data in Power BI (Split Column)6 minutes
Cleaning Data in Power BI (Replace values)3 minutes
Cleaning Data in Power BI (Filters)3 minutes
Cleaning Data in Power BI (Text Filters)8 minutes
Cleaning Data in Power BI (Numerical Filters)6 minutes
Cleaning Data in Power BI (Date Filters)7 minutes

1 readingTotal 30 minutes

Prepare a machine learning solution - Overview30 minutes

2 assignmentsTotal 60 minutes

Power BI: Data Cleaning - Practice Assignment30 minutes
Data Cleaning Techniques in Power BI - Graded Assignment30 minutes

This module provides a comprehensive understanding of Power BI data types, data integration techniques, and advanced data transformation strategies. Participants will learn to classify numerical, date, text, boolean, and binary data types, ensuring structured and optimized data processing within Power BI. Additionally, learners will explore data combination techniques, including merge queries, inner joins, and append queries, allowing for seamless integration across multiple datasets. The module further delves into data transformation principles, covering grouping, transposing, pivoting, unpivoting, and various row operations, helping users refine data models for accurate insights. By the end of this module, participants will have hands-on expertise in transforming raw data into structured formats, enabling effective analytics, reporting, and visualization within Power BI.

What's included

16 videos1 reading3 assignments

16 videosTotal 90 minutes

Data Type in Power BI (Any Type & Numerical Type)6 minutesPreview module
Data Type in Power BI (Date Type)4 minutes
Data Type in Power BI (Text Type, Boolean Type & Binary Type)5 minutes
Combining Data in Power BI (Merge Queries)3 minutes
Combining Data in Power BI (Merge Types)6 minutes
Combining Data in Power BI (Inner Join)5 minutes
Combining Data in Power BI (Append Queries)6 minutes
Combining Data in Power BI (Append Queries)- Demo6 minutes
Transform Data in Power BI (Introduction)3 minutes
Transform Data in Power BI (Group By)8 minutes
Transform Data in Power BI (Transpose)5 minutes
Transform Data in Power BI (Reverse Rows + Count Rows)3 minutes
Transform Data in Power BI (Rename Rows + Replace Errors)6 minutes
Transform Data in PowerBI (Pivot Column)6 minutes
Transform Data in Power BI (Unpivot Column)6 minutes
Difference between Transpose, Pivot and Unpivot4 minutes

1 readingTotal 30 minutes

Data Types and Transformation Techniques in Power BI - Overview30 minutes

3 assignmentsTotal 90 minutes

Configure collaboration and communication - Practice Assignment30 minutes
Power BI: Data Transformation - Practice Assignment30 minutes
Data Types and Transformation Techniques in Power BI - Graded Assignment30 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Whizlabs Instructor

Whizlabs

98 Courses68,526 learners

Offered by

Whizlabs

Explore more from Data Analysis

Whizlabs
Power BI: Data Modeling and Data Analysis
Course
Whizlabs
Power BI: Data Visualization and Analysis
Course
Whizlabs
Power BI: Data Secure, Governance, and Workspace Management
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.