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
Get free counselling
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
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.
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
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