Portfolio – Page 2 – Hijirs Data Portfolio – Analytics, BI, Data Science & Engineering

Kimia Farma CLV & Sales Analysis

Leave a Comment / Data Analytic, Portfolio / Hijir

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 […]

Kimia Farma CLV & Sales Analysis Read More »

Optimization Strategy for Sales and Customer Loyalty at Kalbe Nutritionals

Leave a Comment / Business Intelligence, Final Project, Portfolio / Hijir

This project analyzes Sales, RFM, Cohort, Churn, and CLV using SQL, Python, and Tableau to help Kalbe Nutritionals understand sales trends, customer segmentation, and retention strategies.

Optimization Strategy for Sales and Customer Loyalty at Kalbe Nutritionals Read More »

Automating School Data ETL from API with Apache Airflow

Leave a Comment / Business Intelligence, Portfolio / Hijir

Business Intelligence project: showcasing an Airflow ETL pipeline to automate the extraction of school data from an API, apply transformations, and load the data into a PostgreSQL database. Includes Python scripts for ETL, detailed documentation, and examples.

Automating School Data ETL from API with Apache Airflow Read More »

Exploratory Data Analysis (EDA) of Bank Marketing Campaign

Leave a Comment / Business Intelligence, Data Analytic, Portfolio / Hijir

Business Intelligence Project: Analyze marketing campaign impact on term deposits using EDA, correlation, chi-square tests, and linear regression.

Exploratory Data Analysis (EDA) of Bank Marketing Campaign Read More »

Exploratory Data Analysis (EDA) for House Prices

Leave a Comment / Business Intelligence, Data Analytic, Portfolio / Hijir

Analyzing housing data using Python with EDA, data preprocessing, and statistical methods. Includes Pearson Correlation, Chi-Square Test, Linear Regression, T-Test, and ANOVA to explore trends, correlations, and hypothesis testing.

Exploratory Data Analysis (EDA) for House Prices Read More »

Automating ETL with Stored Procedures in PostgreSQL

Leave a Comment / Business Intelligence, Portfolio / Hijir

Automate your ETL process using PostgreSQL stored procedures! This project showcases the implementation of dwh.generate_sales(), a robust ETL solution that extracts, transforms, and loads sales data efficiently. Learn how to structure transactional, staging, and data warehouse schemas for optimized reporting and business intelligence.

Automating ETL with Stored Procedures in PostgreSQL Read More »

Designing a Data Warehouse for Employee Performance Analytics

Leave a Comment / Business Intelligence, Portfolio / Hijir

Explore a comprehensive Data Warehouse design for employee performance analytics, leveraging the star schema approach. Discover insights on employee performance by department, education level, and gender, with actionable recommendations for HR decision-making.

Designing a Data Warehouse for Employee Performance Analytics Read More »

Sales Data Warehouse Design: A Coffee Shop Case Study

Leave a Comment / Business Intelligence, Portfolio / Hijir

Optimized Sales Data Warehouse Design for a coffee shop business using a Star Schema approach. Includes ERD, data marts, SQL queries, and insightful business analysis to improve store performance, product sales, and sales trends. A must-have BI project for data-driven decision-making!

Sales Data Warehouse Design: A Coffee Shop Case Study Read More »

Bus Travel Data Warehouse

Leave a Comment / Data Engineering, Portfolio, Uncategorized / Hijir

Data Engineering project focused on designing a Star Schema for a bus travel agent dataset using Kimball’s methodology. Includes ERD creation, identification of slowly changing dimensions (SCD), defining fact tables, and illustrating a Star Schema to support data analysis, reporting, and historical data tracking.

Bus Travel Data Warehouse Read More »

Automated ETL Workflow with Airflow – MySQL to PostgreSQL

Leave a Comment / Data Engineering, Portfolio / Hijir

For this Data Engineer project, I implemented a testing workflow for Airflow DAGs. The project involves creating more than 5 tables in MySQL, extracting data to PostgreSQL, and managing the pipeline with dynamic DAGs. Jobs are scheduled to run every 2 hours between 9 AM and 9 PM on Fridays, twice a month (week 1 and week 3), at the 15th minute.

Automated ETL Workflow with Airflow – MySQL to PostgreSQL Read More »