About the role
You will work with client stakeholders to define the numbers that matter, build the SQL and dashboards behind them, and explain what changed and why. It is one of the fastest routes into a tech career, and you will leave with dashboards and SQL you can show in interviews.
Roles and responsibilities
- Translate business questions into clear KPI definitions
- Write SQL with joins, window functions and CTEs
- Clean and model data for reporting
- Build interactive dashboards in Power BI or Looker Studio
- Run cohort, funnel and retention analyses
- Automate recurring reports with Python
- Write short insight memos with recommendations
By the end, you will be able to
- Write the SQL used in real analyst interviews
- Design dashboards people actually use
- Analyse marketing, sales and product performance
- Spot data quality issues before they reach a report
- Tell a clear story with numbers
Questions you will be able to answer
How do businesses know exactly where customers drop off before buying?
Which metric would you show a CEO if you could show only one?
Why do two teams report different revenue numbers for the same month?
How do you prove a marketing campaign was worth the money?
What you might build
- A weekly sales KPI dashboard
- A customer retention cohort analysis
- An automated marketing performance report
Every intern gets different tickets. These are examples of the kind of work, not a fixed list.
How the first three months progress
Week 1
Onboarding & spreadsheets
Excel/Sheets formulas, pivot tables, data cleaning, Git basics
Week 4
Python for analytics
pandas, data merging, charts with matplotlib/seaborn, automated report
Week 8
Product analytics
event data, DAU/MAU, retention, feature adoption, product insights
Week 12
Capstone delivery
business analytics case, dashboard + report, recommendations, presentation
Four- and six-month internships add advanced specialisation, a major client project, open-source work and interview preparation.
Tools you will use
Who should apply
- Comfortable with spreadsheets
- Logical thinkers from any degree (commerce, science, engineering)
- No coding experience required to start