This video is a tutorial on how to create a KPI (Key Performance Indicator) using SQL Server Database. The video starts with an introduction to KPI and its importance in evaluating progress towards measurable goals. Then the video demonstrates the steps to allow SQL server to use TCP port and IP address, which enables access…
This video tutorial explains how to create a simple dataset in Power BI Report Server. The tutorial covers the steps required to create a new folder, to place the dataset. The next step is to download and install Microsoft Report Builder. The tutorial shows how to download and install the Report Builder, which is required…
The video explains the process of installing and running a Power BI Report Server from a virtual machine. The video recommends running the Report Server from a virtual machine for better security. The video then explains the process of downloading and installing SQL Server Express, which is required to run the Power BI Report Server….
The video explains how to set up a virtual machine and install Windows 11 on it. A virtual machine is a software-based computer that provides an isolated environment for running an operating system or application. The reasons for using a virtual machine include security concerns, software testing, running an OS other than the host OS…
The video is a tutorial on how to use Pareto Charts in MS Excel and Power BI to analyze a hypothetical problem. The problem that is being analyzed is the reasons why people are late to their office. The video explains that a Pareto chart is a combination of bars and lines that displays percentages…
The video is a tutorial on how to simulate real-time performance monitoring of a call center using Python, Microsoft SQL Server, and Power BI. The video starts by explaining that the simulation will generate random calls from customers and store the call center information in a Microsoft SQL server database for performance monitoring. The speaker…
The video is a tutorial on how to create a dashboard to present financial data related to two options for starting a new project – buying machinery or renting it. The data, containing inflows and outflows for both options, is available in an Excel file. The video shows how to create a dashboard using Microsoft…
The video explains a step-by-step guide on how to display system performance information in real-time using Python, Microsoft SQL Server, and Power BI Desktop. The narrator explains that this exercise will help learners understand Python, SQL, and Power BI Desktop and how to connect the three major data science applications. The video begins by explaining…
This video tutorial is about Conditional Formatting in Power BI. The video starts by defining conditional formatting and its significance in data analysis. Conditional formatting is a feature in Power BI that allows users to format data based on specific conditions. It is used to highlight key insights in data and make it easier for…
The video is a tutorial on how to create a relational data model using Microsoft Excel. The tutorial begins with an introduction to the concept of a data model and proceeds to show how to convert Excel sheets into tables before defining relationships between the tables to create a data model. The speaker emphasizes the…
