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

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

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

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

Power BI Fundamentals and Data Modeling

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

О курсе

This course introduces learners to Power BI's architecture, components, and development lifecycle while building foundational skills in data modeling and transformation. Participants will learn to create well-structured data models, establish relationships between tables, and optimize models for performance and scalability. By the end of the course, learners will be able to design effective data models that serve as the foundation for powerful visualizations and insights.

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

GovernanceModel OptimizationDatabase DesignData ArchitectureData Warehousing

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

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

01Understanding the Power BI Ecosystem29 материалов

Introduction to the Power BI Platform

Why Power BI MattersВидеоThe Power BI EcosystemЧтениеGetting Started with Power BI DesktopВидеоPower BI Components ExplorationЗадание

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

Microsoft

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 58.4 ч

5 модулей

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

Субтитры: Дари, Пушту

Часть программы вашего университета
Hands-on – Power BI REST API BasicsЧтение
Your Power BI JourneyDIALOGUE
Power BI Platform Component IdentificationЗадание

Power BI Desktop Fundamentals

Desktop - The Power BI Developer's CanvasВидеоUnderstanding Power BI DesktopЧтениеExploring the Power BI Product SuiteВидеоBuilding Your First Power BI Desktop Report ЗаданиеHands-on – M Query BasicsЧтениеDesktop Challenges and SolutionsDIALOGUEDesktop Interface Navigation ChallengeЗадание

Power BI Service and Mobile

Leveraging Cloud Capabilities with Power BI ServiceВидеоPower BI Service Features and Mobile ExperienceЧтениеPublishing to and Navigating Power BI ServiceВидеоHands-on – Simple Report Embedding CodeЧтениеCloud versus On-Premises Deployment ConsiderationsDIALOGUEService Feature ImplementationЗаданиеPublishing and Sharing Reports in the ServiceЗадание

Power BI Development Lifecycle

The Value of a Structured Development ProcessВидеоEnd-to-End Power BI Development ProcessЧтениеImplementing the Complete Development WorkflowВидеоVersion Control Script for Power BI FilesЗаданиеCustomizing the Development Process for Your ProjectsDIALOGUEDevelopment Process Application ЗаданиеBuilding a Solution Following the Development LifecycleЗаданиеPower BI Ecosystem and Development FundamentalsЗадание
02Workspace Management and Collaboration29 материалов

Creating and Managing Workspaces

Workspaces as Organizational FoundationsВидеоPower BI Workspace Types and ManagementЧтениеCreating and Configuring Workspace SettingsВидеоHands-on – Workspace Inventory PowerShell ScriptЧтениеDesigning an Optimal Workspace StrategyDIALOGUEWorkspace Setup and ConfigurationЛабораторнаяWorkspace OrganizationЗадание

Security and Access Control

Balancing Security and AccessibilityВидеоPower BI Security Model and Access ControlЧтениеImplementing Role-Based SecurityВидеоHands-on – Permission Verification ScriptЧтениеAddressing Unique Security RequirementsDIALOGUESecurity Model ImplementationЛабораторная

Content Organization Strategies

Content Organization for Maximum ImpactВидеоBest Practices for Content ManagementЧтениеImplementing Effective Content OrganizationВидеоHands-on – Content Inventory and Analysis ScriptЧтениеTailoring Organization to Your User BaseDIALOGUEContent Organization ImplementationЛабораторная

Integration with Microsoft 365

The Connected Analytics ExperienceВидеоPower BI Integration with Microsoft 365 ServicesЧтениеEmbedding Reports in Teams and SharePointВидеоHands-on – Microsoft 365 Integration Status ScriptЧтениеIntegration Strategy for Your Microsoft EnvironmentDIALOGUEMicrosoft 365 Integration ImplementationЛабораторная
03Data Modeling Concepts30 материалов

Data Modeling Fundamentals

Data Models as the Foundation of AnalysisВидеоCore Data Modeling Principles for AnalyticsЧтениеEvaluating and Planning Data StructuresВидеоMeasures vs Calculated Columns vs Calculated TablesЧтениеHands-on – Model Documentation ScriptЧтениеAddressing Your Specific Modeling ChallengesDIALOGUEHands-on – Data Model Analysis and DocumentationЧтениеEvaluating a Data Model Задание

Star and Snowflake Schema Design

Why Dimensional Modeling MattersВидеоDimensional Modeling Techniques for AnalyticsЧтениеImplementing Star and Snowflake SchemasВидеоHands-on – Schema Analysis and Classification ScriptЧтениеSelecting the Optimal Schema for Your DataDIALOGUEHands-on – Dimensional Model ImplementationЧтение

