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.
通过 Coursera Plus 提高技能,仅需 239 美元/年(原价 399 美元)。立即节省

Data Preparation and Management
本课程是 Microsoft Data Visualization 专业证书 的一部分

位教师: Microsoft
3,412 人已注册
包含在 中
了解更多
22 条评论
推荐体验
推荐体验
初级
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
22 条评论
推荐体验
推荐体验
初级
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
您将获得的技能
您将学习的工具
要了解的详细信息

添加到您的领英档案
20 项作业
了解顶级公司的员工如何掌握热门技能

积累 Data Analysis 领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Microsoft 获得可共享的职业证书

该课程共有4个模块
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.
涵盖的内容
8个视频15篇阅读材料7个作业
8个视频•总计41分钟
- Course introduction•5分钟
- The ETL (Extract, Transform, Load) process•5分钟
- Setting up a simple data source•5分钟
- Identifying and evaluating required data•6分钟
- Structured vs. unstructured data•5分钟
- What are connectors?•5分钟
- Triggers and actions•6分钟
- Module summary: Data sources•5分钟
15篇阅读材料•总计160分钟
- How to be successful in this course•5分钟
- Course navigation: Enhanced image viewing•10分钟
- Course navigation: Locating downloaded files•10分钟
- Activity: Setting up Microsoft 365•10分钟
- Activity: Setting up your Power BI environment•10分钟
- Activity: Updating a data source path•10分钟
- Course syllabus•10分钟
- How combining data sources gives business insights•10分钟
- Exemplar: Setting up an Excel data source•10分钟
- Exemplar: Identify appropriate data sources•10分钟
- Data sources supported by Power BI•10分钟
- Exemplar: Implementing a trigger•10分钟
- Navigating Microsoft Fabric subscriptions•10分钟
- Walkthrough: Summarizing a semantic model with Copilot•30分钟
- Additional resources: Data sources•5分钟
7个作业•总计165分钟
- Module quiz: Data sources•30分钟
- Activity: Setting up an Excel data source•30分钟
- Knowledge check: Introduction to Extract, Transform, Load•15分钟
- Activity: Identify appropriate data sources•30分钟
- Knowledge check: Gathering data•15分钟
- Activity: Implementing a trigger•30分钟
- Knowledge check: Working with data sources•15分钟
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.
涵盖的内容
10个视频8篇阅读材料7个作业
10个视频•总计53分钟
- Why data needs to be transformed•5分钟
- Introduction to Power Query and its interface•5分钟
- The Applied steps list•5分钟
- Working with columns•6分钟
- Unpivot and pivot columns•6分钟
- Combining tables with append•5分钟
- What is a join?•5分钟
- Join types•4分钟
- Combining tables with merge•6分钟
- Module summary: Data transformation•5分钟
8篇阅读材料•总计75分钟
- Data types in Power BI•10分钟
- Common data errors•10分钟
- Exemplar: Working with Applied steps•10分钟
- The importance of matching column names•10分钟
- Exemplar: Pivoting and appending tables•10分钟
- Identifying join keys•10分钟
- Exemplar: Merging two data sources•10分钟
- Additional resources: Data transformation•5分钟
7个作业•总计165分钟
- Module quiz: Data transformation•30分钟
- Activity: Working with Applied steps•30分钟
- Knowledge check: Introduction to data transformation•15分钟
- Activity: Pivoting and appending tables•30分钟
- Knowledge check: Advanced transformations•15分钟
- Activity: Merging two data sources•30分钟
- Knowledge check: Combining data•15分钟
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.
涵盖的内容
5个视频5篇阅读材料4个作业
5个视频•总计27分钟
- Dealing with errors in Power Query•6分钟
- Evaluating and changing column data types•5分钟
- Storing and managing data•5分钟
- Storage modes in Power BI•6分钟
- Module summary: Data storage and processing•4分钟
5篇阅读材料•总计45分钟
- Cleaning data at source•10分钟
- Exemplar: Clean data in Power Query•10分钟
- Configuring storage modes in Power BI•10分钟
- Walk-through: Setting up storage mode•10分钟
- Additional resources: Data storage and processing•5分钟
4个作业•总计90分钟
- Module quiz: Data storage and processing•30分钟
- Activity: Clean data in Power Query•30分钟
- Knowledge check: Data cleaning•15分钟
- Knowledge check: Data storage•15分钟
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.
涵盖的内容
1个视频5篇阅读材料2个作业1个插件
1个视频•总计6分钟
- Course recap: Data Preparation and Management•6分钟
5篇阅读材料•总计75分钟
- About the final project and assessment•5分钟
- Final project: Transforming multiple data sources•40分钟
- Showcase your skills•10分钟
- Coursera community•10分钟
- Next steps•10分钟
2个作业•总计120分钟
- Self-review: Transforming multiple data sources•30分钟
- Course quiz: Data Preparation and Management•90分钟
1个插件•总计20分钟
- Exemplar: Transforming multiple data sources•20分钟
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师

提供方

提供方

Our goal at Microsoft is to empower every individual and organization on the planet to achieve more. In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
从 Data Analysis 浏览更多内容
状态:免费试用免费试用
状态:免费试用免费试用
状态:免费免费指导项目
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
学生评论
22 条评论
- 5 stars
95.45%
- 4 stars
4.54%
- 3 stars
0%
- 2 stars
0%
- 1 star
0%
显示 3/22 个
已于 Jun 26, 2025审阅
Out class Next level .I am amazed how much I am updated due to this course .
常见问题
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.
更多问题
提供助学金,


