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

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

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

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

Advanced DAX and Performance Optimization

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

О курсе

This course focuses on advanced DAX (Data Analysis Expressions) concepts and performance optimization techniques essential for Power BI developers. Participants will learn to write complex DAX formulas, create calculated columns and measures, and implement sophisticated business logic. The course emphasizes performance optimization methodologies and troubleshooting techniques to ensure reports are efficient and responsive. By leveraging tools like Performance Analyzer and DAX Studio, learners will diagnose and resolve common performance issues.

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

Data Analysis Expressions (DAX)Performance TuningPower BIMicrosoft CopilotTime Series Analysis and ForecastingBusiness IntelligenceContext ManagementBusiness MetricsModel OptimizationPerformance AnalysisData Modeling

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

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

01DAX Fundamentals29 материалов

Introduction to DAX

Why DAX is Essential for Power BI DevelopmentВидеоDAX Language Fundamentals and StructureЧтениеWriting Your First DAX ExpressionsВидеоHands-on – Basic DAX Syntax PracticeЧтение

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

Microsoft

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

Advanced DAX and Performance Optimization
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 71.1 ч

5 модулей

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

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

Часть программы вашего университета
Understanding Your DAX Learning PathDIALOGUE
Basic DAX Expression ChallengeЗадание
DAX Expression Creation and TestingЗадание

Calculated Columns vs. Measures

Choosing the Right Calculation TypeВидеоUnderstanding Calculated Columns and MeasuresЧтениеImplementing and Comparing Calculation TypesВидеоConverting Between Calculation TypesЗаданиеCalculation Strategy for Your RequirementsDIALOGUEAppropriate Calculation Selection ChallengeЗаданиеCreating and Testing Different Calculation TypesЗадание

Filter Context and Row Context

The Critical Importance of Context in DAXВидеоUnderstanding Filter Context and Row ContextЧтениеVisualizing Context in DAX CalculationsВидеоHands-on – Context Demonstration ScriptЧтениеIdentifying Context Issues in Your CalculationsDIALOGUEHands-on – Context exploration and manipulationЧтениеContext Transformation ChallengeЗадание

Basic Aggregation Functions

Building Blocks of DAX CalculationsВидеоCore Aggregation Functions in DAXЧтениеImplementing Standard Aggregation FunctionsВидеоHands-on – Aggregation Function PracticeЧтениеSelecting Appropriate Aggregations for Your DataDIALOGUEHands-on – Aggregation Function ImplementationЧтениеMulti-Level Aggregation ChallengeЗаданиеDAX Fundamentals and Basic CalculationsЗадание
02Advanced DAX Functions and Patterns29 материалов

Context Modification with CALCULATE

The Power of Context ModificationВидеоCALCULATE Function and Filter ManipulationЧтениеImplementing CALCULATE for Context ModificationВидеоHands-on – CALCULATE Function PracticeЧтениеCALCULATE Applications in Your ScenariosDIALOGUEComplex Filter Context ChallengeЗаданиеCALCULATE Implementation and TestingЗадание

Iterator Functions

Row-by-Row Processing with IteratorsВидеоX-Functions and Iteration in DAXЧтениеImplementing Iterator FunctionsВидеоHands-on – Iterator Function PracticeЧтениеIterator Applications in Your Data ModelDIALOGUEAdvanced Iteration ChallengeЗадание

Table Functions and Virtual Tables

Manipulating Data with Virtual TablesВидеоTable Functions and Virtual Table CreationЧтениеCreating and Using Virtual TablesВидеоHands-on – Virtual Table Creation PracticeЧтениеVirtual Table Applications in Your AnalysisDIALOGUEComplex Table Function ChallengeЗадание

Using Variables in DAX

Simplifying Complex DAX with VariablesВидеоVariable Declaration and Usage in DAXЧтениеImplementing and Optimizing with VariablesВидеоHands-on – Variable Implementation PracticeЧтениеVariable Strategy for Your Complex CalculationsDIALOGUEVariable Optimization ChallengeЗадание
03Time Intelligence and Complex Calculations29 материалов

Time Intelligence Fundamentals

The Business Value of Time-Based AnalysisВидеоDate Tables and Time Intelligence FunctionsЧтениеCreating and Configuring Date TablesВидеоHands-on – Date Table CreationЧтениеTime-Based Analysis Requirements in Your BusinessDIALOGUEHands-on – Date Table Implementation and ConfigurationЧтениеCustom Calendar Table Задание

Period-Over-Period Analysis

Driving Insights Through Comparative AnalysisВидеоPeriod Comparison Calculation PatternsЧтениеImplementing YoY, MoM, and Custom ComparisonsВидеоHands-on – Period Comparison Function PracticeЧтениеPeriod Comparison Strategy for Your ReportsDIALOGUEHands-on – Period Comparison ImplementationЧтение

Cumulative Totals and Moving Averages

