Data Analyst Course in Pune – Live Classes with Real Projects

Become a job-ready data analyst with live, hands-on data analytics training in Pune. Learn Advanced Excel, Power BI, SQL, Python, Power Query, and Generative AI through real business projects, expert mentorship, hybrid classes, and practical dashboard training designed for today’s hiring market.

• 6 Month Industry-Focused Training
• 0 Cost EMI – Pay in Easy Instalments
• Live Instructor-Led Training
• Hybrid Classes (Online + Offline)
• Real Mis & Dashboard Projects
• 1-Year Recorded Session Access & Support
• Future-Ready Curriculum With Generative Tools

CTA: Free Demo Session | WhatsApp Us

Enrol in Data Skill Hub’s Data Analyst Mentorship Program in Pune to gain the skills and confidence essential for a successful career in data analytics.

Every major company in Pune, from TCS and Infosys to Bajaj and KPMG, runs on data. The demand for skilled data analysts is high. Have a successful career with our comprehensive data analyst training classes that cover the latest tools and technologies, including Advanced Excel, Power Query, Power BI, SQL, Python, and Generative AI. We make sure that you get ready for the modern business intelligence environment.

At Data Skill Hub, we provide the most structured, live, and practical courses built for people who want to work with data professionally. You will gain the real expertise to solve real-world business challenges under our expert trainer, Mohammed Shabbir. We are highly focused on hands-on training with real MIS and dashboard projects so that you can build practical experience alongside strong theoretical foundations. 

Join our data analyst course in Pune with hybrid classes (offline in Hinjewadi, Viman Nagar, Kothrud, etc or online from anywhere) and take your first steps towards becoming a job-ready data analyst.

Course Name	Certified Data Analytics Mentorship Program
Offered By	Data Skill Hub
Mode	Hybrid, accessible from anywhere in Pune
Schedule	Saturday and Sunday
Missed a Session?	Access the recording
Community	WhatsApp group + community forum
YouTube Support	2,000+ subscribers, 125+ free lectures
Certification	Data Skill Hub Certificate – verifiable online

CTA: Enrol in the Data Analytics Course in Pune – Seats Are Limited

From Excel To Python – What’s Included In Our Data Analytics Training In Pune?

Data Skill Hub’s Certified Data Analytics Mentorship Program covers the full data analytics stack – from Excel and Power Query to Power BI dashboards, SQL databases, and Python for data analysis. Here is our 8-Course Bundle available in this data analytics course in Pune:

1. Advanced Excel & Office 365 Mastery:
2. Power BI Expert
3. SQL Server
4. Power Query + Power Pivot
5. Python for Data Analysis
6. Excel VBA Macro
7. Tableau 
8. PowerPoint Presentation

What You Will Learn – A Complete Data Analytics Course Curriculum

At Data Skill Hub, our data analytics classes are designed around what companies in Pune and across India actually use every day. Each course covers all possible modules, so you get ready with the full data pipeline – from raw data to clear insights.

Advanced Excel 

• Module 1: Essentials – Navigation, worksheet basics, all important shortcut keys.
• Module 2: Data Cleaning – Text to Column, Flash Fill, Remove Duplicates, Find Unique, Trim.
• Module 3: Text Functions – LEFT, RIGHT, SUBSTITUTE, REPLACE.
• Module 4: Date & Time Functions – NETWORKDAYS, WORKDAYS, Time difference, Date difference, Ageing calculation.
• Module 5: Lookup Functions – VLOOKUP, 2D VLOOKUP, VLOOKUP with MATCH, INDEX MATCH, XLOOKUP, Duplicate lookup, Multiple lookup.
• Module 6: Logical Functions – IF, IFERROR, AND, OR.
• Module 7: O365 Functions – FILTER, SORT, UNIQUE, TEXTSPLIT.
• Module 8: Data Tools – Filter, Sort, Data Validation.
• Module 9: Summarisation – SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS.
• Module 10: Advanced Pivot – PivotTables, calculated fields, slicers, pivot charts.
• Module 11: Array Functions – Dynamic arrays and legacy arrays.
• Module 12: Visualisation – Charts, Conditional Formatting, Sparklines.
• Module 13: Dashboard – Create an interactive dashboard using Pivot Charts & Slicers.
• Module 14: Protection & Hyperlink – Sheet/cell protection, hyperlinks.
• Module 15: Macros – Record Macro, understanding basic VBA.

