InternshipAll 60 tasks, level by level
The real graded Data Analytics tasks the portal assigns, grouped into three levels.
The portal assigns these Data Analytics tasks. Finish Level 1 before Level 2 and Level 2 before Level 3. Your mentor may mark some tasks as required for the certificate.
Level 1: Foundations (22 tasks)
| Task | What to do |
|---|---|
| Excel essentials | Clean a messy sales sheet: remove duplicates, fix dates, split columns and use VLOOKUP/XLOOKUP. Share before/after files. |
| Pivot tables | Answer 8 business questions (top products, monthly trend, region share) with pivot tables and charts. |
| Descriptive statistics | Calculate mean, median, mode, standard deviation and percentiles for a dataset and explain what each tells you. |
| SQL basics | Write 20 queries on a sample sales database: filters, sorting, GROUP BY, HAVING and aggregates. |
| SQL joins | Answer 10 questions that need INNER, LEFT and self joins, and explain each result. |
| Data cleaning checklist | Write a checklist for missing values, outliers, duplicates and inconsistent categories, and apply it to a public dataset. |
| Charts that work | Make the same data into 5 chart types and explain which chart fits which question, and why pie charts often mislead. |
| Business questions | For a retail shop, write 15 analysis questions and the metric (KPI) that answers each. |
| Python for analysis | Load a CSV with pandas, clean it, group it and plot 3 charts in a Jupyter notebook. |
| Google Sheets dashboard | Build a one-page dashboard in Google Sheets with a filter and 4 charts that update automatically. |
| Survey analysis | Run a 10-question survey with 30+ responses and summarise the results with charts and 3 insights. |
| Data ethics | Write a one-page note on privacy, consent and bias in analytics with 2 real-world examples. |
| Excel functions drill | Use IF, SUMIFS, COUNTIFS, INDEX-MATCH, TEXT and date functions to answer 12 questions on one sheet. |
| Conditional formatting | Highlight top/bottom performers, duplicates and targets with conditional formatting rules. |
| Data validation and templates | Build an input template with drop-downs and validation so data entry stays clean. |
| Percentages and growth | Calculate share, growth, CAGR and contribution for a sales dataset and explain each. |
| Read a business report | Pick a public company report and extract 5 KPIs with how they are calculated. |
| Spreadsheet best practices | Restructure a messy workbook into raw data, calculations and report sheets with named ranges. |
| Charts in Excel | Build combo, waterfall and sparkline charts and explain when each is useful. |
| Survey design | Design an unbiased 10-question survey with the right question types and scales. |
| Sampling basics | Explain random, stratified and convenience sampling with examples and risks. |
| Analytics glossary | Write definitions and formulas for 25 common business metrics. |
Level 2: Building real features (20 tasks)
| Task | What to do |
|---|---|
| Power BI or Tableau dashboard | Build an interactive sales dashboard with slicers, drill-down and a KPI row. Publish or share screenshots. |
| Data modelling | Create a star schema (fact + dimension tables) for a sales dataset and explain the relationships. |
| DAX or calculated fields | Write 10 measures: running total, YoY growth, % of total, moving average, top-N and more. |
| Advanced SQL | Use window functions, CTEs and CASE to answer 10 harder questions (rankings, cohorts, retention). |
| Cohort and retention analysis | Build a monthly cohort retention table from order data and explain what it shows. |
A/B test analysis | Analyse an A/B test dataset: conversion rates, significance test and a clear recommendation. |
| Customer segmentation | Segment customers by RFM (recency, frequency, monetary) and suggest an action for each segment. |
| Time-series trend | Analyse monthly sales: trend, seasonality and a simple forecast for the next 3 months. |
| Automate a report | Write a Python script that pulls data, builds charts and emails or saves a weekly PDF/HTML report. |
| Storytelling with data | Turn one analysis into a 6-slide story: question, method, 3 insights, recommendation. |
| Power Query cleaning | Clean and combine 3 messy files with Power Query steps that refresh automatically. |
| Python vs Excel analysis | Solve the same 5 questions in Excel and pandas and compare effort and reproducibility. |
| Geographic analysis | Map sales by state or district and explain regional patterns. |
| Customer lifetime value | Estimate CLV from order data and suggest how marketing could use it. |
| Statistical significance | Run t-tests or chi-square tests on two groups and explain the p-value in plain words. |
| Google Analytics exploration | Explore the GA4 demo account and answer 8 questions about traffic and conversions. |
| Window functions practice | Solve 10 problems with LAG, LEAD, running totals and moving averages in SQL. |
| Dashboard design critique | Critique 3 public dashboards for clarity and redesign one. |
| Price and promotion analysis | Analyse how discounts affect units and revenue, and recommend a promotion strategy. |
| Supply chain analysis | Analyse inventory and delivery data to find stock-outs and slow suppliers. |
Level 3: Professional work and capstone (18 tasks)
| Task | What to do |
|---|---|
| End-to-end analytics project | Pick a public dataset, define questions, clean, analyse, build a dashboard and write recommendations. |
| Funnel analysis | Measure a sign-up or purchase funnel, find the biggest drop-off and propose 3 fixes with expected impact. |
| Data pipeline to a warehouse | Load raw data into a database or BigQuery sandbox on a schedule and build your dashboard on top. |
| Executive dashboard | Design a one-screen dashboard for a manager with KPIs, targets, alerts and comments. |
| Market basket analysis | Find products often bought together and suggest bundles, with support/confidence numbers. |
| Dashboard performance | Optimise a slow dashboard (aggregations, model, filters) and report load time before and after. |
| Portfolio case study | Publish your best project with the dashboard link, notebook and a written case study. |
| Present to stakeholders | Record a 5-minute presentation of your project for a non-technical audience. |
| Marketing analytics dashboard | Track spend, clicks, leads and cost per lead by channel with drill-down. |
| HR analytics | Analyse attrition data: who leaves, when and why, with recommendations. |
| Automated data quality checks | Write checks for nulls, duplicates, ranges and freshness that run before the dashboard refreshes. |
| Self-service analytics guide | Write a guide so a manager can filter and read your dashboard without help. |
| Analytics interview prep | Solve 10 SQL and 5 case questions typical of data analyst interviews and record your answers. |
| Forecasting with Excel and Python | Forecast monthly demand with Excel's forecast sheet and a Python model and compare accuracy. |
| Churn analysis | Find drivers of customer churn and estimate the revenue saved by reducing churn by 5%. |
| Data storytelling video | Record a 5-minute data story with your dashboard for a non-technical audience. |
| Freelance analytics project | Help a small business or college club with a real data question and deliver a report. |
| Analyst portfolio | Publish 3 projects with dashboards, notebooks and write-ups on GitHub or a portfolio site. |