This video is a tutorial on how to use SQL query inside a Python script to extract data from a CSV file or any other data source, instead of using Power Query in Power BI Desktop. The video is divided into several sections. The first section explains that when using the Get Data feature in…
In this video, the presenter demonstrates how to calculate basic statistics using Python script in Power BI and create a dashboard from those statistics using Power BI visuals. The video starts with importing the Pandas library and reading data from an Excel file into a data frame. The presenter then calculates mean, mode, median, standard…
This is a tutorial video on how to create a simulation for real-time data connectivity and visualization using Power BI and SQL Server. The video is presented by a trainer who takes the viewer through the process step-by-step. The video starts by explaining the purpose of the simulation, which is to practice real-time data connectivity…
The video is a tutorial for creating a dashboard that explains seasonality and predicts future sales for a business based on their monthly sales data from 2010 to 2022. The video starts by introducing the data and showing charts of individual years that depict the trend of sales each year. The ups and downs observed…
This video tutorial is about creating paginated reports using SQL Server database in Power BI. Paginated reports are designed to be printed or shared, and are formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. Paginated reports also include charts, which can…
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 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…