Case Studies
Explore published data analytics, business intelligence, and automation case studies by Md. Masum Billah.
What is Business Inteligence?
Business Intelligence enables organizations to move from data overload to actionable insight, supporting smarter strategies and faster decisions.
Data Analysis & Storytelling for Better Decisions
Exploring how modern organizations turn raw data into actionable insights, smarter decisions, and measurable business outcomes.
How I Built a Fully Automated Blog Publishing System with Google Sheets and GitHub
Learn how I built a fully automated blog publishing workflow using Google Sheets, Apps Script, GitHub Actions, and GitHub Pages with automatic SEO generation.
PT CPI Sales Target & Gap Analytics Portal
A cloud-based sales target management and analytics platform built with Google Apps Script and Google Sheets. The system enables hierarchical target submission, sales performance tracking, gap analysis, KPI monitoring, and executive-level reporting across TSM, RSM, and Head Office teams.
Revenue Optimization & Customer Segmentation for a Telecom Giant
A comprehensive case study detailing how advanced data analytics, SQL, and Python were leveraged to optimize revenue streams and segment customer base for a leading telecom company, leading to a 20% increase in ARPU.
Strategic Business Intelligence: Transformational Data Analytics for Retail Giants
Exploring how advanced Business Intelligence, data analytics, and strategic reporting empower retail organizations to optimize performance, improve decision-making, and drive sustainable growth at scale.
Advanced Customer Churn Analysis for Retail Growth
An in-depth case study on using SQL and Python to identify at-risk customers and designing a data-driven retention strategy that saved $50k in potential revenue.
Optimizing E-commerce Sales using SQL & Power BI
A detailed case study on how I analyzed 1 year of sales data to identify churn patterns and increase revenue by 15%
Data Visualization Best Practices
Turning complex datasets into clear, compelling visual stories that improve understanding, reveal insights, and support better business decisions.
How I Automated Business Reporting and Saved Hours of Manual Work
Discover how workflow automation transformed a time-consuming reporting process into a streamlined system, reducing manual effort, improving accuracy, and saving valuable business hours.
Wealth OS – A Modern Personal Wealth Intelligence Platform Built with Next.js, Supabase & Vercel
Wealth OS is a modern Personal Wealth Intelligence Platform that helps individuals manage assets, investments, income, expenses, wallets, financial goals, and overall net worth from a single dashboard. Built with Next.js, Supabase, and Vercel.