Get in Touch

Course Outline

Introduction

Power BI Architecture

Data Sources

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

Data Modeling

Inter-table relationships (including single and multidirectional data filtering)

  • DAX - Exploring syntax and industry best practices
  • Introduction to DAX
    • Commonly used functions and the context of calculations
    • Handling the time dimension (covering fiscal periods, period comparisons, and Year-to-Date)
    • Functions for creating natural parent-child hierarchies
    • Filtering functions
    • DAX templates

Visualizations

  • Interactive data analysis
  • Selecting the most appropriate visualization type
  • Utilizing filters, grouping, and exclusions
  • Geospatial visualization on maps
  • Enhancing visuals with custom visual objects

Data Access Management - Row-Level Security

Collaboration and Mobile Usage with Power BI

  • Dashboards and reports
  • The Q&A mechanism
  • Workspaces and mobile applications

Summary and Next Steps

Requirements

  • A solid understanding of fundamental data concepts
  • Practical experience with Excel or comparable data management tools
  • Familiarity with general business or operational analysis

Target Audience

  • Business analysts
  • Data professionals
  • Individuals interested in utilizing data visualization tools to gain insights
 14 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories