Data Analysis.
Turn data into decisions.
Learn to clean, analyse and visualise data with Excel, SQL, Power BI, Tableau and Python — and turn raw numbers into insights that businesses act on.
FROM orders GROUP BY region;
The analyst’s complete toolkit.
Learn the five tools that appear in almost every data analyst job description in India.
Advanced Excel
Formulas, pivot tables, Power Query and Excel dashboards.
SQL
Query, join and aggregate data straight from databases.
Power BI
Data models, DAX and interactive business dashboards.
Tableau
Visual stories, maps and dashboards that explain data.
Python
Pandas, NumPy and charts for cleaning and analysis.
For anyone who likes
solving problems.
No coding background needed — we start with Excel and build up step by step.
Students & freshers
Start a career in one of the most in-demand entry-level roles.
Working professionals
Add data skills to grow in finance, sales, HR or operations.
Career switchers
Move into data from non-IT backgrounds with hands-on training.
Business owners
Understand your numbers and make smarter decisions.
Learn with real data,
not just theory.
Seven reasons learners choose PCR Academy for Data Analysis.
Live practical training
Work through real datasets live with your trainer — every class ends with an insight you found.
Real client & agency projects
Analyse real business data.
Advanced AI tools
Analyse faster with ChatGPT and AI.
Small batch, personal attention
Lifetime support + mentorship
We stay with you after the course.
Affordable fees with instalments
Start learning now and pay in easy instalments.
Years experienced trainers
Mentors with over a decade of industry experience.
Attend a free demo class.
See how we teach before you join — no commitment.
How analysts turn data into decisions.
You’ll practise every step of the real-world data analysis workflow.
Data analysis
course curriculum.
Eight modules that take you from spreadsheets to dashboards and Python. Tap a module to see what’s inside.
01Data analytics foundations
- Role of a data analyst
- Types of data
- Analytics lifecycle
- Framing business problems
02Advanced Excel
- Formulas & functions
- XLOOKUP / VLOOKUP
- Pivot tables
- Charts
- Power Query
- Excel dashboards
03Statistics for analysis
- Descriptive statistics
- Distributions
- Probability basics
- Hypothesis testing
- Correlation
04SQL for data analysis
- SELECT & filtering
- Joins
- GROUP BY & aggregates
- Subqueries & CTEs
- Window functions
05Power BI
- Power Query
- Data modelling
- DAX basics
- Interactive dashboards
- Publishing & sharing
06Tableau
- Connecting data
- Calculated fields
- Charts & maps
- Dashboards & stories
07Python for data analysis
- Python basics
- NumPy
- Pandas
- Data cleaning
- Matplotlib & Seaborn
- EDA
08Projects, AI & interview prep
- ChatGPT for analysts
- Case studies
- Portfolio
- Resume & mock interviews
Projects for your
portfolio.
Build real analysis projects you can walk interviewers through.
Sales dashboard
Build an interactive sales dashboard with KPIs, trends and drill-downs.
E-commerce analysis
Answer real business questions on orders, customers and revenue with SQL.
HR attrition study
Find the factors behind employee attrition and present insights.
Financial report
Automate a monthly report with pivot tables and Power Query.
Data story
Turn a dataset into a visual story with dashboards and maps.
Exploratory analysis
Clean, explore and visualise a real dataset end to end in Python.
Roles you can apply for.
Every industry — from banking and e-commerce to healthcare — needs people who can make sense of data.
Your learning journey.
Attend a free demo
Meet your trainer and see how we teach.
Master the tools
Excel, SQL, Power BI, Tableau and Python.
Build real projects
Analyse real datasets and build dashboards.
Get job-ready
Portfolio, resume and mock interviews.
Questions, answered.
Do I need coding or maths experience?
What’s the difference between Data Analysis and Data Science?
Which tools will I learn?
Is placement support available?
Can I attend a demo before joining?
Book your free
demo class.
Talk to our team and start your data career.
- Free demo class
- Detailed syllabus
- Batch timings and fee details
Take the first step toward your data career.
Book a free demo class and build your first dashboard with us.
