Power Pivot is a powerful tool in Excel that allows you to work with large and complex datasets. It can import data from various sources and create data models with connected tables. You can also use DAX functions to create new columns and perform calculations. Finally, you can create pivot tables and charts to analyze…
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 describes the drawing tools available in Excel. It covers adding the Drawing tab to the ribbon if it’s missing, using pens, pencils, and highlighters to draw and erase, selecting drawings, and converting freehand drawings to clean shapes. It also explains how to use the action pen to write text and formulas directly…
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…
