60-Day Data Analyst Internship with Mentor Support
Real Data Practice
About This Internship
A sales dashboard shows ₹18 lakh, but the Finance Excel report shows ₹22 lakh. Why are the numbers different? Which figure should the company trust?
You will work on this type of office-based problem during this 60-day Data Analyst Internship.
You will get sample files, sales records, reports and other data to study. You will check numbers, look for missing or repeated records and find possible reasons why reports do not match.
What will you learn?
- Use Excel to check and compare data.
- Write basic SQL queries to find information in tables.
- Use Power BI to view data and build dashboards.
- Find missing and duplicate records.
- Compare reports and check data.
- Explain what you found in a simple report.
What problems will you work on?
For example, the same sale may appear twice, making the total look higher than it should. Or some sales may be missing from a dashboard. You will study the given files and evidence to find clues and explain what may have gone wrong.
How will you learn?
You will complete practical tasks using the files provided. Your mentor will explain difficult points, review your work and guide you when you need help. You will also get AI prompts to help you think of possible reasons. You must check the evidence before deciding on an answer.
Who can join?
UG students, diploma students and fresh graduates from IT and non-IT backgrounds can apply. You can start with the basics. No advanced knowledge is needed.
Duration: 60 days
Tools: Excel, SQL and Power BI
Support: Mentor guidance
You will practise checking data, finding errors, preparing reports and building dashboards. This internship is for learning and practice. It does not guarantee a job or placement.
Internship Overview
Internship Introduction
Have you ever wondered why two company reports show different sales numbers? During this 60-day Data Analyst Internship, you will explore such problems using sample company files, Excel, SQL and Power BI. You will learn how to check data, find mistakes, understand reports and build dashboards with help from a mentor.
What Students Will Learn
You will learn how to work with Excel data, write basic SQL queries and create dashboards using Power BI. You will practise comparing sales reports, finding missing and duplicate records, checking numbers and understanding why reports do not match. You will also learn how to explain your findings in a simple report.
Real Work Exposure Details
You will study office-based problems faced by Data Analytics teams. For example, a sales dashboard shows ₹18 lakh, but the Finance report shows ₹22 lakh. Another task involves finding 1,841 unexpected extra records in a company data table. You will study the given files
Practical Learning Style
You will learn by working on practical files, reports and assignments. Each task will give you a problem to understand and solve step by step. You will compare numbers, check records, find possible reasons and prepare reports. Your mentor will review your work
Beginner-Friendly Explanation
New to Data Analytics? You can start with the basics. You do not need advanced technical knowledge to begin. You will learn how to work with data using Excel, understand basic SQL queries and make dashboards in Power BI. Students from IT and non-IT backgrounds can join and learn step by step
Who Can Apply?
This internship is open to students from IT and non-IT backgrounds. Students who have completed 12th, diploma students, FY, SY and TY undergraduate students, and graduates can apply. Students from BCA, BSc IT, BSc Computer Science, BSc, BCom, BA, BBA, BMS, BE and BTech backgrounds can join. You do not need advanced technical knowledge to start. Interest in learning Data Analytics and practising with data is important.
Beginner Friendly
No prior experience required. Perfect for freshers and learners.
No Technical Background Needed
Anyone with a basic computer understanding can apply.
Education Eligibility
- 12th / HSC
- Diploma 1st Year
- Diploma 2nd Year
- Diploma Final Year
- BCA
- BSc IT
- BSc Computer Science
- BSc
- BCom
- BA
- BBA
- BMS
- BTech
- Graduate Passout
- Post Graduate
Internship Roadmap
Your Internship Learning Journey
Follow your week-by-week learning journey through this internship. Each week is designed to help you build skills, work on real-world tasks, and grow step by step.
- Step-by-step learning path
- Practical & real-world focused
- Build. Practice. Grow.
-
1
Week 1 Understanding Data
Understand what Data Analytics means, how companies use data and why correct information matters. Learn about rows, columns, tables, sales records and reports using simple examples.
-
2
Week 2 Excel Data Practice
Work with Excel sheets containing sales and business records. Learn to sort, filter, compare numbers and find missing or repeated entries.
-
3
Week 3 SQL Basics
Understand how company data is stored in tables. Learn basic SQL queries to find records, check information and get answers from given data.
-
4
Week 4 Finding Report Differences
A sales dashboard shows ₹18 lakh, but the Finance report shows ₹22 lakh. Compare the given files, check report timings and find possible reasons for the difference.
-
5
Week 5 Finding Duplicate Records
Investigate why the same sales records appear more than once. Compare data tables, check record counts and study how duplicate entries can affect sales and refund reports.
-
6
Week 6 Understanding Data Delays
Study how data moves between different systems. Compare given logs and reports to understand why some jobs run twice, data gets delayed and dashboards show old information.
-
7
Week 7 Power BI Dashboards
Use Power BI to present data through charts, tables and dashboards. Organise information, show important numbers and make reports easier to understand.
-
8
Week 8 Final Project & Assessment
Complete a final data analysis task using the skills learned during the internship. Check the given data, find problems, prepare a dashboard and submit a report explaining your findings.
Internship Curriculum
Explore the modules, topics and learning resources covered in this internship.
1 Module 1: Introduction to Data Analytics 5 Topics
Topics Covered
- 1 What is Data Analytics and how companies use data
- 2 Understanding rows, columns and data tables
- 3 Understanding sales records and business reports
- 4 Difference between raw data and useful information
- 5 How incorrect data affects company decisions
Module Notes Study material and additional references View Notes
Learn what Data Analytics means through simple company examples. Understand how companies collect information, store records and use reports to check their daily work. Learn why correct data is important.
Module Assignments Hands-on exercises to practice your learning View Assignments
Identify rows, columns and important information in a sample sales sheet. Find the total sales, count the records and write five observations about the given data.
2 Module 2: Excel for Data Analysis 5 Topics
Topics Covered
- 1 Understanding Excel worksheets, rows and columns
- 2 Sorting and filtering data
- 3 Basic Excel formulas and functions
- 4 Finding missing and repeated records
- 5 Comparing two Excel reports
Module Notes Study material and additional references View Notes
Learn how to work with company data in Excel. Practise sorting, filtering, using basic formulas and checking records. Understand how Excel helps Data Analysts compare information and find mistakes.
Module Assignments Hands-on exercises to practice your learning View Assignments
Work on a sample sales Excel file. Find total sales, filter records, identify missing values and check repeated entries. Submit the corrected sheet with a short explanation of your findings.
3 Module 3: SQL Basics for Data Analysis 5 Topics
Topics Covered
- 1 What is a database and why companies use it
- 2 Understanding database tables and records
- 3 Basic SELECT and FROM queries
- 4 Using WHERE and ORDER BY
- 5 Counting and grouping records
Module Notes Study material and additional references View Notes
Understand how company information is stored in database tables. Learn basic SQL queries to find records, filter information, count entries and organise results.
Module Assignments Hands-on exercises to practice your learning View Assignments
Use the given sample database tables and write basic SQL queries. Find sales records, filter transactions, count entries and display information based on the given questions
4 Module 4: Sales Report Investigation 5 Topics
Topics Covered
- 1 Understanding the sales dashboard mismatch
- 2 Comparing dashboard figures with Excel reports
- 3 Checking report generation and refresh times
- 4 Finding missing sales records
- 5 Preparing a report on possible reasons
Module Notes Study material and additional references View Notes
A sales dashboard shows ₹18 lakh, but the Finance Excel report shows ₹22 lakh. Study the Day 1 case file. Compare the given reports, check missing records and refresh timings, and find possible reasons for the difference.
Module Assignments Hands-on exercises to practice your learning View Assignments
Complete the Day 1 investigation. Compare the given sales figures, identify possible reasons for the mismatch, explain the effect on business reports and prepare a simple investigation report.
5 Module 5: Finding Missing and Duplicate Data 5 Topics
Topics Covered
- 1 Understanding duplicate transaction records
- 2 Comparing staging and production table records
- 3 Finding duplicate transaction IDs
- 4 Understanding retry job records
- 5 Checking how duplicate records affect reports
Module Notes Study material and additional references View Notes
Study the Day 2 case file. The company expected 145,230 records but the table showed 147,071. Understand why extra records appeared, compare the given data and logs, and study how duplicate entries can affect sales and refund reports.
Module Assignments Hands-on exercises to practice your learning View Assignments
Investigate the 1,841 extra records in the given case file. List at least three possible reasons, identify the most likely cause using the available evidence and prepare a report with suggested corrective actions.
6 Module 6: Understanding Data Delays and Reporting Problems 5 Topics
Topics Covered
- 1 Understanding data movement between systems
- 2 Reading scheduler and retry job logs
- 3 Comparing old and new job timings
- 4 Understanding delayed reports and dashboard updates
- 5 Finding possible reasons for repeated job execution
Module Notes Study material and additional references View Notes
Study the Day 3 case file. Understand how migration changes, repeated jobs and timing differences can affect company reports. Compare the given logs and timelines to find possible reasons for delayed dashboards and duplicate processing.
Module Assignments Hands-on exercises to practice your learning View Assignments
Complete the Day 3 investigation. Compare the before-and-after migration details, identify possible reasons for repeated jobs, explain the effect on dashboards and prepare a report with your findings.
7 Module 7: Power BI and Dashboard Creation 5 Topics
Topics Covered
- 1 Introduction to Power BI
- 2 Understanding data tables in Power BI
- 3 Creating charts and tables
- 4 Building a sales dashboard
- 5 Showing important business numbers clearly
Module Notes Study material and additional references View Notes
Learn how Power BI helps present information through charts, tables and dashboards. Use the given sample sales data to show total sales, product details and other important numbers in an easy-to-understand format.
Module Assignments Hands-on exercises to practice your learning View Assignments
Create a sales dashboard using the given sample data. Include total sales, product-wise sales and other useful details. Submit the dashboard and write a short explanation of what the numbers show.
8 Module 8: Final Data Analysis Project and Assessment 5 Topics
Topics Covered
- 1 Understanding the final business problem
- 2 Checking and comparing the given data
- 3 Finding missing and duplicate records
- 4 Creating a Power BI dashboard
- 5 Preparing the final investigation report
Module Notes Study material and additional references View Notes
Bring together the skills learned during the internship. Work on a final business data problem, check the given records, find possible mistakes, prepare a dashboard and explain your findings in a simple report.
Module Assignments Hands-on exercises to practice your learning View Assignments
Complete the final Data Analyst project using the given files. Submit your Excel work, SQL queries, Power BI dashboard and investigation report. Explain the problem, your findings and the reasons behind your conclusions.
Tools & Technologies
Industry-relevant tools, technologies and platforms you will work with during this internship.
Tools
- Android Studio
Technologies
- Angular
Platforms
- AWS
Practical Projects
Work on real-world projects and build a strong portfolio with industry-relevant practicals.
Sales Report Mismatch Investigation
A company's sales dashboard shows ₹18 lakh, but the Finance Excel report shows ₹22 lakh. Compare the given sales files, check report timings, find missing records and identify possible reasons for the difference. Prepare a simple report explaining your findings.
Finding Duplicate Sales Records
A company expected 145,230 records, but its data table shows 147,071. Find out why extra records appeared. Compare the given tables, check duplicate transaction IDs and study how repeated records can affect sales and refund reports.
Investigating Data Delays After Migration
After a company migration, some data jobs start running twice and customer dashboards become slow. Study the given logs, compare old and new timings and find possible reasons for these problems. Prepare a report explaining the findings and their effect on business reports.
Sales Data Analysis and Power BI Dashboard
Use the given sample sales data to create a Power BI dashboard. Show total sales, product-wise sales and other important numbers using charts and tables. Make the dashboard easy to understand and write a short report explaining what the data shows.
Workflow Simulations
Experience real workplace situations, investigate problems, examine evidence, and learn how professionals approach everyday challenges.
Sales Dashboard Showing Wrong Revenue
Office Situation
Monday morning at NeuronStack Analytics, the sales dashboard shows ₹18 lakh revenue, but the Finance Excel report shows ₹22 lakh. The problem started after Friday night's data sync. The reporting team also noticed that dashboard numbers change after refreshes. Naresh Sir asks the Data Analytics team to find out why the numbers are different before the next client meeting.
Problem Statement
The company cannot trust its sales reports because two systems show different revenue figures. Some sales records may be missing, data updates may be delayed or duplicate entries may be affecting the totals. The team needs to find where the numbers first became different and understand how this problem can affect business reports.
Evidence File
Examine the evidence carefully. Click the image to view it in full size.
Your Task
1. Compare the sales dashboard and Finance Excel report. 2. Check the dashboard refresh time and Finance report time. 3. Study the ETL monitoring alert showing 1,842 skipped rows. 4. Check the given logs for retry activity and duplicate transaction IDs. 5. List at least three possible reasons for the mismatch. 6. Prepare an investigation report with your findings.
Expected Solution
The student should identify that the dashboard and Finance report use data from different refresh times. The ETL alert also shows 1,842 skipped rows, which may explain part of the difference. The student should list possible causes, support the most likely explanation with evidence, explain the effect on sales reports and suggest suitable corrective actions.
Assignement and Assessments.
Complete all assignments and assessments to successfully finish this internship.
Data Analytics – Office Problem Investigation
Investigate three office-based data problems using the supplied Day 1, Day 2 and Day 3 files. Compare sales reports, find missing and duplicate records, study retry job logs and understand changes after cloud migration. Identify at least three possible reasons for each problem, support your findings with evidence and prepare a report explaining the business impact and suggested corrective actions.
2. MCQ Test
Test your theoretical understanding.
Complete a 20-question MCQ test covering Data Analytics basics, Excel, SQL, data cleaning, missing records, duplicate transactions, report comparison, data refresh timing, retry jobs and Power BI dashboards. Questions will be based on the topics and practical cases covered during the internship. Each question will have four options, with one correct answer.
3. Practical Assessment
Apply your skills to a practical task.
Complete a practical data investigation using the supplied company files. Compare sales records, check missing and duplicate entries, study the given logs and identify possible reasons for reporting problems. Use Excel and basic SQL where required. Prepare a Power BI dashboard using the given sample data and submit a report explaining the problem, your findings and suggested actions
4. Passing Score
Understand the passing requirements.
MCQ Test
20%
Practical Data Investigation
40%
Power BI Dashboard
20%
Final Investigation Report
20%
Total
100%
Career Opportunities
Discover career roles and the skills that can help you build your future.
Junior Data Analyst
A Junior Data Analyst works with company data to find useful information. They check Excel reports, find missing or repeated records, use SQL to get information from databases and create Power BI dashboards. They help teams understand sales, customers and daily business reports.
Required Skills
MIS Executive
An MIS Executive prepares daily, weekly and monthly reports for a company. They collect information from different Excel files, check numbers, find mistakes and prepare reports for managers. They help teams understand business performance through correct and updated information.
Required Skills
Reporting Analyst
A Reporting Analyst prepares reports and dashboards using company data. They compare numbers, check changes in reports and find information that needs attention. They use Excel, SQL and Power BI to help business teams understand what is happening and make better decisions.
Required Skills
Key Benefits
Here are the key benefits you will gain from this internship. Build real skills, get practical experience, and move closer to your career goals.
Learn with Real Office Problems
Work on sample company problems, such as sales reports showing different numbers, missing records and repeated transactions. Understand how Data Analysts investigate these problems
Frequently Asked Questions
Find answers to the most common questions about this internship.
What will I learn during this 60-day Data Analyst internship?
You will learn how to work with company data using Excel, SQL and Power BI. You will practise checking sales reports, finding missing and duplicate records, understanding data problems and creating dashboards. You will also work on practical assignments based on office situations, with mentor support.
Can beginners and non-IT students join this internship?
Yes. Both IT and non-IT undergraduate students can apply. You do not need previous work experience in Data Analytics. The internship starts with basic concepts and moves towards practical tasks. An interest in working with numbers, solving problems and learning new things will help you.
Will I get a job after completing this internship?
No job or placement is guaranteed. This internship helps you learn Data Analytics, practise with sample company problems and build practical project work. You can use the skills and project examples you complete to prepare for entry-level roles such as Junior Data Analyst, MIS Executive and Reporting Analyst.
Certificates & Documents
Complete the internship and earn certificates that add real value to your career.
Internship Certificate
Shareable certificate to boost your professional profile
Internship Completion Letter
Official experience letter for your academic & career growth
Completion Rules
Follow these requirements to earn your certificate & letter
To receive the Internship Completion Certificate and Completion Letter, students must meet the following requirements:
- Complete the 60-day internship learning activities.
- Attend the scheduled mentor-led learning sessions.
- Complete and submit the assigned practical tasks.
- Complete the Day 1, Day 2 and Day 3 office-based case studies.
- Complete the Excel, SQL and Power BI practical projects.
- Submit the final Data Analyst project and investigation report.
- Complete the final MCQ test and practical assessment.
- Meet the minimum passing score set by EARGS Learning Solutions Pvt. Ltd.
Certificates and completion letters will be issued only after the student's work has been reviewed and the completion requirements have been met.