Data Analytics Internship - 15 Days Online Training Program
Join 15 Days Data Analytics Online Internship Training Program at NextVision Infotech. Learn Excel, SQL, Power BI, data visualization, dashboards. ₹249 only with certificate.
Program Description
Skills You'll Learn
Projects You'll Work On
Complete Data Analytics Project (15 Days Online)
Students will complete a data analytics project including data cleaning, Excel analysis, SQL queries, Power BI dashboard, data visualization, and complete project documentation as per industry standards.
Program Modules
W1: Week 1: Data Analytics Fundamentals and Excel
Introduction to data analytics, types of analytics - descriptive, diagnostic, predictive, prescriptive, data analytics lifecycle, data types, data sources, data quality, data cleaning, Excel fundamentals, Excel interface, formulas and functions, lookup functions - VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP, logical functions - IF, AND, OR, nested IF, text functions, date functions, math functions, statistical functions, pivot tables, pivot charts, slicers, conditional formatting, data validation, what-if analysis, power query in Excel, power pivot in Excel.
W2: Week 2: SQL, Power BI, Visualization, Live Projects, and Certification
Introduction to databases, relational database concepts, SQL fundamentals, SELECT statement, WHERE clause, ORDER BY, GROUP BY, HAVING, JOINs - inner join, left join, right join, full join, subqueries, aggregate functions - SUM, AVG, COUNT, MIN, MAX, string functions, date functions, case statements, introduction to Power BI, Power BI Desktop, connecting to data sources, Power Query, data transformation, data modeling, relationships, calculated columns, measures, DAX basics, data visualization - bar charts, line charts, pie charts, maps, KPI cards, slicers, filters, dashboard design principles, live projects - sales dashboard, HR dashboard, complete documentation, viva-voce examination, certificate distribution.
Key Features
What You'll Learn
Examination Details
| Exam Name | Full Marks | Pass Marks |
|---|---|---|
| Module-wise Assessment | 100 | 40 |
| Project Evaluation | 100 | 50 |
| Final Presentation | 50 | 25 |
| Viva-Voce | 50 | 25 |
Internship Details
Prerequisites
- Pursuing or completed B.Tech/B.E./BCA/MCA/B.Sc./B.Com/MBA in any discipline
- Basic knowledge of Excel
- Basic computer knowledge
- Interest in data analytics
- Laptop/PC with internet connection
Who Can Enroll ?
- B.Tech students (1st to 8th semester)
- BCA/MCA students
- B.Sc. students
- B.Com students
- MBA students
- Data analytics aspirants
- Working professionals wanting to upskill
- Students from all over India seeking online practical training
Certificate Preview
Related Internships
You might also be interested in these
Our Students Did It! 🎉 Certified & Proud
A big congratulations to our students who recently completed their courses and earned their certificates. Here's what they have to say! 🎓
Our Certificate Samples
Internship Certificate
Tap to view
Joining Letter
Tap to view
Student ID Card
Tap to view
Student Panel
Tap to view
All certificates are issued by NextVision Infotech & are verifiable upon request.
Ready to Start Your Journey?
Take the first step towards your dream career with our internship programs