Course Outline

Power BI Architecture

Data sources

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

Modeling

Relationship between tables (single and multidirectional data filtering)

  • DAX - Understanding the syntax and best practices
  • Introduction to DAX
    • Most commonly used functions and context of calculations
    • Working with the time dimension (including fiscal periods, comparing periods, YTD)
    • Functions for naturalizing a parent-child hierarchy
    • Filter functions
    • DAX templates

Visualizations

  • Interactive data analysis
  • Select the appropriate visualization
  • Filters, grouping, exclusions
  • Visualization on maps
  • Visualization enhancements (so-called custom visuals)

Data Access Management - Row-Level Security

Team work and mobile with Power BI

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

 

 

 14 Hours

Testimonials (5)

Related Courses

Advanced Power BI

21 Hours

Data Analytics Process, Cloud Solutions, and Power BI Solutions

35 Hours

PL-300: Microsoft Power BI Data Analyst

21 Hours

Excel to Power BI

7 Hours

Power BI - Advanced

14 Hours

Power BI Dashboards

14 Hours

Creating Dashboards Using Microsoft Power BI

14 Hours

Power Apps

21 Hours

Microsoft Power Automate

14 Hours

Power BI: Basics to Advanced

35 Hours

Power BI Dashboard Design

7 Hours

Power BI DAX Fundamentals

21 Hours

Power BI for Business Analysts

21 Hours

Power BI for Developers

28 Hours

PowerBI Integration with SAP Business One

21 Hours

Related Categories