Shri Khushal Das University: A Four-Week Data Analytics Internship Roadmap

Shri Khushal Das University: A Four-Week Data Analytics Internship Roadmap

Facebook
Twitter
LinkedIn
WhatsApp
Email

A four-week data analytics internship works best when each week ends with one visible deliverable: a clean dataset, an exploratory analysis, a dashboard, and a short case report. If your internship runs only 14 days, as the free CareerSwami one does, compress the same arc into two weeks using the condensed schedule below.

This guide gives you the roadmap, the checkpoints that tell you whether you are on track, and a recovery plan for the week that goes wrong. It is written for students of Shri Khushal Das University (SKDU) in Hanumangarh, but the plan is useful for any first-time analytics intern.

Why a first analytics internship needs deliverables, not just hours

Most beginners measure an internship by time spent watching tutorials. Employers and faculty reviewers look at something else: can you take a messy table, ask a question, answer it with evidence, and explain it to a non-technical reader? A deliverable per week forces that habit. It also gives you portfolio material and something concrete to discuss in interviews.

Keep the toolset small. One spreadsheet tool (Excel or Google Sheets), SQL basics, and either Python with pandas or a BI tool such as Power BI or Tableau Public is enough. Depth in one stack beats a shallow tour of five.

The four-week data analytics roadmap with weekly deliverables

Week Focus Daily time (illustrative) Deliverable Checkpoint question
1 Problem framing, data cleaning, spreadsheet and SQL basics 2-3 hours Cleaned dataset plus a one-page data dictionary and a list of cleaning decisions Can someone else reproduce your cleaning from your notes?
2 Exploratory analysis, summary statistics, first charts 2-3 hours Notebook or workbook with 8-10 questions asked and answered, with charts Does every chart answer a stated question?
3 Dashboard or visual report building 3 hours A working dashboard with 3-5 visuals, filters and a short guide to reading it Can a stranger understand it in two minutes?
4 Insight writing, recommendations, presentation 2-3 hours A 2-page case report and a 5-slide summary, published in a portfolio folder or repository Does each recommendation point to evidence?

Week 1: choose a question and clean the data

  • Day 1-2: Pick a public dataset (retail sales, student performance, public transport, or similar) and write one business question in a sentence.
  • Day 3-4: Inspect for missing values, duplicates, wrong data types and inconsistent labels. Record each fix and why you made it.
  • Day 5-7: Practise SELECT, WHERE, GROUP BY and JOIN on the cleaned data. Write the data dictionary.

Checkpoint: by Sunday you should have a cleaned file and a decision log. If you have only a half-cleaned file, use the recovery plan below.

Week 2: explore before you conclude

  • Compute counts, averages, medians and spread for the key columns.
  • Compare groups (region, month, category) and note which differences are large enough to matter.
  • Plot distributions and trends. Write one sentence of interpretation under each chart.
  • List two findings that surprised you and one that might be a data error.

Checkpoint: you can state three findings in plain language without opening the notebook.

Week 3: turn analysis into a dashboard

  • Sketch the layout on paper first: headline numbers on top, trend in the middle, breakdowns below.
  • Build 3-5 visuals only. Add one or two filters.
  • Test it with a friend who has not seen the data and note every question they ask.

Checkpoint: your tester can answer your original business question from the dashboard alone.

Week 4: write the case report and present it

  • Structure the report as question, data, method, findings, recommendations, limitations.
  • Limit it to two pages. Put charts beside the sentences they support.
  • Record or rehearse a three-minute walkthrough.
  • Publish the files with a short README so a reviewer can follow your work.

Free 2-Week CareerSwami Internship

Online, 14 days, with a free offer letter and a free completion certificate once you finish the work. Check with your college that it fits your requirement before you enrol.

Apply for the free internship

The 14-day version for a two-week internship

The free two-week online internship at CareerSwami runs for 14 days, with a free offer letter and a free completion certificate after successful completion, across 26 tracks. If you are on a 14-day schedule, merge the four weeks like this:

Days What you do Deliverable
1-3 Pick a dataset, write the question, clean the data Cleaned file and decision log
4-6 Exploratory analysis with 6-8 questions Notebook or workbook with charts
7-8 Midpoint review and fixes Revised analysis, list of open issues
9-11 Build a small dashboard with 3 visuals Working dashboard
12-14 Write a one-page insight summary and present Summary plus a short walkthrough

Cut scope rather than quality: fewer questions, fewer visuals, but each one finished and explained.

Worked illustration: a retail sales roadmap in week one and two

This example is illustrative; no code or results here come from an actual run.

Suppose you choose a public retail transactions dataset with columns for order date, city, product category, quantity and price. Your question: Which categories drive revenue in the busiest months, and is growth concentrated in a few cities?

  1. Day 1: Write the question and list the columns you need. Note that you will derive revenue as quantity times price.
  2. Day 2: Find that dates are stored as text in two formats. Standardise them and log the change.
  3. Day 3: Remove exact duplicate rows, but flag rows with zero quantity rather than deleting them, and record why.
  4. Day 4: Write a SQL query that groups revenue by month and category.
  5. Week 2: Chart monthly revenue, then compare cities. If one city accounts for most of the growth, state that as a finding and check whether a single large order explains it.

