Amal-Elbahari/morocco-bank-reviews-pipeline
Domain:
natural language processingRecord type:
project
Creator:
Ama
Host:
Data pipeline for analyzing Moroccan bank reviews using Google Maps data, DBT transformations, PostgreSQL star schema, and Airflow automation. Includes a Looker Studio dashboard for insights on customer sentiment and branch performance.
# Analyzing Customer Reviews of Bank Agencies in Morocco
This project aims to collect, transform, and analyze customer reviews from Google Maps about Moroccan bank agencies, using a **modern data stack** for end-to-end data processing.
## 📌 Objective
Extract insights from unstructured customer reviews to:
- Understand customer sentiment.
- Detect recurring topics and issues.
- Rank agency performance.
- Improve customer experience through data.
---
## 📐 Project Scope
Banks in Morocco receive thousands of reviews on Google Maps. These reviews contain valuable information but are unstructured and spread across locations. This project centralizes, cleans, and analyzes that data.
### ✨ Key Insights
- 📊 Sentiment trends across agencies
- 🔍 Topic modeling for complaints and praise
- 🏅 Performance ranking of branches
- ✅ Key drivers of satisfaction and dissatisfaction
---
## ⚙️ Tech Stack
| Stage | Tools Used |
|------------------|------------------------------------------|
| Data Collection | Python, Google Maps API, BeautifulSoup |
| Scheduling | Apache Airflow |
| Storage | PostgreSQL |
| Transformation | DBT (Data Build Tool) |
| Visualization | Looker Studio |
| Version Control | Git + GitHub |
---
## 🚀 Project Pipeline
### ✅ Phase 1: Data Collection
- Scraped reviews from Google Maps.
- Stored raw data in JSON/CSV.
- Automated with Apache Airflow.
### ✅ Phase 2: Data Cleaning & Enrichment
- Removed duplicates, normalized text.
- Applied sentiment analysis.
- Extracted topics with LDA.
### ✅ Phase 3: Data Modeling
- Star Schema in PostgreSQL:
- `fact_reviews`
- `dim_bank`
- `dim_branch`
- `dim_location`
- `dim_sentiment`
### ✅ Phase 4: Visualization
- Built dashboards in Looker Studio:
- Sentiment trends
- Top positive/negative topics
- Agency rankings
### ✅ Phase 5 …