Trend Analysis Through AccumulationВидеоRunning Totals and Moving Average PatternsЧтениеImplementing YTD, QTD, and Moving AveragesВидеоHands-on – Cumulative Calculation PracticeЧтениеCumulative Analysis Strategy for Your MetricsDIALOGUEHands-on – Cumulative Calculation ImplementationЧтение

Semi-Additive Measures and Complex Logic

Handling Special Calculation ScenariosВидеоSemi-Additive Measures and Complex ConditionsЧтениеImplementing Inventory and Balance CalculationsВидеоHands-on – Semi-Additive Measure PracticeЧтениеComplex Calculation Requirements in Your BusinessDIALOGUEHands-on – Semi-Additive Measure ImplementationЧтение
04Performance Optimization and Troubleshooting29 материалов

Understanding Performance Factors

Why Performance is Critical for User AdoptionВидеоPerformance Factors in Power BI ModelsЧтениеAnalyzing Performance BottlenecksВидеоHands-on – Model Performance Assessment ScriptЧтениеIdentifying Performance Issues in Your ModelsDIALOGUEHands-on – Performance Factor AnalysisЧтениеPerformance Bottleneck Identification ChallengeЗадание

Using Performance Analyzer

Data-Driven Performance OptimizationВидеоPerformance Analyzer Tool and MethodologyЧтениеConducting Performance Analysis in Power BIВидеоHands-on – Performance Results Interpretation ScriptЧтениеAnalyzing Your Report's Performance MetricsDIALOGUEHands-on – Performance Analyzer ImplementationЧтение

DAX Query Optimization

The Impact of Efficient DAX QueriesВидеоDAX Query Optimization TechniquesЧтениеRefactoring DAX for Better PerformanceВидеоHands-on – DAX Optimization PracticeЧтениеOptimizing Critical Calculations in Your ModelsDIALOGUEHands-on – DAX Query OptimizationЧтение

Advanced Troubleshooting with DAX Studio

Professional Troubleshooting with Specialized ToolsВидеоDAX Studio for Advanced DiagnosticsЧтениеUsing DAX Studio for Query AnalysisВидеоHands-on – DAX Studio Query Analysis ScriptЧтениеAdvanced Troubleshooting for Your Complex ModelsDIALOGUEHands-on – DAX Studio ImplementationЧтение
05AI-Assisted DAX and Advanced Diagnostics30 материалов

Leveraging Copilot for DAX

AI-Assisted Development for Enhanced ProductivityВидеоCopilot for DAX Features and CapabilitiesЧтениеUsing Copilot to Generate and Refine DAXВидеоHands-on – Copilot-Generated DAX RefinementЧтениеCopilot Strategy for Your Complex CalculationsDIALOGUEHands-on – Copilot for DAX ImplementationЧтениеCopilot-Assisted Complex Calculation ChallengeЗадание

Error Diagnosis and Resolution

Systematic Approach to Error ResolutionВидеоCommon DAX Errors and Resolution StrategiesЧтениеDiagnosing and Fixing DAX Calculation IssuesВидеоHands-on – Error Resolution PracticeЧтениеTroubleshooting Patterns for Your DAX IssuesDIALOGUEHands-on – Error Diagnosis and ResolutionЧтение

Memory Optimization Techniques

Managing Memory for Scalable SolutionsВидеоMemory Management in DAX and Power BIЧтениеImplementing Memory Optimization TechniquesВидеоHands-on – Memory Usage Analysis ScriptЧтениеMemory Optimization Strategy for Your ModelsDIALOGUEHands-on – Memory Optimization ImplementationЧтение

Advanced Query Diagnostics

Mastering Query Performance AnalysisВидеоQuery Diagnostics Tools and MethodologyЧтениеImplementing Advanced Diagnostic TechniquesВидеоHands-on – Query Diagnostic Interpretation ScriptЧтениеDiagnostic Strategy for Your Complex ModelsDIALOGUEHands-on – Query Diagnostics ImplementationЧтение

COURSE PROJECT

Financial Analytics Dashboard with Advanced DAXЗадание
Iterator Function ImplementationЗадание
Virtual Table ImplementationЗадание
Variable Usage and Performance TestingЗадание
Advanced DAX Functions and PatternsЗадание
Complex Comparison Calculation Задание
Rolling Trend Analysis ChallengeЗадание
Complex Business Logic ChallengeЗадание
Time Intelligence and Advanced CalculationsЗадание
Performance Analysis and Documentation ChallengeЗадание
DAX Performance Improvement ChallengeЗадание
Complex Troubleshooting Scenario ChallengeЗадание
Performance Optimization and Troubleshooting Задание
Complex Error Resolution ChallengeЗадание
Memory Consumption Reduction ChallengeЗадание
Complex Query Analysis ChallengeЗадание
AI-Assisted Development and Advanced DiagnosticsЗадание