Get in Touch

Course Outline

Introduction

Power BI Architecture

Data sources

  • On-premises and online data sources
  • Data transformations + M language
  • Direct connections to selected sources (SQL Server, OLAP)

Modeling

Relationships between tables (single and multidirectional data filtering)

  • DAX - Understanding syntax and best practices
  • Introduction to DAX
    • Most commonly used functions and calculation contexts
    • Working with time dimensions (including fiscal periods, period comparisons, year-to-date)
    • Functions for normalizing parent-child hierarchies
    • Filter functions
    • DAX templates

Visualizations

  • Interactive data analysis
  • Selecting the appropriate visualization
  • Filters, grouping, and exclusions
  • Visualization on maps
  • Visualization enhancements (custom visuals)

Data Access Management - Row-Level Security

Collaboration and Mobile capabilities in Power BI

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

Summary and Next Steps

Requirements

  • A fundamental understanding of data concepts
  • Experience working with Excel or similar data tools
  • Familiarity with general business or operational analysis

Target Audience

  • Business analysts
  • Data professionals
  • Anyone interested in leveraging data visualization tools to gain insights
 14 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories