Khóa học DAX Bootcamp toàn diện cho Power BI: Từ Cơ bản đến Nâng cao

Dive into the world of Data Analysis Expressions (DAX) in Power BI with my comprehensive course, designed to take you from fundamentals to advanced techniques. This course is ideal for those who have a basic understanding of data connecting and transformation fundamentals in Power Query, as well as data modeling basics (no worries even you don't have fundamental knowledge of data transformation and modeling, I have covered Data transformation and modeling fundamentals to get started DAX).

Course Highlights:

1. Fundamentals covered : Refresh your knowledge on data connecting and transformation fundamentals in Power Query and data modeling essentials to ensure a strong foundation.

   
   

2. DAX Essentials: Understand the DAX engine, including row context and filter contexts, and explore calculated tables, calculated columns, and measures. Learn the differences between implicit and explicit measures.

   
   

3. Aggregation Functions: Master core DAX functions for aggregation such as SUM, MIN, MAX, AVERAGE, COUNT, DISTINCTCOUNT, and COUNTROWS.

   
   

4. Advanced DAX Techniques: Delve into CALCULATE functions, context transition, and the use of variables and measure tables for dynamic calculations.

   
   

5. Iterator Functions: Learn to apply iterator functions like SUMX, MINX, MAXX, AVERAGEX, and COUNTX to iterate over tables and perform complex calculations.

   
   

6. Filter Functions: Utilize filter functions including FILTER, ALL, ALLEXCEPT, and ALLSELECTED to manage and manipulate data contexts.

   
   

7. Information Functions: Explore functions like SELECTEDVALUE, HASONEVALUE, ISBLANK, ISEVEN, ISODD, ISTEXT, ISFILTERED, CONTAINSSTRING, and ISINSCOPE for effective data evaluation.

   
   

8. Logical Functions: Apply logical functions such as IF, AND, OR, SWITCH, and COALESCE to create robust and dynamic expressions.

   
   

9. Mathematical Functions: Use mathematical functions like ABS, VALUE, MOD, ROUND, and DIVIDE for precise calculations and transformations.

   
   

10. Text Functions: Master text manipulation with functions such as CONCATENATE, CONCATENATEX, LEFT, RIGHT, UPPER, LOWER, LEN, REPLACE, SUBSTITUTE, and FORMAT.

    
    

11. Table Functions: Learn to handle tables with functions like CALCULATETABLE, DISTINCT, VALUES, SUMMARIZE, ADDCOLUMNS, SELECTCOLUMNS, UNION, and GENERATESERIES.

    
    

12. Relationship Functions: Understand relationship functions such as RELATED, RELATEDTABLE, USERELATIONSHIP, and CROSSFILTER for managing data relationships.

    
    

13. Ranking and Top N: Implement TOPN and RANKX functions to rank and filter top results in your datasets.

    
    

14. Time Intelligence Functions: Master time-based calculations using DAX functions like TODAY, DATE, NOW, CALENDAR, and CALENDARAUTO. Learn to manipulate and analyze dates with functions such as YEAR, MONTH, QUARTER, WEEKNUM, and perform advanced time period calculations with TOTALYTD, TOTALQTD, TOTALMTD, DATESYTD, DATESQTD, DATESMTD, DATEADD, PARALLELPERIOD, SAMEPERIODLASTYEAR, DATESINPERIOD, EDATE, EOMONTH, PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSDAY, NEXTYEAR, NEXTQUARTER, NEXTMONTH, NEXTDAY, STARTOFYEAR, STARTOFQUARTER, STARTOFMONTH, ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH, and DATEDIFF for comprehensive time-based analysis.

    
    

15. Calculation Groups: Learn how to create and manage calculation groups to streamline your DAX expressions and enhance reporting efficiency.

    
    

16. DAX Statements: Develop proficiency in writing and optimizing DAX statements for effective data analysis and reporting.

    
    

17. Visual Calculations: Enhance visualizations with calculations that include previous, next, first, last, collapse, expand, running sums, and ranges.

Additional Features:

• Tricks and Tips: Discover practical tips and tricks to streamline your DAX calculations and improve efficiency.

• Assignments: Apply your learning with hands-on assignments designed to reinforce key concepts and techniques.

• Solution Walkthroughs: Review detailed solutions to assignments, gaining deeper insights and understanding to enhance your skills.

  
  

By the end of this course, you’ll be equipped with the skills to leverage DAX effectively for powerful data analysis and reporting in Power BI..