GoDigi InfoTech Call

Data Analyst Course in Kharadi, Pune

Job-oriented training in Excel, SQL, Python, Power BI and Tableau, taught by industry experts at GoDigi InfoTech. Learn on real datasets, build a portfolio and get help with interviews and placements.

  • Classroom & online
  • Beginners welcome
  • Live projects
  • Mock interviews
  • Placement support
View syllabus

Get free counselling

4 monthsCourse duration
150+ hrsOf learning
30+Case studies & projects
10+Languages & tools
1000+Students trained
4.8 ★Google rating

Become a job-ready data analyst

A data analyst turns raw data into decisions. You collect and clean data, find patterns with SQL, Excel and Python, and present the story through dashboards that managers can act on. Banks, e-commerce, IT services, healthcare, logistics and startups all hire analysts, and Kharadi is one of Pune’s largest IT and business hubs.

Our programme is built around the real job. You learn the tools, apply them on business datasets, and finish with a capstone project and interview preparation. Fresh graduates, working professionals and career switchers are all welcome.

Who is this course for?

Freshers and graduates

Science, commerce, engineering, BCA, BBA and other streams who want a job-ready skill.

Working professionals

MIS, accounts, sales, operations and support staff who want to move into analytics.

Career switchers

People from non-IT backgrounds. We start from the very basics.

Business owners

Learn to read your own data and make better decisions.

Tools and technologies covered

  • Excel
  • SQL
  • MySQL
  • Python
  • NumPy
  • Pandas
  • Matplotlib
  • Seaborn
  • Power BI
  • Tableau
  • Jupyter
  • Git & GitHub

Data Analyst course syllabus

13 modules from basics to capstone. Tap a module to see the topics.

Module 1: Introduction to Data Analytics
  • What data analytics is and where industries use it
  • Descriptive, diagnostic, predictive and prescriptive analysis
  • Role of a data analyst and the analytics process
Module 2: Data Collection and Data Types
  • Quantitative vs qualitative, structured vs unstructured data
  • Primary and secondary sources, surveys, APIs, web scraping
  • Relational vs non-relational databases
Module 3: Data Cleaning and Preparation
  • Missing values, outliers and inconsistencies
  • Normalisation, standardisation and encoding
  • Wrangling in Pandas, Excel and Power BI
Module 4: Exploratory Data Analysis (EDA)
  • Mean, median, mode, standard deviation, distributions
  • Histograms, box plots and scatter plots
  • Correlation and covariance
Module 5: Statistics for Data Analysis
  • Probability, sampling, confidence intervals
  • Hypothesis testing, t-test, chi-square, ANOVA
  • Linear and logistic regression, p-value
Module 6: Data Visualization
  • Principles of effective charts
  • Pivot tables and dashboards in Excel
  • Interactive reports in Power BI, basics of Tableau
Module 7: Advanced Excel
  • VLOOKUP, XLOOKUP, INDEX-MATCH, array formulas
  • Pivot tables, pivot charts and dynamic reports
  • Analysis ToolPak and Solver
Module 8: SQL for Data Analysis
  • SELECT, WHERE, JOINs, GROUP BY, aggregates
  • Subqueries, UNION, window functions (ROW_NUMBER, RANK)
  • INSERT, UPDATE, DELETE and SQL for data cleaning
Module 9: Python for Data Analytics
  • Jupyter and Anaconda setup, Python basics
  • Pandas and NumPy for data manipulation
  • Matplotlib and Seaborn visualisation
Module 10: Statistical Modelling and Machine Learning
  • Supervised vs unsupervised learning
  • Linear and multiple regression, logistic regression
  • KNN, decision trees, random forest, K-means
Module 11: Business Intelligence and Reporting
  • Power BI reports, Power Query and data models
  • Tableau interface, connections and dashboards
  • Data storytelling and reporting best practices
Module 12: Capstone Project
  • Define a problem, collect and prepare data
  • Analyse, visualise and present insights
  • Real business cases: sales, customer segmentation
