Project information

  • Category: Dashboard
  • Software: Microsoft Power BI
  • Project date: July, 2023

PIZZA SALES REPORT DASHBOARD

🎯 ABOUT DATASET: Pizza Sales Report helps us with interpreting organizational data. It finds the pizza sales trends in the data and allows the owner to take the appropriate steps to keep the sales running smoothly and profitably. This dataset includes 48620 columns which include pizza size, pizza category, pizza price etc.

🎯 STEPS FOLLOWED FOR CREATING THIS DASHBOARD:
  • Data transformation: Loaded the data into Power BI and removed null and duplicate values corrected spelling errors, and adjusted data types using Power Query.
  • Data-loading: The transformed data was loaded into Power View for further analysis.
  • Report: Created user-friendly reports and visualizations through the dashboard.
    • 🎯 DATA CLEANING AND PROCESSING: • Instead of loading the data to power bi, transform data which takes us into another window which is known as POWER QUERY. It is used to clean and transform the data.