Looker Studio for Data Visualization: Pakistan’s Largest E-Commerce Dataset

What is data visualization?

Data visualization is the graphical representation of information and data. By using visual elements like charts, graphs, and maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data. Additionally, it provides an excellent way for employees or business owners to present data to non-technical audiences without confusion. (Source: https://www.tableau.com/learn/articles/data-visualization)

What is Looker Studio?

Formerly known as Google Data Studio, Looker Studio is a data visualization platform that makes reports easier to create and understand.

It lets you to bring in sets of data from various places into one location so you can turn that information into an easy-to-understand report.

As a bonus, Looker Studio is free to use.

When you use Looker Studio, you can decide how you tell your “numbers” story to your clients. (Source: https://searchengineland.com/google-looker-studio-258871)

About Dataset

This is the largest retail e-commerce orders dataset from Pakistan. The data was collected from various e-commerce merchants as part of a research study. (Source: https://www.kaggle.com/datasets/zusmani/pakistans-largest-ecommerce-dataset)

The data has been modified with several changes to make it easier to practice using Looker Studio. I process this data as the final project of data analysis bootcamp. The price listed has been converted to 1 Rupee which is equal to Rp. 58. Regarding the explanation of the dataset is as follows:

Dear Data Analyst,

Menindaklanjuti meeting gabungan kemarin, kami akan membuat suatu dashboard untuk memantau dan mengevaluasi pencapaian penjualan tiap bulannya. Dalam dashboard tersebut akan terdiri dari 2 halaman dan dibuat dengan menggunakan lookerstudio.google.com.

Pada halaman 1, dapat memperlihatkan:

1. Hubungan antara Value Sales (before discount), Net Profit, dan AOV (average order value).

Note:

• Net profit = Value Sales (after discount) — (cogs * qty)
• AOV = Value Sales (before discount) / Total Unique Order.

3. Terdapat slicer Order Date, Category, Sales Value, Value Transaction, Payment.

Note:

a. Value Transaction:

• Valid → is_valid = 1
• Not Valid → is_valid = 0

b. Payment → payment_method

Pada halaman 2, dapat memperlihatkan:

1. Tabel berisi:

• Product Name
• Category
• Before Discount
• After Discount
• Net Profit
• Qty
• Customer (unique value)

2. Terdapat slicer: Order Date, Category, Value Transaction, Payment

3. Scorecard:

• Before Discount
• After Discount
• Net Profit
• Quantity
• Customer (unique value)
• AOV

Buat default tampilan dengan periode waktu sepanjang tahun 2022.

Terima kasih.

Regard,

Tim Marketing

Berikut dashboard berupa grafik value of sales, net profit, dan AOV selama tahun 2022:

Berikut sales detail berupa grafik selama tahun 2022: