Welcome to another Power BI tutorial! In this tutorial, we will guide you through the process of connecting Power BI Desktop to an online SQL server database. Below, you will find the server address, username, and password needed for the connection. To begin, click on the SQL server button located on the home tab to…
Welcome to another Power BI tutorial! In this video, we will show you how to create hierarchical data using DAX and how to use this data to create reports in Power BI. We will start by using an Excel file with four columns: ID, Account, Parent, and Amount. This is a simple Chart of Accounts…
In this video, we will explore the concept of small multiples, which is a series of similar graphs or charts using the same scale and axes, allowing them to be easily compared. We will create a dashboard using visuals with small multiple features and import data into Power BI Desktop using the “Get Data” feature….
In this video, we will perform financial ratio analysis using DAX in Power BI Desktop. We will use financial data of various companies to calculate typical ratios and create a dashboard comparing these ratios. These ratios will help us understand the overall picture of the industry as well as the individual performance of each company…
In this YouTube video, we will learn how to create a dashboard that displays the space usage of a SQL Server database using Python. This exercise was done based on a request by one of our users in the comment section. We hope we were able to give you some good ideas! To retrieve the…
The video tutorial is a step-by-step guide on how to create a dashboard on audit findings using Microsoft Power BI Desktop. The data used in the tutorial is an Excel file containing audit data of a food chain in 2022, which includes audit periods, start and end dates, status, percentage of completion, name of the…
The video is a tutorial on how to create a dashboard using the Enter Data feature in Power BI Desktop. The narrator explains that they will not be importing data from an external source, but instead, they will enter the data directly into Power BI Desktop through the Create Table window, where they can enter…
The video is a tutorial on how to create a dashboard using the Enter Data feature in Power BI Desktop. The narrator explains that they will not be importing data from an external source, but instead, they will enter the data directly into Power BI Desktop through the Create Table window, where they can enter…
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…
