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 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 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 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…
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…
This video is a tutorial on how to perform cost-benefit and payback analysis of a project using Power BI. It walks you through creating a table with initial cost, yearly cost, yearly benefit, and interest rate. Then it demonstrates how to calculate present value, cumulative present value, and net present value. Finally, it shows how…
This is a video tutorial about creating a real-time SQL Server dashboard in Power BI. Here’s a summary of the video: – We’ll build a demo project from scratch by creating a SQL Server database and table. – We’ll insert data repeatedly into the table. – We’ll create a dashboard in Power BI to display…
This video tutorial will guide you through using the new chart pane in Microsoft Excel Online to format and style your charts. What you’ll learn:Accessing the chart paneFormatting chart elements (title, legend, axis, gridlines)Data label optionsAdding error barsUsing trendlinesData table settings Video Outline:We’ll use sample data to create a chart.Pivot tables won’t work with the…