Pizza Place Sales Analysis

-

 


A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients.

Recommended Analysis

  1. How many customers do we have each day? Are there any peak hours?
  2. How many pizzas are typically in an order? Do we have any bestsellers?
  3. How much money did we make this year? Can we indentify any seasonality in the sales?
  4. Are there any pizzas we should take of the menu, or any promotions we could leverage?
Tool: Power BI

Comments

Post a Comment

Popular posts from this blog

How to create a Word Cloud in R

-
Image
I have seen Word-cloud in so many places such as magazines, websites, blogs, etc. however never thought of making it by myself. I would like to thank R that taught me such a wonderful technique which everybody would like to learn. I don’t know if there are any other free options are available to create word-cloud. Let me give a quick explanation about R first, R is a free source packages and very useful for statistical analysis. We can use R for various purposes, from data mining to data visualization. Word-cloud is a tool where you can highlight the words which have been used the most in quick visualization. If you know the correct procedure and usage, then Word Cloud is simple in R Studio. Further, a package called “Word-cloud” is released in R, which will help us to create word-cloud. You can follow my simple four steps mentioned below to create word-cloud. Those are new to R or Word Cloud, I would suggest first install R studio from the link rstudio.com Also, the following...
Read more

Tour de France : History of Largest Sporting Event

-
Image
  Goal of the Project The goal of the project is to create an infographic-style visual to educate new viewers, highlight the magnitude of the event, and build anticipation for this year's Tour de France. This challenge requirement is different from others as here we are not getting any business insights or solution to do better. Here we have the information and we tried to spread information in easy and simple manner that more viewers can show interest in the coming years. As there are still many people has lack of knowledge about this event and access to watch this event (or lack of resources). What were business need The need is to create an infographic visual to educate new viewers about the world’s largest event Tour de France and 3.5 billion viewers were interested to watch from all around the world. My focus is to attract more viewers and provide base information or history that they don’t know. We are 8 billion population and we have to showcase this largest annual sporting ...
Read more

Maven Healthcare Challenge: Aug 2023

-
Image
In recent Maven Analytics challenge, we need to do analysis of hospital survey data. The data is about National & state-level scores from 2013 to 2022 for the Hospital Consumer Assessment of Healthcare Providers and Systems (HCAHPS) survey, a national, standardized survey of hospital patients about their experiences during a recent inpatient hospital stay. First know about, what is HCAHPS? The HCAHPS survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience. HCAHPS is a patient satisfaction survey that was developed by the Agency for Healthcare Research and Quality (AHRQ) in collaboration with Centers for Medicare and Medicaid Services (CMS) beginning in 2002. It was designed to help government agencies begin to collect ...
Read more

Great thought by Mrunal Nandankar

-
Success is not measured by how much a man has, But how much he has done, How far he has gone. Success is the basic human knowledge, Of how well a man has done. It is not taken lightly, Or as it shouldn't be. This is a serious task. One given to man by fate. Only you can determine your success. Only people can comment it. Push your self to the limit, Gas far as you can, Strive for it, For it is important, Your success. One of the most important traits of human kind, Taken for granted by the rich, And serious by the poor. We all have it in us, What it takes to be a success. We just have to reach in deep enough, And we will soon find the success in us, That has been lying there all a long. Success is key to all of life's compances, Enjoy it while it lasts. By Mrunal Nandankar...............
Read more

Fitness Tracker Dataset Challenge

-
Image
  About the Project: This is a fitness tracker product dataset consisting of different products from various brands with their specifications, ratings and reviews for the Indian market. The data has been collected from e-commerce websites namely Flipkart and Amazon using web scraping technique. This dataset contains 451 samples with 16 attributes. There are some missing values in this dataset. Tool Used: Power BI
Read more

A Key Challenge for Apple's Quest for Carbon Neutrality

-
Image
  The Goal of the project: To visualize Apple progress towards becoming carbon neutral in 2030. In 2020, after announcing their corporate operations were officially carbon neutral, Apple pledged to make their products carbon neutral by 2030. To achieve this goal, they set their emissions for 2015 (38.4 million metric tons CO2e) as the baseline and will aim to reduce them by 75% by 2030. The remaining 25% of gross emissions (9.6 million metric tons CO2e) will be removed using carbon offsets, bringing the net emissions to 0. To find out the how much carbon emission is already reduced by Apple in 2022 and how it going to reduce the remaining by 2030. Key Insights: Based on the data and analysis, i have found these below points: Apple has reduced its carbon emission in corporates operations by 2020 The top three highest emission segments are manufacturing, transportations and product use How Apple will reduce the remaining emission by 2030? Apple already implementation many transformat...
Read more

INDIA HAS BEEN WRONGLY PLACED AT 126TH RANK IN THE WORD HAPPINESS REPORT 2023

-
Image
  T h e World Happiness Report is an annual report published by the United Nations Sustainable Development Solutions Network. It ranks countries based on how happy their citizens perceive themselves to be and provides analysis of the factors that contribute to happiness, such as income, social support, and life expectancy. The 2023 World Happiness Report has been released, and it shows that Finland remains the happiest country in the world for the sixth year in a row. Denmark, Iceland, Israel, and the Netherlands are the next happiest countries, with other European countries such as Sweden, Norway, Switzerland, and Luxembourg also making the top 10. Now question raise here that how India’s position in the World Happiness Report has ranked at 136th place, despite having the world’s fastest-growing economy, India’s ranking in the report has consistently been low, leading some to question how it can be ranked lower than countries in turmoil.Despite the ongoing conflict between Russia ...
Read more

IT HELP DESK ANALYSIS

-
Image
When its about IT, how we can leave behind the IT help desk which is the major part of this industry. I found this data set interesting to analyze. There is two file one is Agent details and IT tickets data. The initial job had to do was the changes of the data as mentioned below: In the Tickets Table • The client requires the canvas settings of the PBI report to be H:1080 - W: 1920 • The client would like columns Severity and Priority to be split into 2 columns, creating an ID and classification columns. Example Severity Key column = 0 and Severity Type = Unclassified. • The Average Resolution time is 4.5 days. The Client would like to create a new column where if the Resolution time is above 3.5 days = "Outside SLA" and if it is below "Within SLA". This will allow the client to push for all calls to stay within the limit by targeting these calls and agents. In the IT Agents Table • Column Full Name to be split into 2 columns Name and Last Name, where last ...
Read more

Statistics One (Coursera)

-
Image
Assignment:4 Assignment 4 deadline got over today. So i am putting the assignment 4 questions and answers here. Hope it will help others to solve the questions.  setwd("  ") library(psych) PE=read.table("Stats1.13.HW.04.txt",header = T) describe(PE) #Question1: What is the correlation between salary and years of professional experience? cor(PE[2:4]) round(cor(PE[2:4]),2)            salary     years   courses salary  1.0000000 0.7448961 0.5410249 years   0.7448961 1.0000000 0.3336635 courses 0.5410249 0.3336635 1.0000000 > round(cor(PE[2:4]),2)         salary years courses salary    1.00  0.74    0.54 years     0.74  1.00    0.33 courses   0.54  0.33    1.00 #Question2: What is the correlation between salary and courses completed? round(cor(PE$salary, PE$courses),2) [1] 0.54 ...
Read more