1. Executive Dashboard
Background
Samba commerce is one of the fast growing e-commerce in Brazil, having just launched in 2021. It offers over 15,000 products across more than 50 product categories to customers throughout the country. There are numerous internal and external variables that support their business growth. In 2022, the company plans to utilize more data to further support their growth.
Problem Definition
The CEO of Samba Commerce has requested to create a company wide dashboard with the main OKR is this year is about transactions.
Objective
Use Looker Studio & Tableau to create an advanced interactive dashboard that can be used to understand the business performance of Samba Commerce, with the main OKR (Objectives and Key Results) focusing on transactions.
Task & Actions
Result
From the created interactive dashboard, insights about Samba Commerce's transactions from Jan 2021 – Jan 2022 are as follows:
Samba Commerce acquired 48k customers within a year, with an average of one order per customer.
The city of Sao Paulo stands out as the top contributor to total orders, indicating a stronger presence for Samba Commerce compared to other cities in Brazil.
The 'bed table bath' category emerges as the best-selling category, accounting for 10% of all orders.
Total orders fluctuate with changes in the total payment value, and most orders consist of only one item.
While customers come from different parts of Brazil, only 6 states have an average of more than 10 customers per city, suggesting that the marketplace may not be widely known outside of those 6 states.
