Get in Touch
 Duration 14 hours

Course Outline

Review of Principles and Data Model Design

  • Exploring the data modeling layer within Power BI
  • Concepts of star and snowflake schemas
  • Establishing and managing inter-table relationships

Foundations of DAX (Data Analysis Expressions)

  • DAX syntax and supported data types
  • Distinguishing between calculated columns and measures
  • Key DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX Applications and Business Logic

  • Time intelligence functions (YTD, MTD, QTD)
  • Incorporating conditional logic and dynamic calculations
  • Calculating rankings, running totals, and comparative metrics

Data Transformation and Performance Optimization

  • Utilizing Power Query for advanced data transformations
  • Efficiently integrating multiple data sources
  • Enhancing performance through query folding and optimized relationships

Advanced Visualizations and Interactive Features

  • Implementing custom visuals and marketplace extensions
  • Using drill-downs, bookmarks, and what-if parameters
  • Constructing paginated and dynamic reports

Performance Management and Governance in Power BI

  • Best practices for maintaining datasets
  • Optimizing refresh schedules and query execution
  • Enforcing row-level security (RLS)

Practical Project: Constructing a Sales Intelligence Dashboard

  • Creating KPIs utilizing DAX measures
  • Designing model-driven dashboards to drive business insights
  • Applying governance and data sharing best practices

Wrap-up and Future Recommendations

Requirements

  • A solid grasp of the Power BI interface and report creation workflows
  • Practical experience in building dashboards within Power BI
  • Foundational knowledge of data relationships and filtering mechanisms

Target Audience

  • Business intelligence professionals
  • Data analysts and reporting specialists
  • Developers focused on data visualization and analytics

Number of participants


Price per participant

Testimonials (4)

Upcoming Courses

Related Categories