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

Related Courses

Power BI for Business Analysts

  21 hours

Power BI for Developers

  28 hours

Creating Dashboards Using Microsoft Power BI

  14 hours

Power BI Dashboards

  14 hours

Power BI Dashboard Design

  7 hours

Data Analytics Process, Cloud Solutions, and Power BI Solutions

  35 hours

Excel to Power BI

  7 hours

Analyzing Data with Power BI

  28 hours

Advanced Power BI

  21 hours

PL-300T00: Microsoft Power BI Data Analyst

  21 hours

Power BI DAX Fundamentals

  21 hours

Business Intelligence in MS SQL Server 2008

  14 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 hours

Datameer for Data Analysts

  14 hours