/Project-Based-Intern-Kimia-Farma

This repository contains the documentation of creating the sales report dashboard Kimia Farma as the final project to complete the virtual internship experience by Rakamin

KimiaFarma Big Data Analytics Virtual Internship Program

  • Tools : MySQL Workbench
  • Visualization : Google Data Studio

Certificate : https://drive.google.com/file/d/1QlOeMth8cgC848ATdPXQTJfyZdOiglYd/view?usp=sharing

🚀 Description

PT Kimia Farma is a pharmaceutical company based in Indonesia. Kimia Farma is well-known as one of the manufacturers and distributors of pharmaceuticals, pharmaceutical products, and healthcare services in Indonesia. As a Big Data Analyst Intern who has a good understanding of sales data for each brand at Kimia Farma, I have been asked to create a dashboard from the sales data for the first half of the year at PT Kimia Farma using the provided raw data.

objectives: created design datamart (base table and aggregate table) and visualization dashboard using Google Data Studio.

🚀 Visualization

Visit the dashboard in Google Data Studio

Sales_Report_Dashboard_page-0001