This video tutorial explains how to create a Gantt chart in Power BI. It walks you through the data required, including tasks, start dates, and end dates. You can also include additional information such as projects, progress, resources, and milestones. The video also shows how to import a custom Gantt chart visual and configure it…
This tutorial creates a data model and visualizes a flow of orders in Power BI. Here’s a summary: – We start with 11 excel tables related to orders. – We import them into Power BI and create relationships between tables based on matching columns (e.g., product ID). – We use DAX queries to create new…
This video describes how to create a staff engagement dashboard in Power BI Desktop using sample staff engagement survey data. The data is first prepared in Excel and then transformed in Power BI to combine all percentages into a single column. The video then walks through the creation of various visuals like gauges, slicers, column…
The tutorial starts by guiding you through creating a table in SQL Server to store game data like turn number, player scores, and dice rolls. Then, it demonstrates writing DAX code in Power BI to calculate turn order, roll dice, update scores, and determine the winner. Finally, it shows how to create an interactive dashboard…
Welcome to another Power BI tutorial! In this tutorial, we’ll dive into the world of analyzing and presenting credit sales data, specifically focusing on transactions with doubtful or bad debts. We’ve got a robust dataset comprising over 14,000 credit sales transactions. This data includes essential details such as transaction ID, date, sales amount, days past…
Welcome to another Power BI Report Server tutorial! In this video, we’ll guide you through the process of creating a Key Performance Indicator (KPI) using a SQL Server database. For this exercise, we’ve uploaded the Adventure Works database to our server. If you’re already familiar with Power BI Report Server, you can easily access it…
In this video, we will explore the concept of small multiples, which is a series of similar graphs or charts using the same scale and axes, allowing them to be easily compared. We will create a dashboard using visuals with small multiple features and import data into Power BI Desktop using the “Get Data” feature….
In this video, we will perform financial ratio analysis using DAX in Power BI Desktop. We will use financial data of various companies to calculate typical ratios and create a dashboard comparing these ratios. These ratios will help us understand the overall picture of the industry as well as the individual performance of each company…
In this YouTube video, we will learn how to create a dashboard that displays the space usage of a SQL Server database using Python. This exercise was done based on a request by one of our users in the comment section. We hope we were able to give you some good ideas! To retrieve the…
The video tutorial is a step-by-step guide on how to create a dashboard on audit findings using Microsoft Power BI Desktop. The data used in the tutorial is an Excel file containing audit data of a food chain in 2022, which includes audit periods, start and end dates, status, percentage of completion, name of the…
