Get in Touch

Course Outline

Introduction

Power BI Architecture

Data Sources

  • On-premises and cloud-based data sources
  • Data transformations and the 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 - Grasping syntax and adhering to best practices
  • DAX Fundamentals
    • Commonly used functions and calculation contexts
    • Managing the time dimension (covering fiscal periods, period comparisons, and YTD metrics)
    • Functions for normalizing parent-child hierarchies
    • Filtering functions
    • DAX templates

Visualizations

  • Interactive data exploration
  • Selecting the most suitable visualization types
  • Applying filters, grouping, and exclusions
  • Map-based visualizations
  • Enhancing visuals (including custom visuals)

Data Access Management - Row-Level Security

Collaboration and Mobile Capabilities in Power BI

  • Dashboards and reports
  • The Q & A mechanism
  • Mobile applications and workspaces

Summary and Next Steps

Requirements

  • A solid grasp of fundamental data concepts
  • Practical experience with Excel or comparable data management tools
  • General familiarity with business or operational analytics

Target Audience

  • Business analysts
  • Data professionals
  • Individuals seeking to leverage data visualization tools for deriving insights
 14 Hours

Testimonials (7)

Related Categories