Jaki77/customer-experience-analytics

Customer Experience Analytics for Fintech Apps — A data engineering and NLP project analyzing Google Play Store reviews of Ethiopian banking apps (CBE, BOA, Dashen). Includes web scraping, preprocessing, sentiment analysis, thematic clustering, PostgreSQL storage, and insight visualization for stakeholder reporting. # 📊 Fintech Mobile App Review Analysis — 10 Academy Week 2 This project analyzes customer experiences of major Ethiopian banking mobile apps by scraping, preprocessing, analyzing, and visualizing Google Play Store reviews. ## ⭐ Project Overview Mobile banking apps are central to Ethiopia’s digital financial ecosystem. Understanding user sentiment, key frustrations, and UX gaps can meaningfully improve product decisions. This project builds a **data pipeline** that: 1. **Scrapes reviews** from the Google Play Store 2. **Preprocesses and cleans raw user feedback** 3. **Conducts exploratory data analysis (EDA)** 4. Performs **sentiment analysis**, **topic modeling**, and **insight reporting** 5. **Identify drivers** and pain points in mobile banking apps 6. **Store cleaned data** in PostgreSQL database 7. **Deliver actionable insights** with visualizations and recommendations ## 🏦 Banking Apps Analyzed | Bank Code | App Name | App ID | |----------|---------------------------------|---------------------------------------------| | CBE | Commercial Bank of Ethiopia | `com.combanketh.mobilebanking` | | BOA | Bank of Abyssinia | `com.boa.boaMobileBanking` | | Dashen | Dashen Bank | `com.dashen.dashensuperapp` | App IDs are read dynamically from `.env`. ## 🧱 Repository Structure ``` . ├── .github/ │ └── workflows/ │ └── unittest.yml │ ├── .vscode/ │ └── settings.json │ ├── data/ # Data storage │ ├── raw/ # Raw scraped data │ ├── processed/ # Cleaned and processed data │ ├── analysis/ # Analysis results │ └── database/ # Database documentation │ ├── notebooks/ │ ├── __init__.py │ ├── preprocessing_EDA.ipynb │ ├── visualization.ipynb │ └── README.md │ ├── plots/ │ ├── scripts/ │ ├── config.py # Configuratio …