1 of 14

Iowa Liquor Sales

Data Analysis

Ummu Kalsum

2 of 14

Project Goal

Company wanted to improve customer satisfaction by understanding which product were most popular in January-December 2021

This will help us to:

Create a marketing campaign to increase sales for 2022

3 of 14

Defining �the Problems

4 of 14

The dataset used is a public dataset from Google Bigquery and data visualization using Google Data Studio.

5 of 14

1.Defining the Problems

There are two approaches, that we can do to solve a problem:

You can be a given a problem to solve or
You can given a dataset to find answers from data

In this case, we’re seeking for problems we can answer with these set of data.The first thing we should do is looking at the table schema and to see information are available.

6 of 14

Defining the Problems

1. How was the monthly trend of sales ?

2. How was our sales in Iowa’s city ?

3. Which category sales the most liquor ?

7 of 14

Exploring�Data

8 of 14

2. Exploring Data

We would like to answer several questions only for data from 2021 onward

9 of 14

Visualization�with �Insight

10 of 14

3. Visualization with Insights

Throughout Jan 2021- Dec 2021, our sales is growing constantly

October 2021 has the biggest ratio sale per year volume and January 2021 has the smallest ratio sale per volume.

This means, the bottle with higher price has better sales in October than any other month.

https://datastudio.google.com/reporting/1189272b-3e5d-42c2-ba74-992adec433e6

11 of 14

There are 6 cities with strong sales, Des Moines is city with the biggest sales

Other cities beside 6 cities has weak sales, it’s indicated by green color on heatmap

12 of 14

American Vodkas is the most selling category

In total, American vodkas is the most selling category, but for small size bottle, whiskey liqueur has the most bottle sold for it.

13 of 14

Recommended actions:

The company should focus on promoting and increasing sales of high-priced bottles during months with higher sales ratios, such as October.

The company should focus on increasing its marketing efforts in Des Moines, as it has the highest sales among the cities in Iowa.

The company should continue to prioritize the promotion and production of American Vodkas, as they are the best-selling liquor category.

Consider expanding whiskey liqueur line for small bottles: Given the strong sales for whiskey liqueurs in small size bottles, the company may consider expanding this product line to capitalize on this demand.