Module 13: Soft Skills and Interview Preparation
  • Problem solving and teamwork
  • Resume, LinkedIn and portfolio
  • Mock interviews and how to crack them

Projects you will build

Every project goes into your portfolio and GitHub.

Sales performance dashboard

Revenue, profit and growth by region and product in Power BI.

Customer segmentation

Find high-value, repeat and at-risk customers using SQL and Python.

HR attrition analysis

Understand why employees leave, with Excel and Pandas.

E-commerce funnel analysis

Measure drop-offs from visit to purchase and suggest fixes.

Expense and finance report

Automate a monthly report in Excel and Python.

Capstone project

Pick a business problem, analyse it and present your findings.

GoDigi Assist: support at every step

Course onboarding

We introduce the structure, study material and learning platform from day one.

Live session support

Mentors help with doubts in real time so you do not fall behind.

One-on-one mentoring

Personal guidance on tough concepts, assignments and career choices.

Project feedback

Reviews that make your projects industry-relevant and interview-ready.

Upcoming batches

Limited seats per batch to keep sessions interactive.

Mon, 23 Nov 2026Weekday (Mon–Fri) · Classroom
Mon, 23 Nov 2026Weekday (Mon–Fri) · Online
Sat, 21 Nov 2026Weekend (Sat–Sun) · Classroom
Sat, 21 Nov 2026Weekend (Sat–Sun) · Online

Placement and career support

  • Resume and LinkedIn profile building
  • Portfolio on GitHub and Tableau Public
  • Mock technical and HR interviews
  • Communication and soft skills training
  • Job alerts and application tracking
  • Company referrals through our network
  • Roles: Data Analyst, Business Analyst, Reporting Analyst, MIS Executive, BI Analyst
  • Typical fresher packages: ₹3–6 LPA; with experience ₹6–10 LPA or more (varies by skills and interview performance)

Companies in our hiring network

  • TCS
  • Cognizant
  • Capgemini
  • Accenture
  • Wipro
  • HDFC
  • KPMG
  • Persistent
  • Cybage
  • Amdocs

Industry-recognised certificate

Complete the course and capstone to receive a GoDigi InfoTech certificate that you can add to your resume, LinkedIn profile and job applications. We are an ISO-certified institute.

Frequently asked questions

Do I need coding knowledge to join?

No. The course starts from the basics and builds up Excel, SQL and Python step by step. Basic computer knowledge is enough, and maths is helpful but not mandatory.

Who can join the Data Analyst course?

Graduates from science, commerce, engineering and other streams, working professionals and career switchers can join.

How long is the course and what are the batch options?

The course runs for about 4 months with 150+ hours of learning. Weekday (Mon–Fri) and weekend (Sat–Sun) batches are available in classroom and online mode.

Which tools will I learn?

Excel, SQL/MySQL, Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI and Tableau, plus basic statistics and machine learning.

What does placement support include?

Resume and LinkedIn profile building, portfolio preparation, mock technical and HR interviews, job alerts, communication training and referrals through our network. We support you throughout, but we cannot guarantee a job.

What salary can a fresher expect?

Typical fresher packages are around ₹3–6 LPA, and candidates with relevant experience or strong projects may get ₹6–10 LPA or more. Actual offers depend on your skills, projects and interview performance.

Which job roles can I apply for?

Data Analyst, Business Analyst, Reporting Analyst, MIS Executive, BI Analyst, Data Visualization Specialist and Junior Data Scientist.

Is the course available online?

Yes. You can attend live online classes or classroom sessions in Kharadi, Pune.

Can I attend a demo class?

Yes. Tap “Book free demo” or message us on WhatsApp to schedule one.

Visit us in Kharadi, Pune

Our campus is in Kharadi, close to major IT parks, offices and residential areas, with good road and public transport connectivity. Students also join from Wagholi, Viman Nagar, Hadapsar, Mundhwa, Magarpatta and Chandannagar.

GoDigi InfoTech
314, Global Business Hub, Kharadi, Pune - 411012

Book your free demo class

Book your free demo