Power Query & Power Pivot

• Module 1: Introduction – User Interface, Load vs Unload, basic navigation.
• Module 2: Data Sources – Connect to Excel, CSV, PDF, Web pages.
• Module 3: Combine Data – Merge multiple sheets, merge multiple files, Append data, Fuzzy match.
• Module 4: Data Profiling – Data Type, Column Profile, Column Quality, Column Distribution.
• Module 5: Data Transformation – Remove blank rows, remove duplicates, merge columns, fill down, text functions, remove other columns, keep rows, remove/replace errors, promote headers, group by, format columns.
• Module 6: Column Operations – Pivot column, unpivot column, add custom column, add conditional column, column from example, index column, split column.
• Module 7: Date Operations – Extract Year/Month/Day, create Financial Year, Auto Calendar, add parameters.
• Module 8: Load Options – Load as Table, Load as Pivot, Only Connection, Add to Data Model, Duplicate & Reference Query.
• Module 9: M Language – Power Query M Code basics, Advanced Editor, List, Record.
• Module 10: Complex Scenarios – Handle inconsistent headers, dynamic columns and rows.
• Module 11: Case Studies – Commodity Price Analysis, Sales Analysis, Attendance & Survey Analysis.

Power BI Desktop & Service

• Module 1: Introduction – Power BI UI, file types (.pbix, .pbit).
• Module 2: Data Sources – Connect to Excel, CSV, SQL Server, PDF, Web, SharePoint, Folder.
• Module 3: Power Query – Complete ETL features (same as Power Query module above).
• Module 4: Data Modelling – Manage relationships, Active vs Inactive, Star schema, Fact & Dimension tables.
• Module 5: DAX – New Column – Multiply, Addition, IF, SWITCH, DATEDIFF, RELATED, USERELATIONSHIP.
• Module 6: DAX – New Table – CALENDARAUTO, Financial Year table, SUMMARIZE, FILTER, GENERATE SERIES.
• Module 7: DAX – New Measure – CALCULATE, FILTER, ALL, ALLSELECTED, HASONEFILTER, SAMEPERIODLASTYEAR, DATEADD, DATESINPERIOD, DATESBETWEEN, LASTDATE, FIRSTDATE, MINX, MAXX, SUMX, DISTINCTCOUNT, COUNTROWS, Variables in DAX.
• Module 8: Quick Measures – Time Intelligence, YOY percentage, Running Total, MTD, YTD, Rolling Average.
• Module 9: Visual Calculations – Create Moving Average directly on visuals.
• Module 10: Data Visualisation – Column charts, Line charts, Pie charts, Table, Matrix, Donut, Tree map, Bubble Map, Filled Map, Single Card, Multi Row Card, Slicer, Funnel, Scatter plot, Word Cloud, Combo Chart, Histogram, Ribbon chart, Stacked Bar, Waterfall, Decomposition Tree, Smart Narrative, Q&A visual.
• Module 11: Formatting – Page formatting, visual formatting, conditional formatting (fx), custom themes.
• Module 12: Interactivity – Drill up/down, single point drill, edit interactions (Highlight/Filter/None), filters (Visual/Page/Report level), create groups (Bins & List), Drillthrough, Bookmarks, Tooltip with charts, Top/Bottom N, Sync slicers, Add buttons and images.
• Module 13: Analytics – Average line, Constant line, Trend line.
• Module 14: Advanced Features – Small multiple, Image card, Image slicer.
• Module 15: Power BI Service – UI overview, create workspaces, add users, assign roles, understand DATASET, create DATAFLOW, publish reports, create RLS (Static & Dynamic), Lineage view, create dashboards from multiple reports, dashboard tiles.
• Module 16: Scheduling & Sharing – Personal gateway, schedule refresh, set alerts, export to PDF/Excel/PPT, share via link/Outlook/Teams, create mobile layout, view on mobile app.
• Module 17: Practice Datasets – Sales (E-commerce), Financial, HR, Car Type, Customer Satisfaction, Social Media, Population Survey (any 3).

