Mavel Pizza Restaurant Analysis

Mavel Pizza Restaurant Analysis

Ashish Rawat Ashish Rawat

Ashish Rawat

Data Analyst | Excel | Power BI | Data Entry Operator | Surveyor | Team Lead

发布日期: 2023年10月29日
+ 关注

My submission on the Maven Pizza challenge. I performed a detailed analysis using Power BI to get insights on the Maven Pizza Dataset containing some csv files.

  • Average order price =16.50
  • Category of Pizza =32
  • Count of order =21.35k
  • Quantity of order = 50k
  • Sum of Sales = 817.86k
  • The column chart titled "Top 5 Pizzas by Quantity at Mavel Pizza Restaurant" visually represents the Qty of the top 5 pizzas.

  • The column chart titled "Top 5 Pizzas by Sales at Mavel Pizza Restaurant" visually represents the sales of the top 5 pizzas.

  • Bottom 5 Pizza by Quantity and sales

  • Sum of Quantity by month

In this chart we can observe how much quantity of sale month

  • Size By Quantity to watch what size have the most sales.

  • Sales By Category

In mavel Pizza Restaurant we have four categories(Classic,Supreme,Chicken,Veggie) and in this chart we can see the sales by category of pizza.

  • Quantity by Weekdays


要查看或添加评论，请登录

Ashish Rawat的更多文章

  • Customer Churn Analysis
    2023年10月6日

    Customer Churn Analysis

    In this report we analysis on Customer Churn We can see how many customers do we have and as we can see there are 10k…

社区洞察

其他会员也浏览了