1 of 22

COOKIE SHOP ANALYTICS

​

Festus Ijabani || Data Analyst

2 of 22

CONTENT

PART ONE

Business Overview

​

PART TWO

Objectives

​

PART THREE

Targeted Analysis

​

PART FOUR

Insight

​

PART FIVE

Recommendations

3 of 22

01

PART ONE

Business Overview

​

​

A Cookie company "Cookie Crispy and tasty" wants to know the sales performance cookies between September 2019 to December 2020

4 of 22

02

PART TWO

​

Objectives

​

​

5 of 22

Objectives

​

  • Sales Trend Analysis

​

  • Product Performance

This approach helps pinpoint key sales drivers and informs better decision-making for future growth.

​

​

​

6 of 22

Tech Stack

The tech stack used for this analysis is PowerBi

7 of 22

03

PART THREE

​

Targeted Analysis

​

​

8 of 22

Could you provide the following breakdowns for analysis?

  • Units sold by product category
  • Monthly trends for expenses and profit
  • Expenses, profit, and revenue segmented by cookie type
  • Revenue distribution by customer name

​

9 of 22

10 of 22

11 of 22

12 of 22

13 of 22

There are 6 Cookie sold in this company

  • Over $1.13 million Unit of sold was sold in from september 2019 to December 2020
  • Over $4.69 million was made in Revenue
  • Over $1.97 million was recorded as Expenses
  • Over $2.7 million was recorded as Profit
  • The company made a total profit of over $2.7 million
  • Chocolate Chip was the most sold Cookie with over $338,239.50 cookie sold
  • Wisconsin and New York sold the most cookie
  • June and Oct 2020 were the highest selling months, September, December 2019, March, May, September and November 2020 were the least selling
  • Chocolate Chip Retailer made the most profit and units sold, Sugar and Fortune cookie Retailer did poorly

14 of 22

04

PART FOUR

​

Insight

​

​

15 of 22

  • Units sold by product category

From the chart, I can see the following product categories and their respective units sold:

  • Chocolate Chip: Around 338,239.50 units
  • Sugar: Approximately 168,783.00units
  • White Chocolate Macadamia: Around 162,424.50 units
  • Oatmeal Raisin: Roughly 155,315.00 units
  • Fortune Cookie: Around 154,198.00 units
  • Snickerdoodle: Slightly under 146,846.00 units

16 of 22

  • Monthly trends for expenses and profit

The chart presents monthly trends for expenses and profit over time. Key observations:

  • Profit (blue line) peaks in October 2019, June 2020, and October 2020, reaching highs of around 0.22M to 0.25M.
  • Expenses (orange line) remain more stable, typically fluctuating between 0.09M and 0.18M.
  • There is a noticeable seasonal pattern where profit surges around mid-year and towards the end of the year, while expenses show smaller fluctuations.

​

17 of 22

Based on the chart displaying expenses, profit, and revenue by cookie type:

  • White Chocolate has the highest revenue and profit, but also the highest expenses, indicating strong sales but also significant costs.
  • Oatmeal Raisin shows solid revenue and profit, with moderate expenses, suggesting it is cost-effective.
  • Chocolate Chip and Snickerdoodle generate noticeable profit and revenue, but with varying expense levels.
  • Sugar and Fortune Cookies have lower revenue and profit, along with relatively low expenses, indicating potential areas for strategic improvement.

Overall, White Chocolate and Oatmeal Raisin appear to be the top performers, while Sugar and Fortune Cookies may need further analysis to boost profitability.

​

  • Expenses, profit, and revenue segmented by cookie type

18 of 22

  • Revenue distribution by customer name

The funnel chart shows revenue distribution by customer name:

  • ACME Bites is the top contributor with $1.43M, accounting for the largest share of the revenue.
  • Wholesome Foods follows with $1.11M, and ABC Groceries with $0.90M.
  • Park & Shop Convenience contributes $0.73M, while Tres Delicious has the lowest revenue at $0.52M.

This indicates that ACME Bites is the most significant revenue source, while Tres Delicious may present an opportunity for growth.

​

19 of 22

  • At 338,239.50, Chocolate Chip had the highest Sum of Units Sold and was 130.34% higher than Snickerdoodle, which had the lowest Sum of Units Sold at 146846.
  • Chocolate Chip accounted for 30.04% of Sum of Units Sold.
  • Across all 6 Product, Sum of Units Sold ranged from 146846 to 338,239.50.



  • At 346,118.95, October had the highest Sum of Expenses and was 278.28% higher than May, which had the lowest Sum of Expenses at 91,499.15.
  • October accounted for 17.54% of Sum of Expenses.
  • Across all 12 Month, Sum of Expenses ranged from 91,499.15 to 346,118.95.
  • Sum of Expenses and total Sum of Profit are positively correlated with each other.



  • Chocolate Chip accounted for 37.35% of Sum of Profit.



  • At 2,176,922.15, Medium Order had the highest Sum of Profit and was 811.58% higher than Large Order, which had the lowest Sum of Profit at 238,806.68.



  • Small Order had 301,335.55 Sum of Profit, Medium Order had 2,176,922.15, and Large Order had 238,806.68.













​

20 of 22

05

PART FIVE

​

Recommendations

​

​

21 of 22

Recommendations

  • Promotions should be done in September, December 2019, March, May, September and November 2020

​

  • Adverts and Discounts sales should be done on other Cookie type to boost sales

​

  • Campaigns should be done in Washington and Alabama states

22 of 22

THANKS

​

By Ijabani Festus

​