AI for Data Analysis Internship
Analyse data with Copilot in Excel, Gemini in Google Sheets, ChatGPT and AI notebooks, and prove every number: cleaning, formulas, SQL, charts, dashboards and reports, with data privacy under India's DPDP Act.
🎓 Free certificate
Free AI for Data Analysis workshop certificates
Before or during your internship, take these free online workshops. Study short lessons, pass a quiz and download a certificate you can verify and add to LinkedIn. No fee, no sign-up needed to start.
- Computer Fundamentals & MS OfficeFree →
- Power BI & ExcelFree →
- Statistics for Data ScienceFree →
- Data AnalyticsFree →
- DBMS & SQLFree →
- Python ProgrammingFree →
What you'll work on
- Level 1: Foundations - AI tools for data work, Clean data with AI help, Formulas you understand and more
- Level 2: Building real features - Exploratory analysis project, SQL with AI, Forecasting basics and more
- Level 3: Professional work and capstone - End-to-end analytics project, AI analysis accuracy study, Governance checklist and more
Full syllabus: all 30 graded tasks
These are the actual tasks the internship portal assigns for this domain. You submit each one with proof (a GitHub link or document) and a mentor reviews it.
Level 1: Foundations (12 tasks)
- AI tools for data work. In a repo named ai-data-analysis-internship, write a README comparing ChatGPT data analysis, Claude analysis, Gemini in Google Sheets, Copilot in Excel and Power BI Copilot: what each can do, data limits and privacy. Link official docs.
- Clean data with AI help. Take a messy public dataset (for example from data.gov.in). Use AI to suggest cleaning steps, apply them in a sheet or Python, and keep a log of every change so it can be repeated.
- Formulas you understand. Use AI to write 10 spreadsheet formulas (VLOOKUP or XLOOKUP, SUMIFS, IF, pivots). For each, explain it in your own words and test it on rows where you know the answer.
- Ask the right question. For one dataset, write five vague questions and five precise analysis questions. Run both with an AI tool and show why precise questions give more reliable answers.
- Charts with AI. Create five charts with AI help and check each one: correct chart type, axis starting points, labels and units. Fix any misleading chart.
- Check AI calculations. Ask AI to compute totals, averages and growth rates on a dataset. Recalculate every number yourself and list any differences and why they happened.
- Python analysis with AI. Use AI to write a pandas notebook that loads, cleans and summarises a dataset. Run it, read every line and add comments explaining the code.
- Data privacy rules. Write a one-page guide on which data must never be uploaded to AI tools (personal data, health, salaries, client data), how to anonymise data, and what India's DPDP Act requires.
- Summarise survey results. Analyse a survey with open text answers. Use AI to group comments into themes, then check a sample of 30 by hand and report how accurate the grouping was.
- Dashboard basics. Build a one-page dashboard in Looker Studio, Power BI or Sheets with AI help for a sample sales dataset: KPIs, trend and breakdown. Make it readable on a laptop and a phone.
- Explain statistics simply. Use AI to explain mean, median, standard deviation, correlation and sampling with examples from your dataset. Verify the explanations with a textbook and fix mistakes.
- Write an insight report. Write a one-page insight report from an analysis: three findings with numbers, a chart each, and one recommendation. State which steps used AI.
Level 2: Building real features (10 tasks)
- Exploratory analysis project. Do a full exploratory analysis of a public dataset with AI as an assistant: questions, cleaning, analysis, charts and conclusions. Submit the notebook and a short report.
- SQL with AI. Load a dataset into a database and use AI to write 10 SQL queries for business questions. Run and verify each result, and fix wrong joins or filters.
- Forecasting basics. Use AI help to build a simple forecast (moving average or linear trend) for monthly sales. Show the forecast error on past data and explain the limits.
- Copilot or Gemini in spreadsheets. Complete a full analysis inside Excel with Copilot or Google Sheets with Gemini: clean, pivot, chart and summarise. Record where the AI helped and where you had to correct it.
- Detect bias in data. Check a dataset for missing groups, skewed samples or biased labels with AI help. Explain how the bias could mislead decisions and how to correct for it.
- Automated weekly report. Build an automated weekly report (Apps Script, Power Automate or Python) that refreshes data, creates charts and emails an AI-written summary that a human reviews first.
- Analysis for a local business. Analyse real sales or attendance data from a small business or college department (with permission and anonymised). Present findings and recommendations to them.
- Natural language questions on data. Set up a tool that answers natural-language questions about a dataset (Power BI Q&A, Gemini in Sheets or an AI notebook). Test 20 questions and record wrong answers.
- Data storytelling. Turn one analysis into a five-slide data story for non-technical managers: the question, key numbers, charts, recommendation and next steps.
- Reproducible analysis. Make one analysis fully reproducible: data source, cleaning script, analysis notebook, versions and a README so someone else gets the same numbers.
Level 3: Professional work and capstone (8 tasks)
- End-to-end analytics project. Deliver a complete analytics project for a real or realistic client: requirements, data pipeline, analysis, dashboard, insight report and a handover guide, with AI use documented.
- AI analysis accuracy study. Give the same 15 analysis tasks to two AI tools and do them yourself. Compare accuracy and time, and write recommendations on when to trust AI for data work.
- Governance checklist. Write a data and AI governance checklist for a small company: data access, anonymisation, approved tools, review of AI outputs and record keeping. Apply it to your project.
- Executive dashboard. Build an executive dashboard with drill-downs, filters and an AI-generated summary that is checked against the data. Include a user guide.
- Teach data skills with AI. Run a session teaching classmates to analyse a dataset with AI tools safely, with an exercise and feedback.
- Decision memo. Write a two-page decision memo backed by your analysis for a real decision (for example which product to stock more). Show assumptions, risks and confidence.
- Automate a recurring analysis. Fully automate one recurring analysis with scheduled refresh, quality checks that stop bad data, and alerts when numbers look wrong.
- Capstone: AI-assisted analytics case study. Present a case study of your best analysis: the question, data, method, AI tools used, how results were verified, impact and lessons.
Real software work, not just training
Every AI for Data Analysis task is reviewed by our team and saved to your portfolio. Interns who pass the readiness check can take real work from Training Trains, W3AppDevelopers and DomainHostly projects on the Company Work board.
Frequently asked questions
Do I need experience to join the AI for Data Analysis internship?+
Basic spreadsheet skills are enough to start. Python and SQL are introduced with AI help and checked by you.
What will I do in the AI for Data Analysis internship?+
You complete 30 graded tasks in three levels: foundations, real features, and professional work. Each task is submitted with GitHub or document proof and reviewed. The final capstone is: Capstone: AI-assisted analytics case study.
Do I get a certificate for the AI for Data Analysis internship?+
Yes. After your required tasks are approved, your attendance is above 75% and you pass the proctored final exam, you get a graded completion certificate that anyone can verify at trainingtrains.com/verify.
Can I do the AI for Data Analysis internship online?+
Yes. You can do it fully online from home, or offline at our Erode and Perundurai branches. Tasks, quizzes and mentor reviews are the same in both modes.
Available both online (work from home) and offline at our Erode and Perundurai branches - see the full internship program details for departments, duration, and the application process.