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
This course is part of Microsoft Data Visualization Professional Certificate
Instructor: Microsoft
3,335 already enrolled
Included with
Gain insight into a topic and learn the fundamentals.
4.8
21 reviews
Beginner level
Recommended experience
Recommended experience
Beginner level
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.8
21 reviews
Beginner level
Recommended experience
Recommended experience
Beginner level
No prior experience is needed. No prerequisites. Following courses in sequence is recommended, as skills and knowledge build on earlier courses.
2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
21 assignments
Taught in English
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
There are 4 modules in this course
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.
What's included
8 videos16 readings7 assignments
8 videos•Total 45 minutes
- Course introduction•5 minutes
- Introduction to data models•6 minutes
- Introduction to cardinality•6 minutes
- Introduction to schemas•6 minutes
- Understanding fact and dimension tables•5 minutes
- Setting up a star schema in Power BI•5 minutes
- Setting up a snowflake schema•7 minutes
- Module summary: Data modeling basics•5 minutes
16 readings•Total 155 minutes
- How to be successful in this course•10 minutes
- Course navigation: Enhanced image viewing•10 minutes
- Course navigation: Locating downloaded files•10 minutes
- Activity: Setting up Microsoft 365•10 minutes
- Activity: Setting up your Power BI environment•10 minutes
- Activity: Updating a data source path•10 minutes
- Course syllabus•10 minutes
- Table view in Power BI•10 minutes
- Cardinality in depth•10 minutes
- Exemplar: Choosing the correct cardinality•10 minutes
- Model view in Power BI•10 minutes
- Exemplar: Configuring a star schema•10 minutes
- Normalization and denormalization•10 minutes
- Why it is important to use snowflake schema•10 minutes
- Exemplar: Configuring a snowflake schema•10 minutes
- Additional resources: Data modeling basics•5 minutes
7 assignments•Total 165 minutes
- Activity: Choosing the correct cardinality•30 minutes
- Knowledge check: Cardinality•15 minutes
- Activity: Configuring a star schema•30 minutes
- Knowledge check: Introduction to data schemas•15 minutes
- Activity: Configuring a snowflake schema•30 minutes
- Knowledge check: Advanced data schemas•15 minutes
- Module quiz: Data modeling basics•30 minutes
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.
What's included
13 videos10 readings8 assignments
13 videos•Total 65 minutes
- Introduction to Data Analysis Expressions (DAX)•6 minutes
- Formula and functions in DAX•5 minutes
- Row context and filter context•6 minutes
- Introduction to measures•5 minutes
- Types of measures•5 minutes
- Creating quick measures•5 minutes
- Introduction to cross-filter direction•5 minutes
- Introduction to the CROSSFILTER function•4 minutes
- Using CALCULATE with filters•6 minutes
- Introduction to role-playing dimensions•5 minutes
- Introduction to the USERELATIONSHIP function•5 minutes
- Configuring role-playing dimensions•4 minutes
- Module summary: Data Analysis Expressions•5 minutes
10 readings•Total 95 minutes
- DAX cheat sheet•10 minutes
- Basic statistical functions•10 minutes
- Statistical functions cheat sheet•10 minutes
- Exemplar: Adding a measure•10 minutes
- CALCULATE modifiers•10 minutes
- Exemplar: Using the CALCULATE function•10 minutes
- Exemplar: Adding a role-playing dimension•10 minutes
- Navigating Microsoft Fabric subscriptions•10 minutes
- Microsoft Power BI Copilot•10 minutes
- Additional resources: Data Analysis Expressions•5 minutes
8 assignments•Total 180 minutes
- Knowledge check: Introduction to Data Analysis Expressions•15 minutes
- Activity: Adding a measure•30 minutes
- Knowledge check: DAX measures•15 minutes
- Activity: Using the CALCULATE function•30 minutes
- Knowledge check: Cross-filter and filter context•15 minutes
- Activity: Adding a role-playing dimension•30 minutes
- Knowledge check: DAX in table relationships•15 minutes
- Module quiz: Data Analysis Expressions•30 minutes
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.
What's included
5 videos4 readings4 assignments
5 videos•Total 28 minutes
- Introduction to data privacy•6 minutes
- Principles of ethical data use•5 minutes
- Introduction to data governance•6 minutes
- Components of data governance•6 minutes
- Module summary: Data privacy and security•6 minutes
4 readings•Total 35 minutes
- Best practices for data use•10 minutes
- Exemplar: Identify privacy and ethics issues•10 minutes
- Data quality over time•10 minutes
- Additional resources: Data privacy and security•5 minutes
4 assignments•Total 90 minutes
- Activity: Identify privacy and ethics issues•30 minutes
- Knowledge check: Data privacy and ethics•15 minutes
- Knowledge check: Data governance•15 minutes
- Module quiz: Data privacy and security•30 minutes
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.
What's included
1 video5 readings2 assignments1 plugin
1 video•Total 7 minutes
- Course recap: Data modeling and architecture•7 minutes
5 readings•Total 70 minutes
- About the final project and assessment•5 minutes
- Final project: Creating a data model•40 minutes
- Showcase your skills•10 minutes
- Coursera community•10 minutes
- Next steps•5 minutes
2 assignments•Total 120 minutes
- Self-review: Creating a data model•30 minutes
- Course quiz: Data modeling and architecture•90 minutes
1 plugin•Total 20 minutes
- Exemplar: Creating a data model•20 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Microsoft
287 Courses•2,492,805 learners
Offered by
Microsoft
Offered by
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.
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."
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.
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.