Skip to content

We have dataset of IPL from 2008 to 2020 and we have to visualize analytics on Power BI dashboard. We have to upload that dataset into data lake. After that we have to process that data through pipeline and produce modeled data in warehouse. So, that we will be able to analyze the data in Power BI through pre-defined dashboards.

Notifications You must be signed in to change notification settings

vrup0408/IPL-Data-Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

IPL Data Analytics

Abstract: We have a Indian Premier League dataset from the year 2008-2020. This dataset is not in ready to use format and not good enough to give better visualization of data. We have to extract, load and transform our data. we need to  explore of several technologies to build a solution.


Services & Tools used:

  • Azure Data Lake Storage Gen2
  • Azure Data Factory
    • a. Linked Service
    • b. Pipeline
    • c. Dataset
    • d. Copy Data Activity
    • e. Script
    • f. Web
    • g. Delete
  • Azure Logic App
  • Azure Key Vault
  • Snowflake & Snowpark
    • a. Data Warehouse
    • b. Database
  • Power BI Desktop & Service

High Level Architecture:-

Flow Diagram:-

Transformed Table:-

Visualization (Output):-


❤️ Found this project useful?

If you found this project useful, then please consider giving it a "⭐" on GitHub and sharing it with your friends via social media.


About

We have dataset of IPL from 2008 to 2020 and we have to visualize analytics on Power BI dashboard. We have to upload that dataset into data lake. After that we have to process that data through pipeline and produce modeled data in warehouse. So, that we will be able to analyze the data in Power BI through pre-defined dashboards.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published