🚀 Ibm Business Intelligence Capstone

IBM Business Intelligence (BI) Analyst Professional Certificate Capstone Project

English | Português

---

English

🎯 Overview

Ibm Business Intelligence Capstone is a production-grade Python application complemented by CSS, HTML, SQL that showcases modern software engineering practices including clean architecture, comprehensive testing, containerized deployment, and CI/CD readiness.

The codebase comprises 1,490 lines of source code organized across 15 modules, following industry best practices for maintainability, scalability, and code quality.

✨ Key Features

• 🏗️ Object-Oriented: 6 core classes with clean architecture
• 📐 Clean Architecture: Modular design with clear separation of concerns
• 🧪 Test Coverage: Unit and integration tests for reliability
• 📚 Documentation: Comprehensive inline documentation and examples
• 🔧 Configuration: Environment-based configuration management

🏗️ Architecture

graph LR
    subgraph Input["📥 Input"]
        A[Raw Data]
        B[Feature Config]
    end
    
    subgraph Pipeline["🔬 ML Pipeline"]
        C[Preprocessing]
        D[Feature Engineering]
        E[Model Training]
        F[Evaluation]
    end
    
    subgraph Output["📤 Output"]
        G[Trained Models]
        H[Metrics & Reports]
        I[Predictions]
    end
    
    A --> C --> D --> E --> F
    B --> D
    F --> G
    F --> H
    G --> I
    
    style Input fill:#e1f5fe
    style Pipeline fill:#f3e5f5
    style Output fill:#e8f5e9

Loading

classDiagram
    class OLAPCubeManager
    class ExecutiveReportGenerator
    class KPIMonitor
    class DataExtractor
    class BusinessIntelligencePlatform
    OLAPCubeManager --> OLAPCubeManager : uses
    OLAPCubeManager --> ExecutiveReportGenerator : uses
    OLAPCubeManager --> KPIMonitor : uses

Loading

🚀 Quick Start

Prerequisites

• Python 3.12+
• pip (Python package manager)

Installation

# Clone the repository
git clone https://github.com/galafis/ibm-business-intelligence-capstone.git
cd ibm-business-intelligence-capstone

# Create and activate virtual environment
python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

# Install dependencies
pip install -r requirements.txt

Running

# Run the application
python src/main.py

🧪 Testing

# Run all tests
pytest

# Run with coverage report
pytest --cov --cov-report=html

# Run specific test module
pytest tests/test_main.py -v

# Run with detailed output
pytest -v --tb=short

📁 Project Structure

ibm-business-intelligence-capstone/
├── cognos_models/
├── docs/          # Documentation
│   ├── api_documentation.md
│   ├── bi_architecture_guide.md
│   ├── dashboard_design_guide.md
│   ├── etl_best_practices.md
│   └── user_guide.md
├── powerbi_reports/
│   └── financial_dashboard.pbix.txt
├── sql/
│   ├── datawarehouse/
│   │   ├── create_dimensions.sql
│   │   └── create_facts.sql
│   └── create_datawarehouse.sql
├── src/          # Source code
│   ├── etl/
│   │   ├── extraction.py
│   │   └── run_etl_pipeline.py
│   ├── kpi/
│   │   └── kpi_monitor.py
│   ├── olap/
│   │   └── refresh_cubes.py
│   ├── reporting/
│   │   └── generate_executive_reports.py
│   ├── bi_platform.py
│   └── main_platform.py
├── tableau_workbooks/
├── tests/         # Test suite
│   ├── __init__.py
│   ├── performance_test.py
│   └── test_platform.py
├── LICENSE
├── README.md
└── requirements.txt

🛠️ Tech Stack

Technology	Description	Role
Python	Core Language	Primary
NumPy	Numerical computing	Framework
Pandas	Data manipulation library	Framework
Plotly	Interactive visualization	Framework
scikit-learn	Machine learning library	Framework
Streamlit	Data app framework	Framework
SQL	3 files	Supporting
HTML	1 files	Supporting
CSS	1 files	Supporting

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

1. Fork the project
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

👤 Author

Gabriel Demetrios Lafis