SQL Server

• Module 1: Setup – Installation, SSMS setup and configuration.
• Module 2: Database Design – Create database, design tables, establish relationships.
• Module 3: SQL Commands – DQL (SELECT), DDL (CREATE/ALTER/DROP), DML (INSERT/UPDATE/DELETE), DCL (GRANT/REVOKE).
• Module 4: Basics – Clauses, Operators, Data Types, Constraints, Regexp patterns.
• Module 5: Filtering – WHERE clause, HAVING clause, ORDER BY, TOP N, DISTINCT.
• Module 6: Functions – Text functions (CONCAT, SUBSTRING), Date functions (GETDATE, DATEDIFF), Aggregate functions (SUM, AVG, COUNT, MIN, MAX).
• Module 7: Single Table Queries – Extract and analyse data from one table.
• Module 8: Multiple Tables – Extract and combine data from multiple tables.
• Module 9: DML Operations – INSERT new records, UPDATE existing records, DELETE records.
• Module 10: DDL Operations – CREATE tables/views, ALTER structure, DROP objects.
• Module 11: Conditional Logic – Logical columns using IF, CASE statements.
• Module 12: Summarisation – GROUP BY aggregations, UNION, INTERSECT, EXCEPT.
• Module 13: Subqueries – Nested queries, correlated subqueries, EXISTS.
• Module 14: Keys – Primary Key, Foreign Key, Unique Key.
• Module 15: Joins – LEFT JOIN, RIGHT JOIN, INNER JOIN, FULL OUTER JOIN, SELF JOIN.
• Module 16: Interview Preparation – Solve real interview questions using the HR Database.

Python for Data Analysis

• Module 1: Setup – Install Anaconda, Python, Jupyter Notebook.
• Module 2: Environment – Create and manage virtual environments.
• Module 3: Libraries – Install and import Pandas, NumPy, Seaborn, Matplotlib.
• Module 4: Python Basics – Variables, Data types (int, float, string, bool), Operators, Statements
• Module 5: Data Structures – Lists, Tuples, Sets, Dictionaries – creation and manipulation.
• Module 6: Control Flow – For loops, While loops, If/Elif/Else conditions.
• Module 7: File Handling – Read and write Excel files, CSV files.
• Module 8: DataFrames – Create DataFrames, join multiple tables, export to files.
• Module 9: Data Manipulation – Manipulate DataFrames (add/delete columns, filter rows), handle errors and exceptions.
• Module 10: Filtering & Sorting – Filter data with conditions, order data, set indexes, and group by operations.
• Module 11: Exploratory Data Analysis – EDA using Pandas & Matplotlib – summary statistics, distributions.
• Module 12: Data Cleaning – Handle duplicate records, handle null/missing values, split columns.
• Module 13: Statistics – Calculate correlation and covariance between variables.
• Module 14: Automation – Create a BAT file to run Python scripts automatically.

Excel VBA Macro (Bonus)

• Module 1: Recording Macros – Record, save, and run macros.
• Module 2: VBA Editor – Understanding the editor interface (Project Explorer, Properties, Code window).
• Module 3: Variables & Data Types – Declare variables, data types (String, Integer, Double, Boolean).
• Module 4: Loops & Conditions – For loop, For Each loop, Do While loop, If-Then-Else, Select Case.
• Module 5: User Forms – Create forms with buttons, text boxes, and dropdowns.
• Module 6: Error Handling – On Error statements, debugging techniques.
• Module 7: Automation – Automate daily Excel reports and repetitive tasks.

