I will be sharing a very interesting project with you all, where I will use Power BI to analyze the data of a Meal Delivery organization and answer a few of their business questions. While creating the dashboard, I will touch upon a few concepts named 'Calculated Column', 'Calculated Measures', etc. Wherever needed, I will mention some GCPs (Good Case Practices) in the process. ABOUT DATA The data used in this analysis has been taken from the internet and has no direct reference to any organization. It consists of three CSV files - 1. DEMAND DATA - It contains the historical data demand of various products by the centers. 2. MEAL LOOKUP - It contains the details about individual meals. 3. CENTER LOOKUP - It contains information about the various centers delivering the meals. SOLUTION The very first step before we jump into any analysis is cleaning the data and creating the schema. I won't be covering the data cleaning and schema generation steps here as it goes...