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
Data Modeling and Architecture
本课程是 Microsoft Data Visualization 专业证书 的一部分
位教师： Microsoft
3,102 人已注册
包含在 中
深入了解一个主题并学习基础知识。
4.9
19 条评论
初级 等级
推荐体验
推荐体验
初级
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
2 周 完成
在 10 小时 一周
灵活的计划
自行安排学习进度
深入了解一个主题并学习基础知识。
4.9
19 条评论
初级 等级
推荐体验
推荐体验
初级
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
2 周 完成
在 10 小时 一周
灵活的计划
自行安排学习进度
您将获得的技能
您将学习的工具
要了解的详细信息
可分享的证书
添加到您的领英档案
作业
21 项作业
授课语言：英语（English）
了解顶级公司的员工如何掌握热门技能
积累 Data Analysis 领域的专业知识
本课程是 Microsoft Data Visualization 专业证书 专项课程的一部分
在注册此课程时，您还会同时注册此专业证书。
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 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个作业
8个视频• 总计45分钟
- Course introduction• 5分钟
- Introduction to data models• 6分钟
- Introduction to cardinality• 6分钟
- Introduction to schemas• 6分钟
- Understanding fact and dimension tables• 5分钟
- Setting up a star schema in Power BI• 5分钟
- Setting up a snowflake schema• 7分钟
- Module summary: Data modeling basics• 5分钟
16篇阅读材料• 总计155分钟
- How to be successful in this course• 10分钟
- 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分钟
- Table view in Power BI• 10分钟
- Cardinality in depth• 10分钟
- Exemplar: Choosing the correct cardinality• 10分钟
- Model view in Power BI• 10分钟
- Exemplar: Configuring a star schema• 10分钟
- Normalization and denormalization• 10分钟
- Why it is important to use snowflake schema• 10分钟
- Exemplar: Configuring a snowflake schema• 10分钟
- Additional resources: Data modeling basics• 5分钟
7个作业• 总计165分钟
- Module quiz: Data modeling basics• 30分钟
- Activity: Choosing the correct cardinality• 30分钟
- Knowledge check: Cardinality• 15分钟
- Activity: Configuring a star schema• 30分钟
- Knowledge check: Introduction to data schemas• 15分钟
- Activity: Configuring a snowflake schema• 30分钟
- Knowledge check: Advanced data schemas• 15分钟
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个作业
13个视频• 总计65分钟
- Introduction to Data Analysis Expressions (DAX)• 6分钟
- Formula and functions in DAX• 5分钟
- Row context and filter context• 6分钟
- Introduction to measures• 5分钟
- Types of measures• 5分钟
- Creating quick measures• 5分钟
- Introduction to cross-filter direction• 5分钟
- Introduction to the CROSSFILTER function• 4分钟
- Using CALCULATE with filters• 6分钟
- Introduction to role-playing dimensions• 5分钟
- Introduction to the USERELATIONSHIP function• 5分钟
- Configuring role-playing dimensions• 4分钟
- Module summary: Data Analysis Expressions• 5分钟
10篇阅读材料• 总计95分钟
- DAX cheat sheet• 10分钟
- Basic statistical functions• 10分钟
- Statistical functions cheat sheet• 10分钟
- Exemplar: Adding a measure• 10分钟
- CALCULATE modifiers• 10分钟
- Exemplar: Using the CALCULATE function• 10分钟
- Exemplar: Adding a role-playing dimension• 10分钟
- Navigating Microsoft Fabric subscriptions• 10分钟
- Microsoft Power BI Copilot• 10分钟
- Additional resources: Data Analysis Expressions• 5分钟
8个作业• 总计180分钟
- Module quiz: Data Analysis Expressions• 30分钟
- Knowledge check: Introduction to Data Analysis Expressions• 15分钟
- Activity: Adding a measure• 30分钟
- Knowledge check: DAX measures• 15分钟
- Activity: Using the CALCULATE function• 30分钟
- Knowledge check: Cross-filter and filter context• 15分钟
- Activity: Adding a role-playing dimension• 30分钟
- Knowledge check: DAX in table relationships• 15分钟
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个作业
5个视频• 总计28分钟
- Introduction to data privacy• 6分钟
- Principles of ethical data use• 5分钟
- Introduction to data governance• 6分钟
- Components of data governance• 6分钟
- Module summary: Data privacy and security• 6分钟
4篇阅读材料• 总计35分钟
- Best practices for data use• 10分钟
- Exemplar: Identify privacy and ethics issues• 10分钟
- Data quality over time• 10分钟
- Additional resources: Data privacy and security• 5分钟
4个作业• 总计90分钟
- Module quiz: Data privacy and security• 30分钟
- Activity: Identify privacy and ethics issues• 30分钟
- Knowledge check: Data privacy and ethics• 15分钟
- Knowledge check: Data governance• 15分钟
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个插件
1个视频• 总计7分钟
- Course recap: Data modeling and architecture• 7分钟
5篇阅读材料• 总计70分钟
- About the final project and assessment• 5分钟
- Final project: Creating a data model• 40分钟
- Showcase your skills• 10分钟
- Coursera community• 10分钟
- Next steps• 5分钟
2个作业• 总计120分钟
- Self-review: Creating a data model• 30分钟
- Course quiz: Data modeling and architecture• 90分钟
1个插件• 总计20分钟
- Exemplar: Creating a data model• 20分钟
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师
287 门课程• 2,373,262 名学生
提供方
提供方
Microsoft
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 浏览更多内容
课程
SSimplilearn
课程
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。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.
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.
更多问题
提供助学金，