Data Modeling and Architecture is designed to provide you with the foundational skills required to create and manage data models in Microsoft Power BI. Throughout this course, you'll explore the intricacies of data relationships, schemas, and the use of Data Analysis Expressions (DAX) to enhance your data models. You'll also explore essential topics like data privacy and security, ensuring that your data models are both effective and compliant with ethical standards. This course is hands-on, offering practical experience in configuring data structures and applying advanced techniques to optimize data models. By the end of this course, you’ll be able to design robust data models that support insightful and ethical data analysis.


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

位教师: Microsoft
2,137 人已注册
包含在 中
您将获得的技能
要了解的详细信息

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

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

该课程共有4个模块
In this module, you will learn the fundamentals of data modeling in Microsoft Power BI, focusing on different types of cardinality and how to create star and snowflake schemas. You’ll explore the key concepts of data relationships, such as one-to-one, many-to-one, and many-to-many, and understand how to effectively set up and manage these relationships within Power BI. This module sets the stage for building complex and efficient data models.
涵盖的内容
8个视频16篇阅读材料7个作业
This module introduces you to the power of Data Analysis Expressions (DAX) in Power BI. You’ll learn how to create DAX formulas using tools like Copilot, explore the concept of row and filter context, and understand how to apply DAX measures to enhance your data analysis. Additionally, you’ll gain insights into configuring role-playing dimensions and cross-filter contexts, which are essential for creating dynamic and responsive data models.
涵盖的内容
13个视频10篇阅读材料8个作业
In this module, you will explore the critical aspects of data privacy and security within data modeling. You'll explore ethical considerations, privacy laws, and the principles of data governance. This module emphasizes the importance of maintaining data integrity and compliance, ensuring that your data models adhere to best practices for ethical data use. You'll also learn about the key components of a data governance framework, vital for any organization handling sensitive data.
涵盖的内容
5个视频4篇阅读材料4个作业
In the final course project, you will consolidate your learning by applying the skills acquired throughout the course to a real-world scenario. You’ll design a comprehensive data model in Power BI, configure schemas, apply DAX measures, and address data privacy concerns. This project challenges you to synthesize all the concepts from the course, demonstrating your ability to create robust, ethical, and efficient data models in a professional setting.
涵盖的内容
1个视频5篇阅读材料2个作业1个插件
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
从 Data Analysis 浏览更多内容
- 状态:免费试用
- 状态:预览
Illinois Tech
- 状态:免费试用
University of Alberta
- 状态:免费试用
University of Alberta
人们为什么选择 Coursera 来帮助自己实现职业发展




常见问题
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.
更多问题
提供助学金,