This video tutorial introduces time intelligence calculations and their visualization using Power BI dashboards. It covers various time intelligence concepts, including time series, time bucketing, year-over-year comparison, moving averages, and year-to-date analysis. The tutorial demonstrates how to import data into Power BI, create different visualizations like pie charts and line charts, and perform calculations to…
This tutorial demonstrates how to create an animated Power BI dashboard showcasing Olympic javelin gold medalists. Starting with AI-generated data, we guide you through building a dashboard with key metrics like longest throw, athlete information, and historical performance trends. The process involves using various Power BI visuals, formatting for aesthetic appeal, and incorporating a play…
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….
Welcome to another Power BI tutorial! In this tutorial, we’ll dive into the world of analyzing and presenting credit sales data, specifically focusing on transactions with doubtful or bad debts. We’ve got a robust dataset comprising over 14,000 credit sales transactions. This data includes essential details such as transaction ID, date, sales amount, days past…
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…
The video is demonstrating how to use the forecasting feature in Power BI, a business intelligence and data visualization tool. The tutorial is using global temperature data to create a forecast. The speaker starts by importing historical temperature data and creating a dashboard with a title and a map chart that shows the average temperature…
In Power BI, grouping data allows you to combine multiple data elements into a single unit. This can be useful for summarizing and analyzing data in a more meaningful way. For example, you can group similar items, and display their data combined. In today’s tutorial, we will group fruits and non-fruit items, and display more…
Banks analyze there loans in several ways to minimize credit risk, one of them is loans cycle / loans classification / loans movement analysis. In these analysis, they try to make sense of data using aging buckets, and how loans move from one bucket to another, as periods change. In this demonstration, we have the…
Today we will show you how to: – Import data from MS Excel – Create dimensional model – Create relational data model – Create hierarchies – Create charts, diagrams, slices, matrix and maps – Create measures using Data Analysis Expressions (DAX) We will use Adventure Works sample data available at GitHub for this tutorial https://github.com/microsoft/powerbi-desktop-samples/blob/main/AdventureWorks%20Sales%20Sample/AdventureWorks%20Sales.xlsx…