Data Analytic

Proyek ini bertujuan untuk menganalisis performa bisnis Kimia Farma tahun 2020-2023, dengan fokus pada: Customer Lifetime Value (CLV) untuk memahami pola loyalitas pelanggan Tren penjualan dan profitabilitas Segmentasi pelanggan berdasarkan frekuensi transaksi & nilai pembelian Korelasi antara diskon, nett sales, dan profit Analisis performa cabang dan kepuasan pelanggan berdasarkan rating Proyek ini menggunakan Google BigQuery untuk pemrosesan data dan Tableau/Looker […]

This SQL project explores a movie database using queries to find characters, analyze genres, and determine actor involvement. Key features include identifying the most popular genre, highest and lowest rated movies, and actors in multiple films. SQL joins, grouping, and aggregate functions are utilized to gain insights efficiently.

In this case study, I performed a detailed analysis of retail product sales data to extract meaningful insights using Python. This article walks through the process, the techniques employed, and the key findings.