ETL DRIVEN ANALYTICS DATA WAREHOUSE (DATA ENGINEERING)

ETL DRIVEN ANALYTICS DATA WAREHOUSE (DATA ENGINEERING)

• 1.
  ETL-DRIVEN FOOTBALL ANALYTICS WAREHOUSE
• 2.
  AGENDA Introduction Project overview Modeling Implementation Conclusion 2024 ETLWAREHOUSE 2
• 3.
  INTRODUCTION 2024 ETL WAREHOUSE3 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 WAREHOUSE 5 ETLPROJECT 2024 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.
  ETL WAREHOUSE 7 WAREHOUSEDIAGRAM 2024
• 8.
  IMPLEMENTATION REACTJS & LARAVEL
• 9.
  ETL WAREHOUSE 9 TALENDJOBS 2024
• 10.
  ETL WAREHOUSE 10 ORACLE/ PL-SQL 2024 THE CODE IS ON MY GITHUB PROFILE
• 11.
  ETL WAREHOUSE 11 POWER-BIDASHBOARDS 2024
• 12.
  ETL WAREHOUSE 12 2024 Clickicon to add chart
• 13.
  CONCLUSION 2024 ETL WAREHOUSE13 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 2024ETL WAREHOUSE 14