Data Connection Methods

Balancing Performance and FreshnessВидеоConnection Methods and Their Trade-offsЧтениеImplementing and Configuring Connection TypesВидеоHands-on – Connection Mode Analysis ScriptЧтениеConnection Strategy for Your Data SourcesDIALOGUEHands-on – Connection Method Implementation and TestingЧтение

Advanced Data Modeling Scenarios

Tackling Complex Data RelationshipsВидеоAdvanced Modeling Techniques and Semantic ModelsЧтениеImplementing Complex Modeling PatternsВидеоHands-on – Model Complexity Analysis ScriptЧтениеAdapting Advanced Techniques to Your ScenariosDIALOGUEHands-on – Complex Model ImplementationЧтение
04Data Transformation with Power Query29 материалов

Power Query Fundamentals

The ETL Foundation of Power BIВидеоPower Query and M LanguageЧтениеGetting Started with Power Query EditorВидеоHands-on – Basic M Query TransformationЧтениеMapping Your Data Transformation NeedsDIALOGUEHands-on – Basic Power Query OperationsЧтениеTransformation FundamentalsЗадание

Data Cleansing and Preparation

Clean Data as the Foundation of Accurate AnalysisВидеоData Quality Issues and Resolution TechniquesЧтениеImplementing Data Cleansing MethodsВидеоHands-on – Data Quality Assessment ScriptЧтениеAddressing Your Specific Data Quality IssuesDIALOGUEHands-on – Data Cleaning ImplementationЧтение

Advanced Transformations

Reshaping Data for Analytical InsightsВидеоAdvanced Transformation Techniques in Power QueryЧтениеImplementing Pivoting and Complex TransformationsВидеоHands-on – Custom Transformation FunctionЧтениеSolving Complex Transformation ScenariosDIALOGUEHands-on – Advanced Data ReshapingЧтение

Query Management and Optimization

Performance as a Foundation of User ExperienceВидеоQuery Optimization and Performance TechniquesЧтениеImplementing Query Folding and OptimizationВидеоHands-on – Query Performance Analysis ScriptЧтениеOptimization Strategy for Your Data SourcesDIALOGUEHands-on – Query Performance OptimizationЧтение
05Building Relationships and Optimizing Models30 материалов

Creating Table Relationships

Relationships as the Backbone of AnalysisВидеоTable Relationship Types and ImplementationЧтениеCreating and Managing Table RelationshipsВидеоHands-on – Relationship Analysis ScriptЧтениеSolving Complex Relationship ChallengesDIALOGUEHands-on – Relationship Implementation and TestingЧтениеRelationship ConfigurationЗадание

Hierarchies and Categories

The Analytical Power of HierarchiesВидеоHierarchy Types and Implementation Best PracticesЧтениеCreating and Using Data HierarchiesВидеоHands-on – Hierarchy Definition ScriptЧтениеDesigning Hierarchies for Your Analysis NeedsDIALOGUEHands-on – Hierarchy ImplementationЧтение

Model Organization and Documentation

The Value of Well-Organized ModelsВидеоModel Organization and Documentation StandardsЧтениеImplementing Organization Best PracticesВидеоHands-on – Model Documentation GeneratorЧтениеOptimizing Model Organization for Your UsersDIALOGUEHands-on – Model Organization ImplementationЧтение

Performance Optimization Techniques

Security That Enables, Not RestrictsВидеоPower BI Security Framework and ImplementationЧтениеImplementing Row-Level SecurityВидеоHands-on – Security Implementation FrameworkЧтениеImplementing Security for Your Business ContextDIALOGUEHands-on – Enterprise Security ImplementationЧтение

COURSE PROJECT

Comprehensive Power BI Model DevelopmentЗадание
Access Control ScenarioЗадание
Reorganization for Messy ContentЗадание
Teams and SharePoint IntegrationЗадание
Workspace Management and Collaboration TechniquesЗадание
Schema Transformation Задание
Selecting Connection Types Задание
Advanced Modeling Задание
Data Modeling Principles and ImplementationЗадание
Messy Data Cleanup Задание
Data Restructuring Задание
Query Optimization Задание
Power Query Transformation and OptimizationЗадание
Custom Hierarchy Creation ChallengeЗадание
Enterprise Model OrganizationЗадание
Multi-Regulatory Security Задание
Relationships and Model OptimizationЗадание