Welcome to this Power BI tutorial where we’ll guide you through the process of hosting your Power BI reports on your own server. To achieve this, we’ll utilize Power BI Report Server, which can be conveniently downloaded from the Microsoft website. Simply navigate to the website, click on “advanced download options,” and then select the…
This tutorial addresses the common problem of missing data in time series visualizations, particularly when dealing with progressive or accumulative data in Power BI. It explains that while missing data points might appear as zeros in standard charts, this can lead to inaccuracies when values represent cumulative totals. The video demonstrates two solutions: first, filtering…
This tutorial guides viewers through creating a visually engaging PowerBI dashboard with an animated background. It begins by importing a sales dataset containing month, branch, sales, and profit data from an Excel file into PowerBI Desktop. The tutorial then demonstrates how to design a basic dashboard, including a title text box, a line and clustered…
This tutorial demonstrates how to integrate Google Forms responses with Power BI Desktop to create interactive visualizations. It covers creating a Google Form, collecting responses, and connecting the resulting spreadsheet to Power BI. The video then walks through building a dashboard with various charts to analyze the collected data, including using AI to calculate values…
This video tutorial demonstrates how to set up a real-time call center monitoring dashboard using Power BI and SQL Server. The data for the dashboard comes from call logs stored in a SQL Server database. The call logs include information such as the date and time of the call, the origin and destination of the…
This tutorial explains how to create a flow map visualization in Power BI to show product exports from China to various countries around the world. It covers downloading a custom flow map visual, preparing the data, and using the visual to create a dashboard. Download Power BI File, Excel Dataset, and Custom Visual here:https://drive.google.com/file/d/1QIj81WICNFM7bWXnoomtvwXf5RZLs5z7/view?usp=sharing #PowerBI…
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 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 video is part of a multi-part tutorial on using Power BI with a dataset called Indigino Technologies. In this particular part, you will learn how to create a Gantt chart to track the progress of orders. The video walks you through the steps of adding the necessary columns to your tables, formatting the data…