Data Analytics with AI 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
- Zero Cost EMI – Pay in Easy Instalments
- Live Instructor-Led Training
- Hybrid Classes (Online + Offline)
- Real Mis & Dashboard Projects
- 2 Year Recorded Session Access & Support
- Future-Ready Curriculum With Generative Tools
Investors who believe in 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 |
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:
Advanced Excel & Office 365 Mastery
Power BI Expert
SQL Server
Power Query + Power Pivot
Python for Data Analysis
Excel VBA Macro
Tableau
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.
15+ Tools you will learn
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:
Working professionals (Non-IT)
College students
IT professionals and developers
Career changers
Marketing and Finance professionals
Freelancers
Entrepreneurs and business owners
MIS and Excel professionals
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.
Get access to 10+ skilling courses
Expert-taught Courses like:
Advanced Excel & Office 365 Mastery
- Power BI Expert
- Power Query + Power Pivot
- SQL Server
- Python for Data Analysis
- Excel VBA Macro
- Power Point Presentation
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 One-time or EMI option. Once payment is confirmed, you’re officially a student at Data Skill Hub. Get all details via email.
Simple, Transparent Course Fees
Total course fee is ₹48,000 (GST inclusive). Choose the option that suits you — pay once and save, or split it into easy monthly EMIs at zero extra cost.
0% Cost EMI • No hidden charges
BEST VALUE • SAVE ₹8,000
💰 One-time Payment
₹40,000
₹48,000
You save ₹8,000 by paying upfront
- ✔ Full 6-month data program
- ✔ One-on-one guidance at your pace
- ✔ Lowest overall price
ZERO EXTRA CHARGES
📅 Easy Monthly EMI
₹8,000
/ month × 6
Total payable (incl. GST)
₹48,000
Pay once instead and it's only ₹40,000
- ✔ Learn now, pay as you go
- ✔ 0% interest, no hidden cost
- ✔ Light on your monthly budget
Know more about the Course
Not ready to enrol yet? Book your free demo session at no cost. See exactly what you’ll learn and how you will learn.
Frequently Asked Questions
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.
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.
Do not worry. We provide recorded sessions of every class, so you can revise or catch up on the missed class at any time.
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.
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.
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.
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.
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.
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.
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.
Start Your Data Analytics Journey in Pune - Enrol Today
Every alternate month, we start a new batch.