К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Data Modeling and Architecture · LearnSpace
Назад в каталог
courseraАнализ данных

Data Modeling and Architecture

Курс от Microsoft
Начальный≈ 17.9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Data Analysis Expressions (DAX)Snowflake SchemaData ModelingStar SchemaPower BIData GovernanceData QualityInformation PrivacyData EthicsData IntegrityData ArchitectureData Visualization SoftwareExtract, Transform, LoadDatabase DesignGeneral Data Protection Regulation (GDPR)Relational DatabasesPersonally Identifiable InformationData Security

Программа курса

4 модулей · 84 учебных материалов

01Data modeling basics31 материалов

Course Introduction

Course introductionВидеоHow to be successful in this courseЧтениеCourse navigation: Enhanced image viewingЧтениеCourse navigation: Locating downloaded filesЧтение

Учитесь у экспертов

Microsoft

Преподаватель курса

Data Modeling and Architecture
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 17.9 ч

4 модулей

Язык: Английский

Субтитры: Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский, Казахский, Венгерский

Часть программы вашего университета
Activity: Setting up Microsoft 365Чтение
Activity: Setting up your Power BI environmentЧтение
Activity: Updating a data source pathЧтение
Course syllabusЧтение

Cardinality

Introduction to data modelsВидеоTable view in Power BIЧтениеIntroduction to cardinalityВидеоCardinality in depthЧтениеActivity: Choosing the correct cardinalityЗаданиеExemplar: Choosing the correct cardinalityЧтениеKnowledge check: CardinalityЗадание

Introduction to data schemas

Introduction to schemasВидеоModel view in Power BIЧтениеUnderstanding fact and dimension tablesВидеоSetting up a star schema in Power BIВидеоActivity: Configuring a star schemaЗаданиеExemplar: Configuring a star schemaЧтениеNormalization and denormalizationЧтениеKnowledge check: Introduction to data schemasЗадание

Advanced data schemas

Setting up a snowflake schemaВидеоWhy it is important to use snowflake schemaЧтениеActivity: Configuring a snowflake schemaЗаданиеExemplar: Configuring a snowflake schemaЧтениеKnowledge check: Advanced data schemasЗадание

Module wrap up

Module summary: Data modeling basicsВидеоModule quiz: Data modeling basicsЗаданиеAdditional resources: Data modeling basicsЧтение
02Data Analysis Expressions31 материалов

Introduction to Data Analysis Expressions

Introduction to Data Analysis Expressions (DAX)ВидеоFormula and functions in DAXВидеоDAX cheat sheetЧтениеRow context and filter contextВидеоKnowledge check: Introduction to Data Analysis ExpressionsЗадание

DAX measures

Introduction to measuresВидеоTypes of measuresВидеоBasic statistical functionsЧтениеStatistical functions cheat sheetЧтениеCreating quick measuresВидеоActivity: Adding a measureЗаданиеExemplar: Adding a measureЧтениеKnowledge check: DAX measuresЗадание

Cross-filter and filter context

Introduction to cross-filter directionВидеоIntroduction to the CROSSFILTER functionВидеоUsing CALCULATE with filtersВидеоCALCULATE modifiersЧтениеActivity: Using the CALCULATE functionЗаданиеExemplar: Using the CALCULATE functionЧтение

DAX in table relationships

Introduction to role-playing dimensionsВидеоIntroduction to the USERELATIONSHIP functionВидеоConfiguring role-playing dimensionsВидеоActivity: Adding a role-playing dimensionЗаданиеExemplar: Adding a role-playing dimensionЧтениеNavigating Microsoft Fabric subscriptionsЧтение

Module wrap up

Module summary: Data Analysis ExpressionsВидеоModule quiz: Data Analysis ExpressionsЗаданиеAdditional resources: Data Analysis ExpressionsЧтение
03Data privacy and security13 материалов

Data privacy and ethics

Introduction to data privacyВидеоPrinciples of ethical data useВидеоBest practices for data useЧтениеActivity: Identify privacy and ethics issuesЗаданиеExemplar: Identify privacy and ethics issuesЧтениеKnowledge check: Data privacy and ethicsЗадание

Data governance

Introduction to data governanceВидеоComponents of data governanceВидеоData quality over timeЧтениеKnowledge check: Data governanceЗадание

Module wrap up

Module summary: Data privacy and securityВидеоModule quiz: Data privacy and securityЗаданиеAdditional resources: Data privacy and securityЧтение
04Final project and assessment: Data Modeling and Architecture9 материалов

Introduction to the final project

About the final project and assessmentЧтениеFinal project: Creating a data modelЧтениеSelf-review: Creating a data modelЗаданиеExemplar: Creating a data modelPLUGIN

Next steps

Course recap: Data modeling and architectureВидеоCourse quiz: Data modeling and architectureЗаданиеShowcase your skillsЧтениеCoursera communityЧтениеNext stepsЧтение
Knowledge check: Cross-filter and filter contextЗадание
Microsoft Power BI CopilotЧтение
Knowledge check: DAX in table relationshipsЗадание