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 provides a step-by-step guide on creating a custom Excel add-in using Visual Basic for Applications (VB.NET) and Microsoft Visual Studio. It starts with setting up the project in Visual Studio, then walks you through designing the add-in ribbon with buttons and options for formatting. Next, you’ll learn how to code the functionality behind…
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 pivot tables with images in Microsoft Excel, a newly introduced feature. It walks you through the process step-by-step, starting with creating a new sheet for photos and adding images of salespeople next to their names. Then it explains how to use VLOOKUP function to bring those photos into the…
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…
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,…
