Excel, SQL, PowerBI
Data Analyst Internship
Work on a public domain project "Understanding the career aspirations of Gen-Z"
How this internship program works
Write your awesome label here.
What tools you will work with & Learn
Advanced Excel
- FlashFill
- Data Validation
- Filtering and Sorting
- Conditional Formatting
- Charts
- Dashboarding
- Vlookup
- XLookup
- Match & Index
- Text Formulas
- Date & Time Formulas
- Statistical Formulas
- Forecasting Formulas
- Pivot Tables
- Formulas
Advanced SQL
- Joins
- Window Functions
- Subqueries
- Case Handling
- Temp Tables
- Indexing and Schema building
- System Design
Data Cleaning
Data Standardisation
- Data Transformation
- Data Enrichment
- Types of Data Standardisation
- General Data Standards
PowerBI
- Data Sources
- Data Transformation
- Custom Visuals
- Drill-Through and Drill-Down
- Bookmarks and Selections
- Tooltips
- Data Sensitivity Labels
- Data Classification
- Aggregations
- Composite Models
- Pivoting and Unpivoting
- Relationships
- Data Modeling
- DAX
- Row-Level Security
Data Storytelling
- Storytelling Frameworks
- Why Storytelling is Important
- Narrative Arc
- Analogies and metaphors
- Contextualisation
- 5 Step Framework
- Data Driven Framework
- The Story-circle Framework
Program Schedule
We are a job simulation platform that provides real time experience into a real world job all while learning the technical skills.