Get in Touch

Course Outline

Introduction

Power BI Architecture

Data Sources

  • On-premises and cloud-based data origins
  • Data transformation techniques + M language
  • Direct connections to specific sources (SQL Server, OLAP)

Modeling

Table relationships (single and multidirectional data filtering)

  • DAX - Mastering syntax and best practices
  • DAX Foundations
    • Essentially used functions and calculation contexts
    • Managing time dimensions (including fiscal periods, period comparisons, YTD)
    • Functions for establishing parent-child hierarchies
    • Filtering functions
    • DAX templates

Visualizations

  • Interactive data exploration
  • Selecting optimal visualization types
  • Applying filters, grouping, and exclusions
  • Geospatial data visualization
  • Enhancing visuals (including custom visuals)

Data Access Control - Row-Level Security

Collaboration and Mobility with Power BI

  • Dashboards and reporting capabilities
  • Q&A functionality
  • Workspaces and mobile applications

Conclusion and Future Directions

Requirements

  • Fundamental knowledge of data concepts
  • Practical experience with Excel or comparable data management tools
  • Basic familiarity with business or operational analysis processes

Target Audience

  • Business analysts
  • Data specialists
  • Professionals seeking to harness data visualization tools for strategic insights
 14 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories