ETL DRIVEN ANALYTICS DATA WAREHOUSE (DATA ENGINEERING)

Ingénierie de Pipelines : Construction d'une chaîne ETL complète (Talend, Oracle PL/SQL) pour l'intégration de données API dans un Data Warehouse Oracle.
Modélisation et Visualisation : Application du schéma dimensionnel (étoile) et création d'analyses de performance métier via Power BI.

1. ETL-Driven Football Analytics Warehouse

2. AGENDA Introduction Project overview Modeling Implementation Conclusion 2024 ETL WAREHOUSE 2

3. INTRODUCTION 2024 ETL WAREHOUSE 3 As part of my journey in learning about data warehouses , I built this project to test my skills and document my learning path . This project focuses on creating an end-to-end Football Data Analytics Pipeline that efficiently collects, processes, and visualizes football-related data.

4. Project Overview ETL WAREHOUSE

5. ETL PROJECT 2024 ETL WAREHOUSE 5 This project follows an ETL workflow to collect, process, and analyze football data. Data is extracted from an API using Talend , transformed and cleaned using Talend and Oracle PL/SQL , and stored in an Oracle data warehouse . Finally, insights are visualized through Power BI dashboards for performance analysis. 🚀⚽

6. modeling

7. WAREHOUSE DIAGRAM 2024 ETL WAREHOUSE 7

8. IMPLEMENTATION REACTJS & LARAVEL

9. Talend jobs 2024 ETL WAREHOUSE 9

10. ORACLE / PL-SQL 2024 ETL WAREHOUSE 10 THE CODE IS ON MY GITHUB PROFILE

11. Power-bi dashboards 2024 ETL WAREHOUSE 11

12. 2024 ETL WAREHOUSE 12

13. CONCLUSION 2024 ETL WAREHOUSE 13 This project successfully transformed raw football data from multiple sources into a well-structured data warehouse , enabling insightful analysis through Power BI. By integrating dimensional modeling ( DimTeams , DimPlayers , DimLeagues , DimGames ) with fact tables ( FactAppearances , FactTeamStats ), we created a fully interactive and dynamic dashboard that offers valuable insights into football performance.

14. THANK YOU MAHSOUNE ZAID 2024 ETL WAREHOUSE 14