Sales Report PT Kimia Farma

Work Environment

Tools : PostgreSQL, Google Slides
Programming Languange : SQL
Visualization : Google Data Studio
Dataset : penjualan, pelanggan, barang

Introduction

A Virtual Internship Experience Big Data Analytics in Kimia Farma facilitated by Rakamin Academy. In this project, as a Big Data Analyst Intern from Kimia Farma I learned about data warehouse, data lake, and data mart. I also sharpening my skill in SQL. At the end of the project, I asked to build a sales dashboard using Google Data Studio with the following real case dataset from Kimia Farma.

Problem Statement

Analyzed Kimia Farma Sales in a year.

Objective

Created a data mart to set as visualization dashboard using Google Data Studio.

Created Data Mart

1. Firstly, I queried the 3 dataset to be 1 table as base table and determine the primary key by concatenate the id_invoice and id_barang.
2. After created base table, I create the aggregate table which sum of the jumlah_barang multiple harga. Exported the aggregate table to CSV for data source in Google Data Studio.

Visualization

Lastly, I built a dashboard using data source from aggregate table in Google Data Studio. You can check and using it as you need here.

Figure 1: Sales Reports PT Kimia Farma