In this Power BI tutorial, beginners learn the key differences between Power Query and DAX to understand when to use each engine effectively. Power Query serves as the primary ETL engine, utilizing the M language to clean, shape, structuralize, and transform raw data before loading it into the data model. It excels at foundational data…
In this hands-on Power BI tutorial, you’ll learn how to build an interactive Risk Matrix Simulation from scratch without relying on external datasets. Using DAX to generate dynamic tables and numeric range parameter sliders, you will model key risk factors including probability, impact, and remaining exposure to simulate real-world scenarios. We step through creating the…
Visual calculations, introduced by Microsoft in Public Preview in February 2024 for Power BI Desktop, revolutionized the way users manipulate data by simplifying complex reporting processes. Previously, achieving specific business metrics required an advanced understanding of intricate DAX concepts such as Filter Context, Row Context, and Context Transition, which often resulted in highly complex and…
Unlock the full potential of your data by mastering Time-Series Decomposition directly within Power BI. While standard line charts often conflate different signals, this tutorial shows you how to use the statsmodels library to “unmask” your metrics. You will learn to isolate the Trend, identify recurring Seasonality, and quantify the Residual noise that native visuals…
In this tutorial, we show you how to design a multi-page Power BI company performance dashboard from scratch. We start with a dataset in a pivoted, report-like format, which isn’t ideal for analysis. To fix this, we’ll walk you through the process of using the Power Query Editor to unpivot the data, making it much…
This tutorial guides users through creating a Power BI dashboard tailored for risk management professionals. The dashboard focuses on visualizing the capital adequacy ratio (CAR), a crucial metric calculated by dividing total capital (Tier 1 + Tier 2) by total risk-weighted assets. The explanation clarifies what constitutes risk-weighted assets, providing examples like cash (0% risk…
This tutorial explores methods for custom sorting rows, columns, and axes in Looker Studio when direct access to the data source is unavailable. Initially, a previous tutorial demonstrated sorting by adding new columns to the data source. However, for users without data source access, this tutorial offers two alternative approaches: blending data with a separate…
This tutorial demonstrates how to leverage multiple CSV files to construct a unified dashboard or report in Looker Studio. The key principle is to treat each new CSV file as an incremental update, where its data is appended to the existing information within Looker Studio. This approach is highly beneficial when you receive data in…
This video tutorial demonstrates how to connect to a MariaDB or MySQL server in Power BI using Direct Query with change detection for near real-time data updates. It explains the difference between MariaDB and MySQL, emphasizing the importance of using the correct connector. The tutorial guides viewers through downloading and installing the MariaDB connector, setting…
This tutorial explains how to sort data in Looker Studio in a custom order, beyond the standard alphabetical or numerical sorting. Using a hypothetical bank loan portfolio dataset from a Google Sheet (link in description), the tutorial walks through creating a Looker Studio report, connecting to the Google Sheet data source, and setting up the…
