This is the final project for my Project-Based Intern as a Big Data Analytics at PT. Kimia Farma, Tbk (provided by Rakamin Academy). As a Big Data Analyst Intern who understands the sales data for each Brand at Kimia Farma, I was assigned to create a dashboard for sales reports in one year from the raw data that has been provided.
- PostgreSQL
- Google Data Studio
- Clean the raw data and create a datamart using PostgreSQL
- Create an aggregated dataset to make analysis process easier
- Create a dashboard based on the datamart
The dashboard was created by Google Data Studio here and this is the screen capture for the dashboard:
