DATA VISUALIZATION
Kimia Farma Sales Analytics
Turning pharmaceutical sales data into business insights.
Understanding Performance. PROJECT COVER COMING SOON
The Challenge
Analyzing pharmaceutical sales requires a clear view of sales trends, product performance, and regional revenue distribution. This project explores these areas through data preparation, SQL analysis, and interactive reporting.
My Contribution
- Processed and analyzed pharmaceutical sales data using Google BigQuery and SQL.
- Cleaned, transformed, and aggregated datasets to support accurate reporting and analysis.
- Developed SQL queries for data extraction and reporting automation.
- Built an interactive Looker Studio dashboard to visualize yearly sales performance, revenue distribution, and business KPIs.
The Solution
Google BigQuery and SQL were used to prepare and aggregate sales data for analysis. The results were presented in a Looker Studio dashboard to help users explore sales performance, product trends, and regional insights.
The Results
An interactive sales dashboard supported by SQL queries for data extraction and reporting. The dashboard provides a visual overview of yearly sales, revenue distribution, and business performance indicators.
Explore the Project
The dashboard and supporting materials will be linked here soon.