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…
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…
The video is about creating a dashboard and exploring Dax query view in Power BI. The speaker first introduces the Dax query view, which is a new feature in Power BI desktop. Then he demonstrates how to load data into Power BI and create a dashboard with various charts. After that, he explains how to…
This video tutorial demonstrates how to create a project management dashboard using Power BI. The dashboard uses S-curve charts to visualize project progress. The video starts by explaining what S-curves are and their usefulness in project management. Then, it guides viewers through loading project data into Power BI and creating the dashboard with various charts…
This video tutorial is about creating a mobile-friendly dashboard in Power BI. It starts by guiding you through how to import data from a website and design visuals in the desktop layout view. Then it explains how to switch to the mobile layout view and arrange the visuals appropriately for mobile devices. Finally, it demonstrates…
This Power BI tutorial introduces new features like DAX Query View, New Card Visual, New Button Slicer, Visual Calculations, On Object Interaction, Build a Visual Button, Dynamic Values, Pane Switcher, Analyzer, etc. It then demonstrates how to create a dashboard using these features, explaining each step along the way. The video covers connecting to data,…
In this power BI visualization tutorial, we focus on comparing sales data from a vertical dataset across different years. Beginning with data transformation in the Power Query Editor, we progress to creating a comparative visual for a dashboard. Step by step, we navigate through loading data, adding visual elements like text boxes and line charts,…
This video tutorial explores various methods for generating data in Power BI without relying on external sources. It starts by highlighting the limitations of manual data entry and then introduces M language, a powerful tool for data manipulation and transformation. Different techniques are demonstrated, including creating lists, tables from rows or columns, and generating random…