The Big Data Blog

How I turned 3 years of raw transaction data into a forward-looking planning tool for a tourism & travel company — with full code, real results, and honest limitations. The Problem Orient Group, a tourism and travel company in Egypt, had no systematic way to anticipate customer demand. Staffing decisions, marketing pushes, and operational planning were all reactive — made after the numbers came in, not before. The business question was simple to ask and hard to answer without

# مشروع التنبؤ بفقد العملاء — وصف المشروع والنتائج Project Overview & Results --- ## وصف المشروع | Project Description يهدف هذا المشروع إلى بناء نموذج تنبؤي قادر على تحديد العملاء الأكثر عرضة للانسحاب (الفقد) من خدمات الشركة. تم تطوير المشروع بالكامل باستخدام بيانات حقيقية مستخرجة من النظام الداخلي للشركة، وتغطي تاريخ حركة العملاء منذ عام 2023 حتى مايو 2026. This project aims to build a predictive model capable of identifying customers most at risk of churning from the compa

Data Analysis Reality Check "If A and B move together, does A cause B?" This question costs companies millions. I learned this the hard way analyzing real estate investments in Egypt. The Problem: Last year, I found something interesting: Real estate prices in Alexandria correlate +0.63 with USD strength. When the dollar goes up, property prices go up. Perfectly synchronized. My first thought? "USD strength drives real estate prices higher." Wrong. That's the correlation/caus

Project Abstract This investment model is designed to be fully adaptable to client requirements. The current configuration is set to an investment amount of 3.5 million and an investment cycle of 8 quarters. Both parameters can be easily adjusted upon request, ensuring flexibility and responsiveness to diverse client objectives. All analyses and dashboards are dynamically structured to update instantly—requiring only the input of the desired investment amount and period—pro

A comprehensive economic analysis project demonstrating ETL, data modeling, and strategic insight extraction from 10MB+ datasets. 📊 Project Overview This project analyzes 36 years of UK retail sector data to identify economic inflection points, compare real growth vs. inflationary effects, and evaluate business resilience across economic cycles. Key Finding: Large businesses maintained 4.41% average growth pre-2020, while small businesses showed 2.08% but greater agility dur

Context Sales analysis across three cities: Mandalay, Naypyitaw, and Yangon Focus on product lines, customer visits, income, and gender behavior Problem Statement Identify which cities and product lines drive sales and profit Understand customer behavior differences to support better decisions Objective Measure total sales, visits, and gross income by city Identify best-selling product lines Analyze purchasing behavior by gender Visual Insights Naypyitaw and Yangon outperform

Understanding Disney's Market Position Disney has long been a dominant player in the global film industry, with a portfolio spanning hundreds of movies and multiple genres. By 2016, Disney had produced 560 films , generating $69 billion in gross revenue. The company’s output covers a wide spectrum of genres—from Adventure and Comedy to Action and Musical—and a range of MPAA ratings. While some films achieve blockbuster success, others perform modestly, resulting in significa