Excel, SQL, PowerBI, Stats, Python
Data Analytics
Work on a public domain project. Learn and gain experience.
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