• GitHub: @galafis
• LinkedIn: Gabriel Demetrios Lafis

---

Português

🎯 Visão Geral

Ibm Business Intelligence Capstone é uma aplicação Python de nível profissional, complementada por CSS, HTML, SQL que demonstra práticas modernas de engenharia de software, incluindo arquitetura limpa, testes abrangentes, implantação containerizada e prontidão para CI/CD.

A base de código compreende 1,490 linhas de código-fonte organizadas em 15 módulos, seguindo as melhores práticas do setor para manutenibilidade, escalabilidade e qualidade de código.

✨ Funcionalidades Principais

• 🏗️ Object-Oriented: 6 core classes with clean architecture
• 📐 Clean Architecture: Modular design with clear separation of concerns
• 🧪 Test Coverage: Unit and integration tests for reliability
• 📚 Documentation: Comprehensive inline documentation and examples
• 🔧 Configuration: Environment-based configuration management

🏗️ Arquitetura

graph LR
    subgraph Input["📥 Input"]
        A[Raw Data]
        B[Feature Config]
    end
    
    subgraph Pipeline["🔬 ML Pipeline"]
        C[Preprocessing]
        D[Feature Engineering]
        E[Model Training]
        F[Evaluation]
    end
    
    subgraph Output["📤 Output"]
        G[Trained Models]
        H[Metrics & Reports]
        I[Predictions]
    end
    
    A --> C --> D --> E --> F
    B --> D
    F --> G
    F --> H
    G --> I
    
    style Input fill:#e1f5fe
    style Pipeline fill:#f3e5f5
    style Output fill:#e8f5e9

Loading

🚀 Início Rápido

Prerequisites

• Python 3.12+
• pip (Python package manager)

Installation

# Clone the repository
git clone https://github.com/galafis/ibm-business-intelligence-capstone.git
cd ibm-business-intelligence-capstone

# Create and activate virtual environment
python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

# Install dependencies
pip install -r requirements.txt

Running

# Run the application
python src/main.py

🧪 Testing

# Run all tests
pytest

# Run with coverage report
pytest --cov --cov-report=html

# Run specific test module
pytest tests/test_main.py -v

# Run with detailed output
pytest -v --tb=short

📁 Estrutura do Projeto

ibm-business-intelligence-capstone/
├── cognos_models/
├── docs/          # Documentation
│   ├── api_documentation.md
│   ├── bi_architecture_guide.md
│   ├── dashboard_design_guide.md
│   ├── etl_best_practices.md
│   └── user_guide.md
├── powerbi_reports/
│   └── financial_dashboard.pbix.txt
├── sql/
│   ├── datawarehouse/
│   │   ├── create_dimensions.sql
│   │   └── create_facts.sql
│   └── create_datawarehouse.sql
├── src/          # Source code
│   ├── etl/
│   │   ├── extraction.py
│   │   └── run_etl_pipeline.py
│   ├── kpi/
│   │   └── kpi_monitor.py
│   ├── olap/
│   │   └── refresh_cubes.py
│   ├── reporting/
│   │   └── generate_executive_reports.py
│   ├── bi_platform.py
│   └── main_platform.py
├── tableau_workbooks/
├── tests/         # Test suite
│   ├── __init__.py
│   ├── performance_test.py
│   └── test_platform.py
├── LICENSE
├── README.md
└── requirements.txt

🛠️ Stack Tecnológica

Tecnologia	Descrição	Papel
Python	Core Language	Primary
NumPy	Numerical computing	Framework
Pandas	Data manipulation library	Framework
Plotly	Interactive visualization	Framework
scikit-learn	Machine learning library	Framework
Streamlit	Data app framework	Framework
SQL	3 files	Supporting
HTML	1 files	Supporting
CSS	1 files	Supporting

🤝 Contribuindo

Contribuições são bem-vindas! Sinta-se à vontade para enviar um Pull Request.

📄 Licença

Este projeto está licenciado sob a Licença MIT - veja o arquivo LICENSE para detalhes.

👤 Autor

Gabriel Demetrios Lafis

• GitHub: @galafis
• LinkedIn: Gabriel Demetrios Lafis