Diploma in Data Analytics Course – Computer Guru Training Institute

What You'll Learn

Master Advanced MS Excel — functions, pivot tables, Power Query & Power Pivot for real business data
Query and manage data confidently with SQL & MySQL
Analyze data programmatically with Python, NumPy & Pandas
Visualize data using Matplotlib, Power BI, Tableau & Google Looker Studio
Apply statistics and Exploratory Data Analysis (EDA) to uncover business insights
Understand business analytics, data modeling, ETL concepts & API data handling
Build predictive models with basic Machine Learning & AI tools for data analysis
Automate reports, manage projects with Git & GitHub, and build a job-ready portfolio

Course Description

This 12-month, offline, instructor-led Diploma in Data Analytics course takes you from computer and spreadsheet fundamentals to industry-ready data analysis using Advanced Excel, SQL, Python, Power BI, Tableau and Google Looker Studio. Every session is conducted in person at our Rishikesh campus in small batches, so our trainers can guide you individually, review your work, and make sure you genuinely understand each concept before moving on.

By the end of the course, you will have completed real-world projects—including sales analysis, HR analytics, financial dashboards, and customer analysis—and will be prepared for roles such as Data Analyst, Business Analyst, BI Analyst, Reporting Analyst, or Junior Data Scientist.

Course Content

12 modules • 55 classroom sessions • 12 months • Offline batches only

Computer FundamentalsSession 1
Advanced MS ExcelSession 2
Advanced Excel FunctionsSession 3
Data CleaningSession 4
Data ValidationSession 5
Module AssessmentSession 6

Pivot TablesSession 1
DashboardsSession 2
Power QuerySession 3
Power PivotSession 4
Practical: Sales Analysis DashboardSession 5
Module AssessmentSession 6

SQL & MySQLSession 1
Database ManagementSession 2
Practical: Business Reporting with SQLSession 3
Module AssessmentSession 4

Python ProgrammingSession 1
NumPySession 2
PandasSession 3
Practical: Data Analysis with PandasSession 4
Module AssessmentSession 5

MatplotlibSession 1
Data VisualizationSession 2
Practical: Customer Analytics VisualizationSession 3
Module AssessmentSession 4

Statistics for Data AnalyticsSession 1
Exploratory Data Analysis (EDA)Session 2
Practical: EDA on Real-World DatasetSession 3
Module AssessmentSession 4

Business AnalyticsSession 1
Data ModelingSession 2
ETL ConceptsSession 3
API Data HandlingSession 4
Practical: HR Analytics ReportSession 5
Module AssessmentSession 6

Microsoft Power BISession 1
Practical: Financial Dashboard in Power BISession 2
Module AssessmentSession 3

TableauSession 1
Google Looker StudioSession 2
Practical: Business Reporting DashboardSession 3
Module AssessmentSession 4

Basic Machine LearningSession 1
AI Tools for Data AnalysisSession 2
Report AutomationSession 3
Practical: Predictive Sales AnalysisSession 4
Module AssessmentSession 5

Git & GitHubSession 1
Practical: Customer Segmentation AnalysisSession 2
Module AssessmentSession 3

Resume BuildingSession 1
Interview PreparationSession 2
Portfolio DevelopmentSession 3
Practical: Capstone — End-to-End Business Analytics ProjectSession 4
Final Presentation & CertificationSession 5

Requirements

Basic computer knowledge (typing and internet browsing)
No prior data analytics or programming experience required — we start from the basics
A notebook and willingness to practice between sessions
Minimum qualification: 10th pass or above (graduation preferred)

Who This Course Is For

Students and graduates who want to start a career as a Data Analyst, Business Analyst or BI Analyst
Working professionals looking to upskill into Reporting Analyst or Junior Data Scientist roles
Anyone who wants to make confident, data-driven business decisions using Excel, SQL, Python & Power BI
Anyone who prefers learning in person over online video courses

This Course Includes

100% Offline Classroom Sessions
Duration: 12 Months
Level: Beginner to Advanced
10+ Real-World Projects Included
Industry-Recognized Certification
Internship & Placement Assistance
Study Material Included
Available at Both Branches
Small Batch, Personal Attention

Affordable Fees

Book Free Demo Class

Call / WhatsApp: 7500679066

What You'll Learn

Course Description

Course Content

Module 1: Computer Fundamentals & Advanced MS Excel 6 Sessions • Month 1

Module 2: Excel Pivot Tables, Dashboards & Power Tools 6 Sessions • Month 2

Module 3: SQL, MySQL & Database Management 4 Sessions • Month 3

Module 4: Python Programming for Data Analytics 5 Sessions • Month 4

Module 5: Data Visualization with Matplotlib 4 Sessions • Month 5

Module 6: Statistics & Exploratory Data Analysis 4 Sessions • Month 6

Module 7: Business Analytics & Data Modeling 6 Sessions • Month 7

Module 8: Microsoft Power BI 3 Sessions • Month 8

Module 9: Tableau & Google Looker Studio 4 Sessions • Month 9

Module 10: Basic Machine Learning & AI Tools 5 Sessions • Month 10

Module 11: Git & GitHub for Data Projects 3 Sessions • Month 11

Module 12: Career Preparation & Capstone Project 5 Sessions • Month 12

Requirements

Who This Course Is For

This Course Includes

Ready To Start Your Computer Career?