Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Data Modeling and Architecture

Microsoft via Coursera

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 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.

Syllabus

  • Data modeling basics
    • In this module, you will learn the fundamentals of data modeling in 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.

Taught by

Microsoft

Reviews

Start your review of Data Modeling and Architecture

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.