Advanced Power BI

About this Course

Power BI is a business intelligence and data visualization platform. It enables the creation of analytical reports and interactive dashboards using many different data sources.

The course focuses on advanced capabilities that PBI offers, including – complex visualizations, advanced data modeling, working with DAX, Python integration and more.

Audience

The course is mainly intended for analysts, data scientists and BI professionals who are experienced in Power BI and want to deepen their knowledge and enhance their capabilities

Prerequisites

Previous experience and background in Power BI

Module 1 - Advanced Visualizations

Group Categorical Data
Bin Numeric Data
Using Formulas
Dynamic Titles
Using the Analytics Pane
Custom Tooltips

Module 2 - Advanced User Experience

Create Report Drillthrough
Apply Filters
Create and Configure Buttons
Create and Configure Bookmarks
Create a State Analysis

Module 3 - Advanced Power Query

Chapter Introduction – Advanced Power Query
Custom Combine Files from Folder
Rebuild Combine Files from Folder
Running Totals
Grouped Index

Module 4 - Advanced Data Modeling & DAX

Build Dynamic Elements
DAX Functions for Advanced Data Modeling
Visual Dimension & Measure
Multi-Relationship Visual Dimension
Dynamic Date Hierarchy Drill
Dynamic Metric Selection
Create & Configure Filter Dimension in Power Query
Create the Category – Filter DAX Measures

Module 5 - Artificial Intelligence in Power BI

Generate a Summary with a Smart Narrative
Create & Configure Q&A Visual
Analyze to Explain the Increase or Decrease
Identify Key Influencers
Using Decomposition Tree
Detect Anomalies
Forecast Future Values
Generate Insights

Module 6 - Python Integration in Power BI

Download & Connect Python to Power BI
Create Data with a Python Script
Import External Data with Python
Run a Python Script in Power Query

Contact Us

Latest courses

About Us

UpScale Analytics specializes in training solutions for organizations and individuals in the fields of data.

UpScale Analytics is also one of the largest platforms in the world for learning SQL by doing.

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links

Upscale Analytics 2022 © All Rights Reserved