SIÊU KHUYẾN MÃI 35% CHO KHÓA HỌC ANALYZING AND VISUALIZING DATA WITH POWER BI

Module 1

Load and Transform data

Module 2

Data Modeling

Module 3

Data Visualization

   Lessons

• Introduce Power Query Editor
• Shaping data
• Combining data

   Lab:

• Accessing Data
• Adding additional data
• Data Preparation
• Renaming tables
• Using Fill feature
• Using Split feature
• Using Rename Column feature
• Using Column from Examples feature
• Using Add/Remove Rows feature
• Using Transpose feature
• Using Append and Conditional Column feature

   Lessons

• Relationships
• Introduce DAX
• Calculated columns and measures

   Lab:

• Create relationships
• Create calculated columns within table
• Create measures:
  • Simple aggregations: SUM(), AVERAGE()
  • Filter functions: CALCULATE(), ALL(), ALLEXPECT()
  • Time Intelligence functions: PREVIOUSYEAR()

   Lessons

• Creating Power BI reports with visual
• Formatting visuals

   Lab:

• Building Power BI reports
• Drill through