Data Analysis using Power BI | DAX | Cloud Kitchen | SUMMARIZE | AVERAGEX | SUMX | FILTER | Excel

Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. [1] Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models. [2] In this video, we will be learning: • How to work with Power BI • How to create calculations using DAX functions • Approach of calculation in Excel with respect to DAX Timeline: • Introduction to the dataset - 0:41 • Power BI Connect to Data - 1:42 • Question 1: Most popular item - 3:35 • Question 2: Which Brand is the most popular? - 4:55 • Question 3: Which Partner had the most order? - 5:10 • Question 4: Which kitchen take longest time and shortest time to prepare? - 5:50 • Question 5: How much time does the most popular item take to prepare in different kitchen location? - 14:05 • Question 6: How many orders were prepared below and above the average preparation time? - 21:15 • Question 7: Distribution of final bill by brand - 24:25 How can Power BI help you? • Data analysis • Data visualization • Data manipulation * The information on the videos and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​ Source: 1. https://en.wikipedia.org/wiki/Microsoft_Power_BI 2. https://learn.microsoft.com/en-us/dax/