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…
In this tutorial, we delve into the creation of HTML and JavaScript web applications, specifically focusing on generating Unicode symbols through interactive buttons and input fields. We explore how these symbols find utility in data presentation tools like Power BI. Beginning with the basic HTML structure, we proceed to integrate JavaScript to dynamically generate symbols…
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…
This video tutorial demonstrates how to create a simple HTML editor using AI and troubleshoot a minor functionality issue. AI tools like Gemini can generate the HTML, CSS, and Javascript code needed for the editor. The process involves asking the AI the right questions and making minor modifications to the code. The final product allows…
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…
Unicode characters are a special coding system that allows computers to display a vast variety of text and symbols from different languages. These characters are not images, but they can be used to represent images and even create fancy lists and other visual elements within your spreadsheets or dashboards. There are different Unicode codes for…
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 tutorial explains how to enable and use change tracking in SQL Server to monitor data changes in tables. It covers enabling change tracking on the database and table levels, querying change tracking information, and performing manual cleanup. The video also demonstrates how to combine information from the change tracking tables to get a comprehensive…