McDonald's Food items Analysis Dashboard

Screenshot 2024-06-01 123933


About McDonald's :

  • McDonald's Corporation is an American-based multinational fast food chain, founded in 1940 in San Bernardino, California, United States. McDonald's is the world's largest restaurant chain by revenue serving over 69 million customers daily in over 100 countries in more than 40,000 outlets as of 2021. McDonald's is best known for its hamburgers, cheeseburgers and french fries, although their menus include other items like chicken, fish, fruit, and salads. McDonald's has been subject to criticism over the health effects of its products.
  • Key highlight of McDonald’s is that customers can select any item to view the complete nutritional information including calories, fat, sodium and Weight Watchers points. Customers can use calorie filter to find the McDonald’s menu item that best fits your diet.

Problem statement :

  • Ray Kroc wanted to build a restaurant system that would be famous for providing food of consistently high quality and uniform methods of preparation. He wanted to serve burgers, buns, fries and beverages that tasted just the same in Alaska as they did in Alabama. To achieve this, he chose a unique path: persuading both franchisees and suppliers to buy into his vision, working not for McDonald’s but for themselves, together with McDonald’s. Many of McDonald’s most famous menu items – like the Big Mac, Filet-O-Fish, and Egg McMuffin – were created by franchisees.
  • Analysis the given dataset and make different predictions and draw meaningful conclusion so that it should be benificial for both company as well as customer. Also state what can we learn from different predictions.





Dashboard

Screenshot 2024-06-01 125418

Cal Vs Nutrients

2

Fat%

3

Protein & Fat

4

Cholesterol

5

Vitamins

6

Iron

7

Suger & Carbs

8

Sodium

9

Dietary Fibre

10


Screenshot 2024-06-01 123911



Questions :

  1. What is the average nutrition values per category ?
  2. Which food items contains maximum amount of protein and less amount of fat ?
  3. Which food items contribute to high sodium intake ?
  4. Which category contribute to maximum % of Cholesterol in a diet (% daily value) ?
  5. Which 4 food items contain the most amount of Saturated Fat?
  6. Which food category and which food item contains maximum vitamins content ?
  7. Among chicken/fish and beef/pork, which food category is best for maximum protein intake ? why ?
  8. Among breakfast and salad which food category is good for daily nutrition fulfillment ?
  9. Adding beverage or tea to the meal, will it make significance difference to nutrition value ?


Business benefits of the analysis :

  • By analyzing nutrition value of the food items by the McDonald’s, it will be easier to the customer to plan their meal according to their requirement.
  • This analysis report can attract to the customer who is very health conscious and believe in the past criticism of the McDonald about unhealthy food items.
  • Customer who is on special diet due to different health problems such as overweight, vitamins deficiency anemia etc can also enjoy the McDonald’s food items by checking nutrition values of the food items.
  • This report may lead to company revenue growth. Also company reputation and legacy may save from further criticism over the food.