This is a capstone project for Upskilling program from HTU (Hussain Technical University) [Amman- Jordan] , in Data Analytics and Visualization Track.
#The project scenario: A sports channel asked TeckRocket to analyze some international football match information as a preparatory step for the FIFA World Cup Qatar 2022.
#Dataset International football results from 1872 to 2020 from Kaggle
• This dataset includes more than 40,000 results of international football matches in different tournaments. • Data does not include Olympic Games or matches where at least one of the teams was the nation's B-team, U-23 or a league select team. • contains nine columns: Date, Home team, Away team, Home score, Away score, Tournament, City, Country, and Neutral
Solution components
• SQL Server Create a Database and manage it. • SQL Server Integration Services (SSIS) Extract, Transform and Load (ETL process) the data from (CSV) file into tables in the database. • Power BI Use Power BI desktop to create reports and publish them into Power BI service. Use Power BI service to create an app. Use data gateway in Power BI service to make sure the dataset is up-to-date.
Dataset (csv) => Create the database (Sql Server) => ETL (SSIS) => Create Report pages (PowerBI Descktop)