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

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

Summary and Next Steps

Requirements

  • An understanding of basic data concepts
  • Experience with Excel or similar data tools
  • Familiarity with general business or operational analysis

Audience

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

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories


Fatal error: Uncaught TypeError: _isl_get_excluded_site(): Return value must be of type ?array, none returned in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc:38 Stack trace: #0 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(30): _isl_get_excluded_site() #1 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(17): isl_get_excluded_site() #2 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(51): get_outline_isls() #3 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(7): islc_prepare_links() #4 /apps/hitra7/npfrontend/nptemplates/default.php(272): islc7_sites_links_array_v3() #5 /apps/hitra7/npfrontend/modules/course/course.php(143): require_once('...') #6 /apps/hitra7/npfrontend/core/routes.php(15): course_menu_callback() #7 /apps/hitra7/npfrontend/__index.php(81): require_once('...') #8 /apps/hitra7/npfrontend/index.php(15): include_once('...') #9 /apps/hitra7/index.php(66): include_once('...') #10 {main} thrown in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc on line 38