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…
In this informative and practical YouTube video, viewers are guided through the process of using Power BI to analyze warehouse and retail sales data that is available online. The video begins by providing a link to the data and instructs viewers to download and save it to a directory on their computer. The video then…
Today we will use Data Analysis Expressions (DAX) to create columns and tables in the Power BI and use those tables to display visualizations. Excel file: https://docs.google.com/spreadsheets/d/1cSmnIs9vW6cyJ5Z-vf1IjV-Gb7vk7feD/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true Power BI File: https://drive.google.com/file/d/1FH8r45s8sO672lBCE0VVMwYw_PQyUD6J/view?usp=share_link #powerbi #dax
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…