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...
Excel Tables are powerful data objects which make life easier for users. It improves data accessibility and analysis with the help of derived rows and columns. Before jumping to the benefits, I want to show how we convert data to an excel table. The sample data used in my example has been taken from https://www.contextures.com/xlsampledata01.html . Converting data to excel table - Select the data range, go to the Home tab in the ribbon, select Format as Table, and select any format. It will convert your data to an excel table object. This is what the converted table looks like - Benefits of this conversion - 1. Sorting and Filtering is more accessible - You can click on the small dropdown next to the column name that you want to sort or filter from. 2. Addition of rows and columns is easier - You can simply add adjacent rows and columns and excel will automatically make them a part of the table. 3. Frozen headers - Table headers are by default frozen. He...