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 (3)

Related Courses

Related Categories