Excel, SQL, PowerBI, Stats, Python

Data Analytics

Work on a public domain project. Learn and gain experience.

USERS

Learning Items

Employers Hiring

Placements

What tools you will work with & Learn

Advanced Excel

  • Vlookup
  • Xlookup
  • Pivot Tables
  • Dashboarding
  • Fomulas & Functions
  • Wildcards
  • Power Pivot
  • Power Query

Advanced SQL

  • Joins
  • Window Functions
  • Subqueries
  • Case Handling
  • Temp Tables
  • Indexing and Schema building
  • System Design

PowerBI

  • Data Connectors
  • Data Modelling
  • Relationships
  • Data Transformations
  • Measures
  • Automation
  • Dashboarding and Storying 

Python

  • Numpy
  • Pandas
  • Statistics
  • Other libraries

ETL 

  • Cleaning
  • Standardization
  • Processing
  • Modelling
  • Collection
  • Pipeline

Business Acumen

  • Business Impact
  • Cost Analysis
  • Industry Exposure
  • KPI's and Metrics
  • Insights and recommendations

Program Schedule