The finished week-two output might be a sentence such as “Revenue growth is concentrated in one category and one city; recheck for a single bulk order.” That kind of cautious, evidence-linked statement is what reviewers value.

Slip-recovery plan for a data analytics week that goes badly

Every intern has a week where the data will not load, a join duplicates rows, or illness eats three days. Decide your response before it happens.

Situation Recovery move What to cut
Behind by 1-2 days in week 1 Absorb it with two longer sessions at the weekend Extra SQL practice beyond the core queries
Cleaning is still unfinished at week end Freeze the cleaning at “good enough”, document known issues and move on Cosmetic fixes to rare edge cases
Analysis is confusing in week 2 Shrink to the three most important questions Secondary comparisons
Dashboard tool fails or is unfamiliar Switch to charts in a spreadsheet and keep the layout sketch Filters and interactivity
Lost a full week Merge weeks 3 and 4 into a single report with 3 charts The dashboard as a separate deliverable

Three rules for recovering without panic

  • Protect the final report first. A finished two-page report beats an unfinished dashboard.
  • Tell your mentor early. A short message saying what slipped and your revised plan shows professionalism.
  • Write the lesson down. One line in your log on why the week slipped helps you plan the next one.

Weekly checkpoint scorecard you can copy

At the end of each week, score yourself from 0 to 2 on each line. A total below 6 out of 10 means use the recovery table before starting the next week.

  1. The deliverable exists and opens on another device.
  2. Every step is documented well enough for someone else to repeat.
  3. Each chart or table answers a written question.
  4. You can explain the findings aloud in under two minutes.
  5. You know exactly what next week’s deliverable is and what you need for it.

Shri Khushal Das University: Fitting a Four-Week Analytics Roadmap into Your Programme

Shri Khushal Das University is located at Chak 7STG, Khushal Nagar, on the Suratgarh-Hanumangarh Road in Rajasthan. Its admissions website states that it was established in 2018 by the Shri Guru Govind Singh Charitable Trust, is approved by the Government of Rajasthan and is recognised by the UGC. Students should still check the current approval and recognition documents on the official pages before relying on this summary.

The same site lists computer programmes including BCA, MCA, M.Sc. in IT, M.Sc. in Computer Science and B.Tech in Computer Science & Engineering. No dedicated data analytics programme appears in that listing, which means a student from one of these courses who wants analytics work is likely to be building the skills through a self-planned internship. A four-week roadmap suits that situation because it can be scoped around what your own course has already taught, such as databases, spreadsheets or programming basics.

On support, the site describes a dedicated placement cell that works with companies, along with skill-enhancement programmes, career guidance and soft-skill workshops. It also says training and internships begin in the first semester, though it gives no detail on duration, eligibility or partner organisations. Because those specifics are not published on that page, a four-week plan should be agreed with your department rather than assumed to match a university-wide rule.

The university also maintains its main site at skduniversity.com, which has a placement section; the cell can tell you which internships it recognises and what paperwork it needs.

Steps to confirm before week one

  • Ask the placement cell whether a four-week internship is recognised for your programme, and in which semester.
  • Check whether the university requires a supervisor letter, a log or a final report, and who signs them.
  • Confirm with your department whether analytics work will count toward project or training requirements.
  • Ask which software and datasets your host organisation will allow you to use.
  • Check the current programme list so you know which course your internship belongs to.

How to present the finished project to recruiters and faculty

  • Lead with the business question and the single most important finding.
  • Link to your files with a README stating the dataset source, tools and limitations.
  • Describe your role accurately. Say what you built yourself and what you followed from a tutorial.
  • Prepare answers to “why did you remove those rows?” and “what would you do with more time?”

Frequently Asked Questions

Can I finish a data analytics internship in 14 days?

Yes, if you reduce scope. Use the 14-day table: one dataset, a handful of questions, a small dashboard and a one-page summary. Quality of explanation matters more than the number of charts.

Which tool should a beginner learn first for analytics?

Start with a spreadsheet and basic SQL, since both appear in most entry-level roles. Then add Python with pandas or a BI tool, not both at once.

Does the CareerSwami internship give a stipend or university credit?

No such claim is made. The confirmed benefits are a free two-week online internship, a free offer letter and a free completion certificate after successful completion. Ask your department whether any external internship counts for credit.

What dataset should I choose for my first project?

Choose a public dataset of a few thousand rows with dates, categories and numbers, so you can practise cleaning, grouping and trend charts. Avoid anything with sensitive personal data.

What if I fall behind in the first week?

Use the slip-recovery table: freeze cleaning at “good enough”, document the issues and move on. Message your mentor early with a revised plan.

Will an internship certificate help with placements at SKDU?

It can strengthen your profile, but no placement outcome is guaranteed. Pair the certificate with a documented project, and ask the placement office what employers look for.

How many charts should my dashboard have?

Three to five is enough for a first project. Each should answer a stated question, and the dashboard should be understandable in about two minutes.

Do I need to know Python before starting?

No. You can complete the whole roadmap with spreadsheets, SQL and a free BI tool. Add Python later if you want more automation.

Related Data Analytics guides

Ready to put this into practice?

Join the free two-week CareerSwami online internship in Data Analytics. The internship, the offer letter and the completion certificate are free.

Start your free 2-week internship

Web Stories

Scroll to Top