MASTERING DAX CALCULATIONS FOR POWER BI

Khoá học phân tích dữ liệu chuyên sâu với DAX

Quy trình hoàn thành khoá học

LỘ TRÌNH ĐÀO TẠO TOÀN KHOÁ HỌC

Introduction BI & Overview Data Analysis

- Introduction BI & Overview Data Analysis
- Giới thiệu tổng quan về BI & ngành phân tích dữ liệu
- Ứng dụng của Power BI UX trong xử lý & phân tích dữ liệu- Tìm hiểu Data Preparation, Data Modelling, Data Visualization, Data Storytelling
- Giới thiệu về các công cụ hỗ trợ cho khóa học MS Excel, Power Query, Power Pivot, Power BI
Introduction Get & Transform

- Power Query, Power BI
- Query Promote & Demote headers, Filter by row position, Summarizing rows, Duplicate values, Choose & remove column - Pivot, un-pivot, grouping, combine, splitting, merge column
Data Modeling & DAX 1

- Data organization model and data analysis language DAX 1
- Mindset for data processing, how to use Power Pivot, Power BI tools
- Learn about Data Modeling in Power Pivot for Excel and Power BI.
- Fact & Dimension table, properties of table types. Learn table structure by Kimball methodology (star schema) & Collie Methodology
- Learn the Measures & Calculated columns formats of DAX language, and Naming Conventions and DAX Syntax,
- Practice case study applications to create Relationships, set up data models in the form of Collie Methodology, define Data tables Lookup tables.
Data Modeling & DAX 2

- Concept Filter Propagation, Cross-Filtering Visuals
- Concept Evaluation Context & Context Transition
Practice application of DAX function
- DAX topic: Calculated Columns
- DAX topic: SUM() function, COUNT() function, COUNTROWS() function, MIN() function, MAX() function, COUNTBLANK() function, DIVIDE() function
- DAX topic: CALCULATE() function
- DAX topic: IF() function, SWITCH() function, FIND() function
- DAX topic: VALUES() function, FILTER() function, ALL() function and DISTINCT() function
- DAX topic: ALLEXCEPT() function, ALLSELECTED() function
- DAX topic Relationship Functions RELATED() function, RELATEDTABLE() function
Data Modeling & DAX 3

- DAX topic Iterators SUMX() function, AVERAGEX() function, COUNTX() function, RANKX() function
- DAX topic Table manipulation: TOPN() function and SUMMARIZE() function
- DAX topic Time Intelligence: TOTALMTD() function, TOTALQTD() function, TOTALYTD() function, functions: SAMEPERIODLASTYEAR() function, PREVIOUSDAY() function, PREVIOUSMONTH() function, PREVIOUSQUARTER() function, PREVIOUSYEAR() function, NEXTDAY() function, NEXTMONTH() function, NEXTQUARTER() function, NEXTYEAR() function,
DATESBETWEEN()function, DATEADD() function, DATEDIFF() function, DATESMTD() function, DATESQTD() function, DATESYTD() function
Case study 1

- Practice Case study using Queries to process sales data, product categories, point of sale lists. Use Power BI to create Relationships and apply DAX to in-depth data analysis in Data Model
Case study 2

- Practice Case study using Queries to process sales data, product categories, point of sale lists. Use Power BI to create Relationships and apply DAX to in-depth data analysis in Data Model