Learning data analytics involves more than understanding tools and concepts. You need to work with data, practise analysis, build dashboards and apply your knowledge to business problems. Regular practice and project work can help connect classroom concepts with practical applications.
The Data Analytics Course in Pune by PW SkillShala provides offline classroom-based learning with hands-on projects, guided practice and career-readiness support. The programme covers core analytics tools such as Excel, SQL and Python, along with Power BI, Tableau, statistics, business analytics and Generative AI.
PW SkillShala is the offline learning initiative of PW Skills designed to provide classroom-based practical learning experiences. The Data Analytics Course in Pune brings technical learning, project work and career preparation into one programme.
The learning flow follows Learn → Analyse → Visualise → Present. Along with technical skills, learners work on project explanation, data storytelling and cross-functional team collaboration.
The programme includes:
Offline classroom learning
Guided projects
Hands-on practice
Weekly doubt sessions
Assignments and assessments
Industry projects
Resume building
Mock interviews
Placement preparation
Placement support
The PW SkillShala offline centre for the Data Analytics Course in Pune is located at:
PW Skillshala Offline Centre - Pune
Address: 4th-floor Unit No. 302, Krome Mall, Survey No. 32, Amar Manor, Pune - Solapur Rd, Swami Vivekanand Nagar, LandMark, Hadapsar, Pune, Maharashtra
Phone: 7314623448
The programme is intended for learners who want to build a path into analytics or develop their existing data skills. It is suitable for:
B.Tech Students
BCA / B.Sc Students
MBA Students
Fresh Graduates
Working Professionals
Career Switchers
Learners should have basic computer knowledge and be a graduate or final-year student. An interest in data and technology and a willingness to learn and upskill are also part of the fit criteria.
The curriculum covers data handling, databases, programming, visualisation, business analysis and Generative AI. It progresses from foundational tools to an end-to-end industry project.
|
Module |
Topics Covered |
|
Excel for Business Analytics |
Excel Fundamentals, Advanced Formulas (XLOOKUP, INDEX-MATCH, SUMIF), Pivot Tables, Interactive Dashboards, Data Cleaning, Macros, Industry Case Study |
|
Databases & SQL |
DBMS & RDBMS, Data Modeling, DQL, DDL & DML, Joins, Window Functions, CTEs, Views, Stored Procedures, Industry Case Study |
|
Data Visualization |
Power Query, Data Modeling, Power BI, DAX, Interactive Dashboards, Tableau, Storytelling with Data |
|
Generative AI for Analytics |
Prompt Engineering, Large Language Models (LLMs), AI-powered Data Cleaning, AI-assisted Reporting, AI-Optimized ETL, AI-driven Data Visualization |
|
Python for Data Analytics |
Jupyter Notebook, Python Fundamentals, Functions, NumPy, Pandas, Data Cleaning, EDA, Matplotlib & Seaborn |
|
Problem Solving & Business Analytics |
Descriptive Statistics, KPI Frameworks, Funnel Analysis, RCA, Cohort Analysis, Churn Analysis, A/B Testing, Unit Economics, Business Recommendations |
|
Capstone Project |
End-to-end Industry Project with SQL, Python, Power BI/Tableau & AI-driven Business Analysis |
The programme combines technical analytics skills with visualisation, business analysis and communication. Learners can develop the following skills:
Core Analytics
Python fundamentals
Jupyter / VS Code
Data manipulation with Pandas and NumPy
SQL for data storage and queries
Data wrangling and preprocessing
Exploratory Data Analysis (EDA)
Visualisation and Business Intelligence
Matplotlib and Seaborn
Tableau and Power BI dashboards
Data storytelling techniques
Problem Solving and Business Insights
Descriptive Statistics
Inferential Statistics through a self-paced recorded module
A/B Testing and KPIs
Business metrics
ROI-driven analysis
AI and Communication
Using LLMs for smart data processing and insights
Leveraging Generative AI in Analytics
Project Explanation
Data Storytelling
Cross-functional Team Collaboration
Project work forms an important part of the programme, giving learners opportunities to apply different analytics tools to specific use cases.
The projects include:
Unilever Sales Analytics: Sales Dashboard using Advanced Excel & Copilot
City Hospital Healthcare Analytics: SQL-based Hospital Data Analysis
Power BI ETL Dashboard: Power Query + Interactive Business Dashboard
Global Music Streaming Analytics: Python + Power BI Data Analysis
E-Commerce Sales Dashboard: Tableau-based Business Intelligence Dashboard
Student Performance and Learning Style Analysis: Advanced Excel + Statistics
Capstone: Industry-level analytics project from start to finish
The capstone brings together SQL, Python, Power BI/Tableau and AI-driven Business Analysis in an end-to-end industry project.
Data analytics skills can be applied to business intelligence, reporting, strategy and decision-making. Depending on their skills and experience, learners can work towards roles such as:
Data Analyst: Analyse datasets, identify patterns and present insights that support business decisions.
Business Analyst: Work with business data to understand requirements, analyse performance and support decision-making.
MIS Executive: Prepare reports, organise business data and maintain regular reporting processes using analytics tools.
Reporting Analyst: Work on data-based reports and dashboards to present business performance and key metrics.
Power BI Developer: Create interactive dashboards and visual reports using Power BI, data modelling and DAX.
Data Visualisation Analyst: Convert data into charts, dashboards and visual presentations to make insights easier to understand.
The career pathway can progress from Senior Analyst to Analytics Consultant and Analytics Manager.
PW SkillShala uses 4 Career Readiness Assessments, with one assessment at each stage. Every stage is worth 100 marks, and each contributes 25% to the final Readiness Score.
The assessment type is Tech Test + AI Mock Interview. For Pro Batch learners, Stages 2 and 4 also include a Human Mock Interview.
The placement opportunities are linked to the Readiness Score as follows:
|
Level |
Readiness Score |
Placement Opportunities |
|
Level 1 |
40–49% |
Internships, Non-core only |
|
Level 2 |
50–69% |
Internships, Core & non-core |
|
Level 3 |
70% and above |
All internships, Core & non-core |
Learners can receive up to 5 interviews over 3 months at every level. The Readiness Score can be improved through regular assessments throughout the 3-month Placement Assistance period.
Assessments are conducted every 15 days.
Learners with a career gap of more than 2 years are not eligible for Placement Assistance. A career gap of up to 2 years may be considered subject to verification of valid proof such as:
Professional Certifications
Training Programs
Freelancing Experience
Volunteering
Other Relevant Professional Activities
The programme offers a PW Skills + NSDC Co-Branded Certificate based on the specified certification requirements.
The certification process considers attendance and Readiness Score. Learners who do not meet the initial requirements can proceed to the applicable remedial assessment process.
The remedial test is conducted within 2 weeks after course completion and includes a Tech Test + AI Mock Interview for 100 marks.
The certification flow is:
Learners with attendance above 60% and Readiness Score above 40% receive the certificate.
If the initial requirements are not met, attendance above 50% is considered for proceeding with the certification process.
Eligible learners take a remedial test after course completion.
A remedial score above 40% leads to certificate award.
The Data Analytics Course in Pune by PW SkillShala combines offline classroom learning with practical projects, technical training and career preparation. Learners work with Excel, SQL, Python, Power BI and Tableau while developing skills in business analytics and Generative AI. The programme also includes career-readiness assessments, project work, certification and placement assistance, helping you apply your analytics skills to practical use cases.

