How youneskhm-o/data-bi-projects works
Project Type & Purpose
• This repository (“Data-BI-Projects”) is a collection of modular Data Analytics and Business Intelligence workflows. Each subfolder (Customer Churn Analysis, Disease Trend Analysis, Student Retention Analysis) encapsulates a self-contained ETL-to-Visualization pipeline.
Main Architectural Layers
a. Data Sources
• Raw datasets (CSV, DB.db files) stored under each project’s Dataset folder.
b. ETL & Data Ingestion
• Talend jobs (Disease Trend Analysis/ETL_Talend)
• SQL scripts to build and load the data warehouse (🗄️ SQL_Scripts)
c. Data Storage & Modeling
• Light-weight DB (e.g., SQLite in Disease Trend)
• Structured data warehouse schemas (SQL_Scripts/data_warehouse_schema.sql)
d. Data Preparation & Prediction
• Python_Processing modules (Customer Churn Analysis/Python_Processing)
• Jupyter notebooks, Pandas data cleaning, model training, feature engineering
e. BI & Visualization
• Tableau dashboards (Customer Churn Analysis/Tableau_Dashboards)
• Power BI dashboards (Disease Trend Analysis/📊 PowerBI_Dashboards; Student Retention Analysis/📊 PowerBI_Dashboards)
Component Relationships & Data Flows
• Data Sources → ETL Jobs/SQL Scripts → Data Warehouse
• Data Warehouse → Python Processing (for predictive analytics)
• Processed Data → BI Tools (Tableau / Power BI)
Architectural Patterns & Design Principles
• Modular Workflows: Each analysis is its own “micro-pipeline” that can be run, tested, and extended independently.
• Separation of Concerns:
• Ingestion & staging (Talend / SQL)
• Transformation & modeling (Python / DB SQL)
• Presentation (BI dashboards)
• Reusability: SQL schemas and ETL templates can be adapted across projects.