Data warehouse project for a Retail clothing shop

A data warehouse for a clothing shop using Oracle (XE) and talend as the ETL process. MySQL, Excel and document databases (JSON) are used as the main data sources. Diagrams related to the data warehouse are also included.

Tech Stack

Data sources: MySQL, JSON, Excel and CSV

Data warehouse: Oracle DB (XE)

BI software: Microsoft Power BI

ETL designer: Talend software

Diagram designer: Draw.io

Features

• Focused to find the order and inventory summery of the clothing shop.
• Measures the supplier and employee performance.
• It is possible to find the details related to feedbacks of the customers.
• Visualizes the findings via MS PowerBI using dashboards.
• ETL design for the data warehouse and the data sources using talend software.

DW Design

ETL Talend Pipelines

Screenshots (BI dashboard)

Contributing

We welcome contributions from the community!

1. Fork the repository
2. Create your feature branch
   git checkout -b feature/YourFeature
3. Commit your changes
   git commit -am 'Add new feature'
4. Push to the branch
   git push origin feature/YourFeature
5. Open a pull request

License

This project is licensed under the MIT License.

---