Tableau – Data Storytelling (Bonus)

• Module 1: Interface – Connect to data sources, worksheet navigation.
• Module 2: Basic Charts – Bar charts, line charts, pie charts, scatter plots.
• Module 3: Calculated Fields – Create custom calculations and formulas.
• Module 4: Dashboards – Build interactive dashboards.
• Module 5: Stories – Create data stories with multiple sheets.
• Module 6: Filters & Parameters – Add filters, create parameters for user input.
• Module 7: Maps & Analytics – Build geographic maps, add trend lines and forecasts.

PowerPoint Presentation (Bonus)

• Module 1: Design Principles – Colour theory, font selection, visual hierarchy.
• Module 2: Slide Layout – Master slides, layout templates, consistent structure.
• Module 3: Data Visualisation – Present charts, graphs, and tables effectively.
• Module 4: Animations – Professional animations and transitions.
• Module 5: Professional Deck – Create business-ready presentations.
• AI Integration Across All Modules – ChatGPT, Copilot, Claude, etc.

Who Can Join Our Data Analytics Classes in Pune?

Our data analyst classes in Pune are no longer just for IT professionals. It is suitable for anyone who wants to build a successful career as a data analyst. Our program is designed for absolute beginners. There is no need for coding or a technical background. Here is a list of who can join our program:

• College students
• Working professionals (Non-IT)
• Career changers
• Marketing and Finance professionals
• IT professionals and developers
• Entrepreneurs and business owners
• MIS and Excel professionals
• Freelancers
• MBA graduates and management students

Why is Data Skill Hub the Best Institute for Data Analytics in Pune?

• Live and practical sessions: Get live one-on-one sessions with personal attention directly with an expert mentor. Your actual skills are built with us.
• Real-world projects: Each module comes with a hands-on project, so you can gain business scenario expertise and get job-ready.
• Bilingual teaching: We provide learning in English and Hindi – choose whichever is suitable for you.
• Comprehensive curriculum: Master core concepts, including Excel, SQL, Python, etc., with AI Integration
• Recognised certificate: Industry-recognised certificate and dedicated support to launch your career.
• Industry expert mentor: Learn directly from Mohammed Shabbir, founder of Data Skill Hub, who holds years of expertise.
• One-year support: Our program comes with one year of support. You can access our recorded sessions anytime, anywhere.
• Future skills: The complete curriculum includes AI and ChatGPT integration, so you’re ready for the future.

Data Analytics Certification in Pune – What You Get

When you complete the Certified Data Analytics Mentorship Program at Data Skill Hub, you do not just walk away with the knowledge. You will also get an industry-certified, industry-recognised certification. Our certificate is well recognised in Pune’s competitive market.

Validated Certificate From Data Skill Hub: Competitive edge in the job market with our certificate. It validates your expertise across leading IT companies.

Build Trust With Recruiters: A certificate builds instant credibility. Recruiters spend only 6 to 7 seconds on a resume. With us, leave a lasting impression.

Trained By Real-World Expertise: Proof that you have gained real-world expertise with our practical, hands-on approach to boost job readiness

| Note: The certificate is awarded on the completion of all modules and submission of your final projects. The certificate can also be verified on our official website. Get a professional credential with us for your career growth and strengthen your portfolio to improve hiring prospects.

How To Join Our Data Analytics Classes In Pune

To get started with Data Skill Hub’s Data Analytics Course in Pune, it is very simple. All you have to do is follow these three easy steps:

Step 1: Click on Enrol Now

Simply click on the “Enrol Now” button on our website or WhatsApp to begin your journey.

Step 2: Register Yourself

Register yourself with basic details such as your name, phone number, and email. Create your student account in just 2 minutes.

