This tutorial explains how to create a flow map visualization in Power BI to show product exports from China to various countries around the world. It covers downloading a custom flow map visual, preparing the data, and using the visual to create a dashboard. Download Power BI File, Excel Dataset, and Custom Visual here:https://drive.google.com/file/d/1QIj81WICNFM7bWXnoomtvwXf5RZLs5z7/view?usp=sharing #PowerBI…
This video tutorial demonstrates how to use Power BI to perform a weighted decision matrix analysis on a set of projects. We start by loading an Excel file containing project details, criteria, scores, and weights. Then, we create a new table called “Weighted Score” and populate it with the product of score and weight for…
This tutorial explains how to use custom SQL queries in Power BI to manipulate data before loading it. It covers connecting to a SQL Server database, entering a custom SQL statement, and modifying the query afterwards. The video also demonstrates how this can be used to filter data based on specific criteria and create visualizations….
This video tutorial shows how to use Power BI to track Diversity, Equity, and Inclusion (DEI) initiatives using a RAG rating system (Red, Amber, Green). You’ll learn how to import data, create RAG symbol tables, connect them, and visualize progress with slicers, charts, and tables, all while ensuring the colors align with the RAG status…
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 video is part of a multi-part tutorial on using Power BI with a dataset called Indigino Technologies. In this particular part, you will learn how to create a Gantt chart to track the progress of orders. The video walks you through the steps of adding the necessary columns to your tables, formatting the data…
This video tutorial is about creating a dashboard to visualize sales data. It starts by calculating profit on each sale and then builds a dashboard with various elements. Slicers allow filtering by different categories, and gauges show the progress of different stages in the sales process. Cards display key metrics like the number of orders…
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 is a video tutorial about creating a report on tree statistics using Power BI. The video covers how to import and transform data, add images and backgrounds, create different visuals (slicers, bar charts, tree maps, card visuals), and format the report for better presentation. Link to dataset, power bi file, and images used:https://drive.google.com/file/d/1yRz7kM0ZGM0Mo9oeKBL9wSrrvoHYrGbE/view?usp=sharing #PowerBI…
This video tutorial shows how to include historical data into an existing dashboard that only has data for one period. It explains how to add a new year column to the data, incorporate it into the Power BI queries, and use slicers to view data for specific years. The video also covers how to create…