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

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

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

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

Power BI: Data Modeling and Data Analysis

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

О курсе

This course is designed to provide a comprehensive foundation in Power BI, equipping learners with the skills to model, analyze, and visualize data efficiently. Participants will begin by exploring calculated columns and tables, understanding their use cases in data modeling and performance optimization. The course progresses to advanced data modeling in Power BI, covering essential techniques like STAR schema design, model relationships, hierarchies, and role-playing dimensions to optimize data structures. Learners will gain expertise in DAX functions, including numerical calculations, measures, quick measures, and analytical queries, ensuring efficient data manipulation. Additionally, this course covers Power BI Desktop features, enabling participants to create calculation groups, work with DAX query view, and improve performance by reducing granularity. Features like date-time formatting, advanced settings in model view, and restricting access to model data are explored to enhance analytical capabilities. This course is structured into multiple modules, each featuring lessons and video lectures that provide both theoretical understanding and hands-on practice. Participants will engage with 3:00–4:00 hours of instructional content, reinforcing learning through graded and ungraded assignments, ensuring real-world applicability. Whether you're preparing for Power BI certification or seeking to optimize business intelligence workflows, this course equips you with the essential skills to master data modeling, DAX, and visualization for effective analytics. Module 1 - Optimizing Data Models and Performance with DAX in Power BI Module 2 - Power BI Data Modeling: STAR Schema, DAX, and Advanced Modeling Techniques The course is for the Data Managers, Data Analysts, Power BI Associates, and Power BI Experts

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

Power BIData Analysis Expressions (DAX)Data ModelingStar SchemaDatabase DesignData SecuritySpreadsheet SoftwarePerformance ImprovementModel OptimizationData ManipulationData Visualization SoftwareData AccessPerformance Tuning

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

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

01Optimizing Data Models and Performance with DAX in Power BI17 материалов

Power BI: Data Moderling and DAX Essentials

Welcome to CourseЧтениеOptimizing Data Models and Performance with DAX in Power BI - OverviewЧтениеCalculated columns and tables - use casesВидеоCreate calculation groupsВидео

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

Whizlabs Instructor

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7.7 ч

2 модулей

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

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

Часть программы вашего университета
Create calculated tables in Power BI DesktopВидео
Work with DAX query viewВидео
Improve performance by reducing granularityВидео
Data Modeling in Power BIВидео
Data Modelling in Power BI vs ExcelВидео
DAX in Power BIВидео
Measure in DAXВидео
Quick MeasureВидео
Calculated ColumnВидео
Using Numerical DAX Function in Power BI(Average, Profit, Count)Видео
Power BI: Data Modeling and DAX Essentials - Practice AssignmentЗадание
Optimizing Data Models and Performance with DAX in Power BI - Graded AssignmentЗадание
Optimizing Data Models and Performance with DAX in Power BIDIALOGUE
02Power BI Data Modeling: STAR Schema, DAX, and Advanced Modeling Techniques22 материалов

Building and Optimizing Data Models in Power BI: STAR Schema and Advanced Features

Power BI Data Modeling: STAR Schema, DAX, and Advanced Modeling Techniques - OverviewЧтениеSTAR Schema in Power BIВидеоCreating STAR Schema ModelВидеоAnalytical QueriesВидеоExploring Properties in Model ViewВидеоSetting Date- Time Format in Model ViewВидеоAdvanced Settings in the Properties Section (Date Table)ВидеоData GranularityВидеоModel RelationshipsВидеоBuilding and Optimizing Data Models in Power BI: STAR Schema and Advanced Features - Practice AssignmentЗадание

Advanced DAX and Data Modeling Techniques in Power BI

Understanding Hierarchies in Power BIВидеоUnderstanding Date Tables in DAXВидеоRole Playing DimensionsВидеоData Types in DAXВидеоWorking with DAX FunctionsВидеоUsing DAX Operators in Power BIВидео
Restrict access to Power BI model dataВидео
Apply good Modelling practicesВидео
Exam TipsВидео
Advanced DAX and Data Modeling Techniques in Power BI - Practice AssignmentЗадание
Power BI Data Modeling: STAR Schema, DAX, and Advanced Modeling Techniques - Graded AssignmentЗадание
Meet & GreetОбсуждение