Analyzing Kimia Farma Sales Performance with Google Cloud Platform

Description

This project is the final project of the Kimia Farma Big Data Analytics Project-based Internship, hosted by Rakamin. The aim is to conduct a comprehensive performance analysis of Kimia Farma's sales from 2020 to 2023, using Google BigQuery for data querying and Looker Studio for data visualization.

Problem statement

As Big Data Analytics Interns, we were tasked with evaluating Kimia Farma's business performance with a transaction or sales history over a 3 years period. This involved:

• Executing queries to create an analysis table or data mart in Bigquery.
• Developing a performance dashboard in Looker Studio.
• Presenting our findings to demonstrate our skills and analytical capabilities.

Objectives

The primary objectives of this project include:

• Importing essential tables and datasets into Bigquery.
• Creating an analysis table or data mart for further visualization.
• Designing an appealing and insightful Dashboard in Looker Studio.
• Representing the analytical journey and solvings of the Kimia Farma Sales Performance analysis project.

Datasets used in this analysis

The following datasets were used in this analysis:

• `kf_final_transaction`
• `kf_inventory`
• `kf_kantor_cabang`
• `kf_product`

---

About the Rakamin Project-based Internship

The Rakamin Project-based Internship, an official program partnered with Kominfo, provides candidates with real-world industry experience and mentorship. Thanks to Rakamin Academy and Kimia Farma for facilitating this invaluable learning journey, helping us hone our skills as Big Data Analysts in this competitive field.