Get in Touch

Course Outline

Overview

Power BI Structural Design

Connecting to Data Sources

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

Data Modeling

Table Relationships (single and multidirectional data filtering)

  • DAX - Mastering syntax and industry best practices
  • Introduction to DAX
    • Key functions and the context of calculations
    • Handling the time dimension (including fiscal periods, period comparisons, YTD)
    • Functions for naturalizing parent-child hierarchies
    • Utilization of filter functions
    • DAX template resources

Data Visualization

  • Performing interactive data analysis
  • Selecting the most suitable visualization type
  • Applying filters, grouping, and exclusions
  • Creating map-based visualizations
  • Enhancing visuals with custom visuals

Controlling Data Access - Row-Level Security

Collaboration and Mobile Capabilities in Power BI

  • Creating and managing dashboards and reports
  • Using the Q & A functionality
  • Workspaces and Mobile applications

Conclusion and Future Directions

Requirements

  • A foundational understanding of basic data concepts
  • Practical experience with Excel or comparable data tools
  • General familiarity with business or operational analysis

Target Audience

  • Business analysts
  • Data professionals
  • Individuals looking to leverage data visualization tools for gaining insights
 14 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories