Othamane/bank-reviews-morocco-dwh

Analyzing Customer Reviews of Bank Agencies in Morocco using a Modern Data Stack # Analyzing Customer Reviews of Bank Agencies in Morocco using a Modern Data Stack ## Student Profile **Name:** NOURDDINE Othmane **Program:** Master 2 – Systèmes d'Information et Systèmes Intelligents (M2SI) **Institution:** Institut National de Statistique et d'Économie Appliquée (INSEA) **Academic Year:** 2024-2025 **Project Type:** Data Engineering & Analytics Capstone Project ## Project Overview **Objective:** Collect, process, and analyze Google Maps reviews for bank agencies in Morocco to extract valuable insights using topic modeling, sentiment detection, and other key metrics. Build a fully operational data pipeline using modern tools for efficient data extraction, transformation, storage, and visualization. ## Table of Contents 1. Project Overview 2. Project Scope 3. Technology Stack 4. Project Roadmap 5. Deliverables --- ## Project Scope Banks receive thousands of customer reviews on Google Maps. These reviews contain valuable insights about customer satisfaction, service quality, and common issues, but they are unstructured and dispersed. This project centralizes, cleans, and analyzes these reviews to provide actionable insights. **Expected Insights:** * **Sentiment Analysis:** Trends in customer satisfaction over time. * **Topic Modeling:** Common praise points and recurring issues. * **Branch Performance:** Ranking of bank agencies based on aggregate sentiment. * **Customer Experience Metrics:** Identification of frequent complaints and satisfaction drivers. --- ## Technology Stack | Stage | Technology | | ------------------- | --------------------------------------------- | | **Data Collection** | Python, Google Maps API, BeautifulSoup/Scrapy | | **Scheduling** | Apache Airflow | | **Data Storage** | PostgreSQL (Data Warehouse) | | **Transformation** | DBT (Data Build Tool) | | **Analysis & BI** | Looker Stu …