Course Code: powbidaxbesp
Duration: 14 hours
Prerequisites:
  • Basic knowledge of Power BI
  • Familiarity with the DAX language
Overview:

Objective: 

To equip participants with Power BI techniques focusing on DAX, data management,
and dashboard standardization.

Course Outline:

Day 1: Advanced DAX and Standardizing Dashboards


Morning Session: Mastering DAX for Advanced Users

  • Advanced DAX functions and expressions
    • Time intelligence functions
    • Conditional logic
    • Best practices for writing efficient DAX code


Afternoon Session: Dashboard Design and Standardization

  • Effective dashboard design and visual consistency
    • How to select chart types for high impact
    • Creating visualizations with actionable insight
  • Creating templates and enforcing standards across multiple developers
    • reusable templates with pre-set visual styles


Day 2: Data Management, Modeling, and Security

Morning Session: Effective Management of Data Sources and Modeling

  • Planning and optimizing data sources
  • Transforming data with Power Query
    • fixing errors in data, such as inconsistencies, duplicates, or missing values
    • remove and replace functions
    • split columns
    • grouping data
    • unpivoting data
    • data type conversions
    • custom columns
    • merging and appending queries

Afternoon Session: Ensuring Data Quality and Implementing Security

  • Data modeling techniques
    • Understanding the importance of table relationships
    • Creating complex joins
  • Techniques to monitor and report data quality
    • Developing and defining data quality metrics
    • Techniques for identify inconsistencies, duplicates, and outliers
    • Developing and implementing data quality dashboards