Sales Data Report
Hello guys today I would like to make some report using Looker Studio use which is a free data visualization tool just by using google email.
So let’s go straight to the report creation !!
- The first step is to understand the data first. Here the data that I use is the data that I got after attending bootcamp in spreadsheet. This data describes incoming transactions for period of time from customers in a company
There are several columns in this data:
- transaction_payment_id = the id for each transaction that has been made
- transaction_id = id for the transaction
- payment_source = payment method used by customer
- sales_amount = total payment by customer
- payment_receive = payment received by the company
- transaction_date = datetime of the transaction
- date = date from transaction_date
- time = time from transaction_date
- user_id = id for customer who made the transaction
- level_user = level of customer loyalty
- discount = discount from sales_amount for customer
Go into the creation of each chart for the sales dashboard
FIRST CHART = COLUMN CHART
The first graph that I made will show the type of payment that is mostly made by customers so the data/column that I use is payment_source with an aggregate function of count
It can be seen in the graph above that there are five types of payments that can be made by customers to make transactions from 1, 2, 3, 4, and 5. Where payment method 1 is the most used method and is often used by customers with around 4127 users and payment method 5 is the type of payment with the smallest number of users of 2
SECOND CHART = STACKED COLUMN CHART
The second graph will show a comparison of the total amount of payments paid by customers with discounts given to customers compared to each month in 2022. This is done to show the total incoming transactions along with the discounts given to show the correlation between the two variables
From the graph above it can be seen that monthly sales are a stable number and also the discount amount does not really affect the total amount that comes in because it is not proven that the bigger the discount, the bigger the total that comes in
THIRD GRAPH = TIME SERIES CHART
The third graph will illustrate the total transactions obtained each week using the sales_amount column
From the graph above it can be seen that the total transactions that received by the company are quite stable
FOURTH GRAPH = STACKED COLUMN CHART
The fourth graph will show the total incoming sales from each month viewed from level_user
It can be seen from the graph above that users with level 3 dominate sales with a total that differs greatly from level 2 and also level 1 for every month
You can still add features such as controls and charts to Looker Studio like the example below where I added a control in the form of the month from date_of_transaction because Looker Studio is interactive on all the charts made on the dashboard and I also added summary info from the scorecard chart to make summarizing easier sales every month
Okay, that’s all from me for making a report with Looker Studio. Have a nice day 😎🥰🫠