Popular repositories Loading

1. SQL_Data_Warehouse_Project SQL_Data_Warehouse_Project Public

   Membangun data warehouse modern menggunakan SQL Server yang mencakup proses ETL, pemodelan data, serta analisis data untuk mendukung kebutuhan bisnis.

2. Python_Ads_performance_Analyst Python_Ads_performance_Analyst Public

   Analisis performa iklan digital 6 klien agency sepanjang 2023 (4.380 baris) pakai Python & pandas. Temuan: 50% budget parkir di objective tanpa revenue, campaign Sales sebenarnya untung ROAS 1,62, …

3. SQL_Kimia-Farma-Analyst SQL_Kimia-Farma-Analyst Public

   Analisis kinerja bisnis Kimia Farma 2020–2023 atas 672.458 transaksi di 1.725 cabang. Pipeline Medallion SQL (Bronze–Silver–Gold) + dashboard Power BI. Temuan: margin stabil 28,4% tapi pendapatan s…

4. SQL_MidleStore SQL_MidleStore Public

   Analisis profitabilitas retail: bongkar kebocoran margin akibat diskon pakai Medallion SQL Server & Power BI.

5. Excel_Ads_Performance Excel_Ads_Performance Public

   Dashboard iklan digital interaktif dibangun murni di Excel: 4 dropdown filter + engine array formula dinamis atas 4.380 baris data 2023. Temuan: blended ROAS 0,81 menyesatkan — campaign Sales untun…

6. SQL_Sakumaya-Bank-Digital-FinTech- SQL_Sakumaya-Bank-Digital-FinTech- Public

   Financial health analytics bank digital atas 1.000 nasabah & 10.000 transaksi (2022–2025). Pipeline Medallion SQL (bronze–silver–gold, 19 view) + dashboard Power BI. Temuan: GMV stagnan 38 bulan, R…