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…
The video provides a walkthrough of how to analyze time sheet data of construction workers in NYC using Microsoft Excel and Power BI. It covers importing data from Excel, creating relationships between tables, building visualizations, and using slicers to filter data. The tutorial also demonstrates how to calculate weekly work hours and create charts to…
This video tutorial creates a beautiful HR performance dashboard in Power BI. The dashboard will include KPIs (Key Performance Indicators) such as female on board, engagement rate, and headcount. It will also use visuals like gauges, bar charts, slicers, and a map to represent the data. You will learn how to add images and format…
