This Power BI tutorial guides you through data modeling, focusing on the star and snowflake schemas. You’ll learn how to import an Excel dataset containing sales and related tables into Power BI, and then build both types of data models in the Model view. The key difference is explained: star schemas connect all dimension tables…
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 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 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 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 tutorial creates a data model and visualizes a flow of orders in Power BI. Here’s a summary: – We start with 11 excel tables related to orders. – We import them into Power BI and create relationships between tables based on matching columns (e.g., product ID). – We use DAX queries to create new…
This video describes how to create a staff engagement dashboard in Power BI Desktop using sample staff engagement survey data. The data is first prepared in Excel and then transformed in Power BI to combine all percentages into a single column. The video then walks through the creation of various visuals like gauges, slicers, column…
The tutorial starts by guiding you through creating a table in SQL Server to store game data like turn number, player scores, and dice rolls. Then, it demonstrates writing DAX code in Power BI to calculate turn order, roll dice, update scores, and determine the winner. Finally, it shows how to create an interactive dashboard…
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…