Step 3: Pay Your Fee

To complete your enrolment, pay the course fee of ₹45,000 + GST. Once payment is confirmed, you’re officially a student at Data Skill Hub. Get all details via email.

—————— CTA ——————-

Not ready to enrol yet? Book your free demo session at no cost. See exactly what you’ll learn and how you will learn.

Contact us for a free demo session.

—————— CTA ——————-

 

Data Analytics Course in Pune – Fees and Enrolment

Data Skill Hub offers transparent, competitive pricing for the Certified Data Analytics Mentorship Program. The course fee includes a complete curriculum, live one-on-one sessions with your mentor, recorded sessions for one year, project assessment, and a well-recognised certificate.

The 6-month data program is priced at just ₹48,000. It significantly covers one-on-one guidance tailored to your pace.

Are you worried about paying ₹48,000 at once? Don’t be. We offer 0 Cost EMI options so you can learn now and pay later with zero extra charges. Choose flexible tenures – 2, 4, or 6 months – as per your convenience.

EMI Option	Amount per Month
2 Months EMI	₹24,000 per month
4 Months EMI	₹12,000 per month
6 Months EMI	₹8,000 per month

What Students Say About Data Analytics Training in Pune at Data Skill Hub

Explore some of our student journeys with our data analytics training in Pune. See why our students call us the best institute for data analytics in Pune.

Frequently Asked Questions

Is this data analytics course self-paced or live?

Yes. You can have a live one-on-one session every Saturday and Sunday. You also get access to session recordings, so you can revise and catch up if you miss a class. 

I have no coding experience. Can I join this data analytics course in Pune?

Yes. If you do not have any coding experience, you can enrol in our class. Our trainer uses a practical and step-by-step approach, so it becomes easier for beginners to understand the basic concepts.

What if I miss my live session or offline session?

Do not worry. We provide recorded sessions of every class, so you can revise or catch up on the missed class at any time.

How is doubt support handled for Pune students?

Doubt support is available every day through WhatsApp and direct trainer email access from 9 AM to 9 PM. If you have any doubts, you can send questions, share your files, or get responses directly from our mentor.

How long does the data analyst course in Pune take to complete?

The data analysis courses in Pune take about six months to complete, with sessions on every Saturday and Sunday. Most students complete the full curriculum within six months, but sometimes it can be shorter or longer according to schedules.

Who is the instructor at Data Skill Hub?

Mohammed Shabbir is the instructor and trainer for all programs and courses. He is a certified trainer with extensive experience in corporate reporting, MIS automation, and dashboard development. With his extensive experience, he has already trained thousands of professionals and focuses on simple explanations, real business scenarios, and hands-on training with a practical approach.

Do I need to pay the complete fee at once?

No, we also provide a 0-cost EMI option. The 48000 course fee is huge, so you can opt for an EMI option for 2 months, 3 months, or 6 months according to your comfort.

Does Data Skill Hub provide a certificate after the course?

Yes. We provide a valid industry-recognised certificate once you complete your course and assigned projects. Our certificate is well recognised by companies and recruiters. In addition, we also give you a chance to validate the certificate on our website.

Who is eligible for data analytics classes in Pune?

There is no strict eligibility requirement. If you want to enter the analytics job market, you are eligible for it. It doesn’t matter whether you are a graduate or not, or have coding experience or not. You just need a basic mathematical and statistical background, a laptop/computer, and a willingness to enter the demanding world of data analytics.

What are the possible data analytics jobs available in Pune?

Once you complete a data analytics course from a reputed institute in Pune, you can apply for Data Analyst, Business Analyst, Power BI Developer, MIS Executive, Operations Analyst, Marketing Analyst, Financial Analyst, BI Analyst, and many more.

 

CTA: Start Your Data Analytics Journey in Pune – Enrol Today

Every alternate month, we start a new batch.

Enrol yourself for the next batch now.