Power BI Basics

Perform Time Series Anomaly Detection in Power BI

In this tutorial, we will show how to perform time series anomaly detection in Power BI to enhance your line charts and gain deeper insights into ...

Understand Metric-Driving Factors with Key Influencer Visualizations in Power BI

This tutorial will guide you to understand metric-driving factors with Key influencers visualizations in Power BI, by creating, interpreting, and ...

How to Calculate a Distinct Count in Power BI

In this tutorial, we will show how to calculate a distinct count in Power BI. With one click, you can see how many unique values exist in a column, ...

AI-Powered Multiple Dimension Visualizations with Decomposition Trees in Power BI

In this tutorial, we will explain how to create AI-powered multiple-dimension visualizations with Decomposition Trees in Power BI. We will also cover ...

Summarize Visuals and Reports with Smart Narrative in Power BI

In this tutorial, we will show how to summarize visuals and reports with smart narrative in Power BI. Let's explore how it works, how to configure it ...

5 Power BI Visualization Types That Excel Can’t Replicate (And Why They Matter)

In this tutorial, we will show 5 Power BI visualization types that Excel can’t truly replicate. We will also explain why they matter to help Excel ...

How to Create Dynamic Drill-Through Reports in Power BI

In this tutorial, we will show how to create dynamic drill-through reports in Power BI.

Visual Interactions in Power BI: How to Stop Charts From Talking to Each Other

In this tutorial, we will show how visual interactions work in Power BI and how to stop charts from talking to each other.

How to Use Excel PivotTables to Supercharge Power BI Analysis

In this tutorial, we will show how to use Excel PivotTables to supercharge Power BI analysis.

Power BI Row-Level Security Without Going Insane

In this tutorial, we will show how to implement Power BI Row-Level Security without going insane.

Making a Killer KPI Dashboard in Power BI with No Coding

In this tutorial, you’ll make a killer KPI dashboard in Power BI with no coding.

How to Pull Live Excel Data Into Power BI Dashboards

In this tutorial, we will show how to pull live Excel data into Power BI dashboards.

Why It’s Actually Easier to Build Complex Filters in Power BI Than in Excel

In this tutorial, we’ll explore why it’s actually easier to build complex filters in Power BI than in Excel.

Building Reports in Power BI, But Letting Users Explore in Excel

In this tutorial, we’ll show how to build a Power BI report and let users explore in Excel.

Building Hybrid Reports: When to Start in Excel vs. When to Start in Power BI

In this tutorial, we discuss when to start in Excel vs. when to start in Power BI by building a hybrid report.

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo