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
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.
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.
At this point, you should have a strong understanding of different types of visualizations and their appropriate use, along with the ability to create cohesive and compelling reports in Power BI. You should also be capable of identifying and addressing common design problems in reports, producing audience-focused reports by understanding business needs.
Additionally, you should also be comfortable configuring multiple data sources, cleaning and transforming data using Power Query, and ensuring data integrity and quality. These skills will serve as the foundation for more advanced tasks, such as building and maintaining relationships in data models, writing DAX calculations, and managing data privacy and ethics concerns in Power BI.
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
Show info about module content
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
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
Data Analysis Expressions
Module 2•6 hours to complete
Module details
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
Show info about module content
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
Data privacy and security
Module 3•3 hours to complete
Module details
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
Show info about module content
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
Final project and assessment: Data Modeling and Architecture
Module 4•4 hours to complete
Module details
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
Show info about module content
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.
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.
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.
What background knowledge is necessary?
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.
How long does it take to complete the Specialization?
It typically takes 5 to 6 months to complete the 5 courses. But some learners may go through the content faster.
What is data visualization?
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.Â
What does a junior data scientist or data analyst do?
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.
What jobs can I get with junior data visualization skills?
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.
Will I be able to complete this course online?
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.
Do I need to take the courses in specific order?
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.
What will I be able to do upon completing the Professional Certificate?
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.
Will I earn university credit for completing the Specialization?
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.
When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Certificate?
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.