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.
Data Preparation and Management
This course is part of Microsoft Data Visualization Professional Certificate
Instructor: Microsoft
Recommended experience
Details to know
Add to your LinkedIn profile
20 assignments
See how employees at top companies are mastering in-demand skills
Build your Data Analysis expertise
- 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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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
Recommended if you're interested in Data Analysis
Why people choose Coursera for their career
New to Data Analysis? Start here.
Open new doors with Coursera Plus
Unlimited access to 7,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
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.