8 Hours Online Training Program On MS Excel & MS Power BI

IPL & International Cricket Data Analysis

Date : 13, 14, 20, 21 April 2024 – Saturday & Sunday

Time : 11am to 1pm

Duration : 2 hours per day – Total 8  Hours

Mode of Training: Online

Facilitator : Mr. R. Ajith Sai Krishna – Microsoft Certified Expert 

Program Fee: Rs. 2500 per participant + 18% GST.

Pricing Discount for Student @ 20% – Rs. 2000 per participant

COURSE OUTLINE:

Beloved Cricket fans! This IPL season can be personally game changing for you! Here comes a course that imparts Power BI & Excel Skills with the fun of World Cricket and IPL. Make use of this lucrative and niche course to develop analytical and dash boarding  skills using MS Excel and MS Power BI. You get to gain hands-on knowledge of the applications and improve your data analyzing skills, at the same time enjoy the process of understanding the dynamics of the sport that we all love! 

TRAINER: 

  1. Ajith Sai Krishna 

Microsoft Certified Expert 

ABOUT TRAINER: 

With 5 years of experience in training corporates and students, the trainer has a strong technical and working knowledge, hailing from an Engineering background. Has conducted corporate training for several companies such as Lucas TVS, Redington India and TPI Composites. Also conducted training for students from Stella Maris College, Shasun Jain College, Tagore Arts and Science College, Vels Institute of Science, Technology and Advanced Studies and Tagore Engineering College. Has trained over 850+ students online in Data Analytics, Statistical Analysis, ETL, Data Visualization, SQL and more. 

KEY TAKEAWAYS: 

  • Perform KPI Analysis on cricketer’s data enabling to learn various formulas and functions like Rand, Search, Countif, Sumif and more 
  • Perform criteria based formatting for top batsmen, bowlers and performances through Conditional Formatting techniques 
  • Create unique user created charts like Wind Rose, Histogram and Pareto to perform Data Analytics on cricketers’ performances 
  • Create fascinating Pivot Tables, Pivot Charts to understand various data insights and create reports, on player performance 
  • Learn how to manage weekly data, using robust data maintenance techniques during the course of the IPL through live data extraction 
  • Powerful Power Query techniques to automate the Data Analysis and Data Visualization, combining the strength of Power Query & Power BI 
  • Detecting Relationships between multiple tables, and establishing relationships between non-uniform data using Power Pivot 
  • Data Cleaning of large Cricket datasets using ETL techniques and establishing a stable work flow for analysis 
  • Data Modeling by Creating Entity Relationships: 1 to 1, 1 to Many ● Establishing Schema for visualising our constantly updating 

Fact Tables such as: STAR, SNOWFLAKE, GALAXY

  • Weekly IPL data analysis on players, matches and performances. ● Dashboard building with dynamic visuals: Decomposition Analysis, Treemap, Funnel Charts, Filled Map Visuals and more! 
  • Combining Statistics, Technical Analysis, Frequency Distribution, Excel and Power BI to evaluate performances of players 
  • Star Player Comparisons using comparative analysis 
  • A course completely stuffed with a lot of Mini Projects, Hands On Training Activities and Quick Utility Tests which are educating and entertaining. 

ADD ONS: 

  • Datasets provided at lifetime access (Offline files for free at request)
  • E-Certificate shall be provided
  • Selective days recordings shall be provided