Course Outline

Introduction

  • Overview of Power BI features and architecture
  • Advanced tools and data analysis in Power BI

Getting Started

  • Installing Power BI and other components
  • Data strategies for efficiency
  • DAX language fundamentals

Managing Data

  • Querying and aggregating data
  • R integration and M query
  • Importing and transferring data
  • Pivoting and unpivoting data
  • Transposing and joining data tables
  • Tips and tricks on advanced functionalities

Advanced Data Modeling

  • Working with tables and dimensions
  • Defining data granularity
  • Working with relationships and cardinality
  • Creating measures using DAX
  • Optimizing models for performance
  • Fixing common issues in modeling

Advanced Rules and Calculations using DAX

  • Creating tables using a formula
  • Applying conditional functions
  • Filtering multiple tables
  • Working with disconnected tables
  • Working with variables in DAX
  • Calculating and filtering context
  • Working with dynamic measures

Advanced Visualizations, Reports, and Dashboards

  • Visualization types in Power BI
  • Customizing visual elements
  • Creating Power BI maps visualization
  • Creating Power BI visuals with R
  • Using filters and slicers in reports
  • Enhancing visual elements for reports
  • Creating an automated flow with Power Automate
  • Creating Q&A visual in reports
  • Optimizing dashboards for mobile devices
  • Tips for designing effective dashboards

Working with Embedded Analytics in Power BI

  • Setting up the analytics environment
  • Exploring Power BI REST APIs and client APIs
  • Practical examples and use cases

Troubleshooting

Summary and Next Steps

Requirements

  • Experience with Power BI
  • Familiarity with DAX language

Audience

  • Business analysts
  • Data analysts
  • Developers
  21 Hours
 

Testimonials



Related Courses

Big Data Business Intelligence for Govt. Agencies

 35 hours

Big Data Business Intelligence for Criminal Intelligence Analysis

 35 hours

Business Intelligence in MS SQL Server 2008

 14 hours

Big Data Business Intelligence for Telecom and Communication Service Providers

 35 hours

Datameer for Data Analysts

 14 hours

Power BI Dashboards

 14 hours

Data Analytics Process, Cloud Solutions, and Power BI Solutions

 35 hours

Excel to Power BI

 7 hours

Power BI for Business Analysts

 21 hours

Creating Dashboards Using Microsoft Power BI

 14 hours

Power BI Dashboard Design

 7 hours

Analyzing Data with Power BI

 28 hours

Power BI

 14 hours

Power BI for Developers

 28 hours

PL-300T00: Microsoft Power BI Data Analyst

 21 hours