VOOZH about

URL: https://www.coursera.org/learn/data-preparation-and-management

⇱ Data Preparation and Management | Coursera

Data Preparation and Management

Data Preparation and Management

3,770 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
5.0

23 reviews

Beginner level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
5.0

23 reviews

Beginner level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

Build your Data Analysis expertise

This course is part of the Microsoft Data Visualization 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 4 modules in this course

Data Preparation and Management is designed to equip you with the essential skills needed to prepare and manage data effectively using Microsoft Power BI. Throughout this course, you'll learn how to connect, clean, and transform data from various sources to ensure its integrity and quality. You will explore the principles of Extract, Transform, Load (ETL) processes, data storage, and the importance of maintaining data accuracy. This course emphasizes practical applications, providing you with hands-on experience in managing real-world data scenarios. By the end of this course, you’ll be ready to confidently handle data preparation tasks and ensure that your data is ready for analysis and visualization.

This program is for anyone interested in data analytics and visualization; there are no prerequisites. To get the most out of the learning experience, it is recommended to follow the courses in sequence, as each one builds on the skills and knowledge gained in the previous ones. By the time you begin this course, you should have a strong understanding of different types of visualizations and their appropriate use, along with the ability to create cohesive and compelling reports in Power BI. You should also be capable of identifying and addressing common design problems in reports, producing audience-focused reports by understanding business needs.

In this module, you will learn how to set up data sources in Power BI. You’ll explore the different types of data sources available, from structured to unstructured data, and understand how to connect them to your Power BI environment. In this module you'll also cover the basics of connectors, triggers, and actions, providing you with the foundational knowledge to manage data sources effectively and ensure smooth data integration.

What's included

8 videos15 readings7 assignments

8 videos•Total 41 minutes
  • Course introduction•5 minutes
  • The ETL (Extract, Transform, Load) process•5 minutes
  • Setting up a simple data source•5 minutes
  • Identifying and evaluating required data•6 minutes
  • Structured vs. unstructured data•5 minutes
  • What are connectors?•5 minutes
  • Triggers and actions•6 minutes
  • Module summary: Data sources•5 minutes
15 readings•Total 160 minutes
  • How to be successful in this course•5 minutes
  • Course navigation: Enhanced image viewing•10 minutes
  • Course navigation: Locating downloaded files•10 minutes
  • Activity: Setting up Microsoft 365•10 minutes
  • Activity: Setting up your Power BI environment•10 minutes
  • Activity: Updating a data source path•10 minutes
  • Course syllabus•10 minutes
  • How combining data sources gives business insights•10 minutes
  • Exemplar: Setting up an Excel data source•10 minutes
  • Exemplar: Identify appropriate data sources•10 minutes
  • Data sources supported by Power BI•10 minutes
  • Exemplar: Implementing a trigger•10 minutes
  • Navigating Microsoft Fabric subscriptions•10 minutes
  • Walkthrough: Summarizing a semantic model with Copilot•30 minutes
  • Additional resources: Data sources•5 minutes
7 assignments•Total 165 minutes
  • Module quiz: Data sources•30 minutes
  • Activity: Setting up an Excel data source•30 minutes
  • Knowledge check: Introduction to Extract, Transform, Load•15 minutes
  • Activity: Identify appropriate data sources•30 minutes
  • Knowledge check: Gathering data•15 minutes
  • Activity: Implementing a trigger•30 minutes
  • Knowledge check: Working with data sources•15 minutes

This module focuses on transforming raw data into a structured format suitable for analysis. You'll be introduced to Power Query, a tool within Power BI, and learn how to perform basic and advanced data transformations. You also cover essential techniques such as appending, merging, and cleaning data, ensuring that you can convert diverse datasets into a cohesive format ready for visualization and reporting.

What's included

10 videos8 readings7 assignments

10 videos•Total 53 minutes
  • Why data needs to be transformed•5 minutes
  • Introduction to Power Query and its interface•5 minutes
  • The Applied steps list•5 minutes
  • Working with columns•6 minutes
  • Unpivot and pivot columns•6 minutes
  • Combining tables with append•5 minutes
  • What is a join?•5 minutes
  • Join types•4 minutes
  • Combining tables with merge•6 minutes
  • Module summary: Data transformation•5 minutes
8 readings•Total 75 minutes
  • Data types in Power BI•10 minutes
  • Common data errors•10 minutes
  • Exemplar: Working with Applied steps•10 minutes
  • The importance of matching column names•10 minutes
  • Exemplar: Pivoting and appending tables•10 minutes
  • Identifying join keys•10 minutes
  • Exemplar: Merging two data sources•10 minutes
  • Additional resources: Data transformation•5 minutes
7 assignments•Total 165 minutes
  • Module quiz: Data transformation•30 minutes
  • Activity: Working with Applied steps•30 minutes
  • Knowledge check: Introduction to data transformation•15 minutes
  • Activity: Pivoting and appending tables•30 minutes
  • Knowledge check: Advanced transformations•15 minutes
  • Activity: Merging two data sources•30 minutes
  • Knowledge check: Combining data•15 minutes

In this module, you will explore the principles of data storage and processing within Power BI. You’ll learn how to configure data storage options, understand the implications of storage choices on performance, and ensure that your data is optimized for quick access and analysis. Additionally, as you progress through this module you will cover data cleaning processes to correct errors and inconsistencies, ensuring the quality and reliability of your data.

What's included

5 videos5 readings4 assignments

5 videos•Total 27 minutes
  • Dealing with errors in Power Query•6 minutes
  • Evaluating and changing column data types•5 minutes
  • Storing and managing data•5 minutes
  • Storage modes in Power BI•6 minutes
  • Module summary: Data storage and processing•4 minutes
5 readings•Total 45 minutes
  • Cleaning data at source•10 minutes
  • Exemplar: Clean data in Power Query•10 minutes
  • Configuring storage modes in Power BI•10 minutes
  • Walk-through: Setting up storage mode•10 minutes
  • Additional resources: Data storage and processing•5 minutes
4 assignments•Total 90 minutes
  • Module quiz: Data storage and processing•30 minutes
  • Activity: Clean data in Power Query•30 minutes
  • Knowledge check: Data cleaning•15 minutes
  • Knowledge check: Data storage•15 minutes

This module brings together all the concepts learned in the course through a hands-on project. You’ll be tasked with preparing and managing data for a simulated real-world scenario, applying your knowledge of data sources, transformation, and storage. In this capstone project you will test your ability to ensure data integrity and quality, demonstrating your readiness to handle data preparation and management tasks in professional settings.

What's included

1 video5 readings2 assignments1 plugin

1 video•Total 6 minutes
  • Course recap: Data Preparation and Management•6 minutes
5 readings•Total 75 minutes
  • About the final project and assessment•5 minutes
  • Final project: Transforming multiple data sources•40 minutes
  • Showcase your skills•10 minutes
  • Coursera community•10 minutes
  • Next steps•10 minutes
2 assignments•Total 120 minutes
  • Self-review: Transforming multiple data sources•30 minutes
  • Course quiz: Data Preparation and Management•90 minutes
1 plugin•Total 20 minutes
  • Exemplar: Transforming multiple data sources•20 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

337 Courses•2,614,121 learners

Why people choose Coursera for their career

👁 Image

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."
👁 Image

Jennifer J.

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

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."
👁 Image

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."

Learner reviews

  • 5 stars

    95.83%

  • 4 stars

    4.16%

  • 3 stars

    0%

  • 2 stars

    0%

  • 1 star

    0%

Showing 3 of 23

MU
·

Reviewed on Jun 26, 2025

Out class Next level .I am amazed how much I am updated due to this course .

Frequently asked questions

This Professional Certificate is designed for aspiring junior data scientists who want to kickstart their careers in the business intelligence industry. It is also for current professionals who are seeking a greater understanding of data visualization fundamentals.

This program is for you:

- If you are interested in the field of data analytics and visualization or are just beginning to work in a junior data analyst role.

- If you want to switch or start a career in the field of data analytics and visualization.

- If you already work in data analytics and are seeking a greater understanding of data visualization fundamentals. Earning a Microsoft Data Visualization certificate can help you advance your career or address gaps in your knowledge, skills, and abilities.

This program is for anyone interested in data analytics and visualization; there are no prerequisites. To get the most out of the learning experience, it is recommended to follow the courses in sequence, as each one builds on the skills and knowledge gained in the previous ones.

It typically takes 5 to 6 months to complete the 5 courses. But some learners may go through the content faster.

Data visualization is the graphical representation of data, using visual elements like charts, graphs, and maps. It helps simplify complex data sets, allowing users to easily understand trends, patterns, and insights, ultimately aiding in decision-making and communication. 

A junior data scientist or data analyst collects, processes, and analyzes data to help organizations make informed decisions. They work with data visualization tools such as Microsoft Power BI, create reports, identify trends, and support business insights. They also collaborate with teams to improve data-driven strategies, spot opportunities and solve problems.

With the skills acquired from this Professional Certificate, you can qualify for entry-level positions such as junior data analyst, business intelligence (BI) analyst, or reporting analyst. These positions focus on analyzing data, creating reports and dashboards, and using tools like Microsoft Power BI to present actionable insights, helping organizations make data-driven decisions.

Yes, this course is entirely online, allowing you to study at your own pace from anywhere with an internet connection. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.

Yes. We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses.

Once you've completed the Microsoft Data Visualization Professional Certificate, you will possess the essential skills and knowledge to thrive in this dynamic field. These skills enhance your practical experience and career prospects in data visualization, ensuring you are well-prepared to tackle challenges in entry-level roles. This certificate is valuable to share within your professional network. 

Throughout the program, you engaged with hands-on activities, final course projects, and assessments, mastering fundamental concepts such as:

- Interpreting datasets and communicating findings to stakeholders through visualizations using Power BI.

- Analyzing data to extract insights that inform business decisions.

- Creating visually appealing and interactive reports and dashboards.

- Applying advanced data modeling techniques, including the use of Data Analysis Expressions (DAX).

- Applying statistical analysis techniques and leveraging AI-driven tools to uncover hidden insights and trends.

No, completing the Microsoft Data Visualization Professional Certificate does not grant university credit. However, by successfully completing all the courses in the program you will receive a professional Coursera certificate, which is valuable for career development. The certification is recognized globally, so it enhances your credibility and marketability to potential employers. It demonstrates your proficiency in data visualization tools like Microsoft Power BI.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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 Certificate, 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.

Financial aid available,