The project's goal is to collect the data from the Zomato database, clean the data, explore the required data with respect to company requirements, and then analyze the Pizza sales with respect to KPIs and create an interactive Dashboard using Power BI.
Step 1: Collect the necessary details about the Bank loan analysis report by the client.
Step 2: (Explore Process) Fletch the data from the client Database to "MS SQL Server".
Step 3: (Transform Process) Analyze, Clean, and Extract the required data according to "Key Performance Indicators (KPIs)".
Step 4: Deal with the null, missing, and error data to project requirements using "MS SQL Server or Excel".
Step 5: (Load Process) Load the clean and transform data into a "Power BI".
Step 6: Create a Dashboard according to the requirement in "Power BI".
-> Better decision-making with respect to Best-seller and Least-seller
-> Category-wise analysis like Pizza category and Date.
-> Helps to identify the weak area and work on that.
-> Optimize the sales performance.
