Get in Touch

Course Outline

Introduction

Power BI Architecture

Data Sources

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

Modeling

Table relationships (single and multi-directional data filtering)

  • DAX - Grasping syntax and best practices
  • DAX Fundamentals
    • Commonly used functions and calculation contexts
    • Handling time dimensions (including fiscal periods, period comparisons, YTD)
    • Functions for creating parent-child hierarchies
    • Filter functions
    • DAX templates

Visualisations

  • Interactive data analysis
  • Selecting appropriate visualisation types
  • Filters, grouping, and exclusions
  • Map-based visualisations
  • Visual enhancements (custom visuals)

Data Access Management - Row-Level Security

Collaboration and Mobile Usage with Power BI

  • Dashboards and reports
  • Q&A mechanisms
  • Mobile applications for workspaces

Summary and Next Steps

Requirements

  • A foundational understanding of basic data concepts
  • Practical experience with Excel or similar data management tools
  • Familiarity with general business or operational analysis practices

Target Audience

  • Business analysts
  • Data professionals
  • Individuals looking to utilise data visualisation tools for strategic insights
 14 Hours

Testimonials (7)

Upcoming Courses

Related Categories