Microsoft

Data Preparation and Management

 Microsoft

Instructor: Microsoft

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

17 hours to complete
3 weeks at 5 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

17 hours to complete
3 weeks at 5 hours a week
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

November 2024

Assessments

20 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder

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
Placeholder
Placeholder

Earn a career certificate

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

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

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

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

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

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

Instructor

 Microsoft
Microsoft
196 Courses1,099,704 learners

Offered by

Microsoft

Recommended if you're interested in Data Analysis

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

New to Data Analysis? Start here.

Placeholder

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

Advance your career with an online degree

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

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

Upskill your employees to excel in the digital economy

Frequently asked questions