LiveNew batch open · Book a free demo

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.

Tools you’ll masterExcelSQLPower BITableauPython
Sales Performance DashboardSample data
Revenue₹48.2L▲ 12.4%
Orders3,912▲ 8.1%
Returns2.3%▼ 0.4%
Monthly revenue trend
Sales by region
SouthWestNorthEast
InsightsFrom raw data to decisions
DashboardsPower BI & Tableau
SELECT region, SUM(sales)
FROM orders GROUP BY region;
Advanced ExcelSQLPower BITableauPythonPandasStatisticsPower QueryDAXData CleaningDashboardsChatGPT for AnalystsAdvanced ExcelSQLPower BITableauPythonPandasStatisticsPower QueryDAXData CleaningDashboardsChatGPT for Analysts
Tools trained

The analyst’s complete toolkit.

Learn the five tools that appear in almost every data analyst job description in India.

Spreadsheets

Advanced Excel

Formulas, pivot tables, Power Query and Excel dashboards.

Databases

SQL

Query, join and aggregate data straight from databases.

Business intelligence

Power BI

Data models, DAX and interactive business dashboards.

Visual analytics

Tableau

Visual stories, maps and dashboards that explain data.

Programming

Python

Pandas, NumPy and charts for cleaning and analysis.

Who it’s for

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.

Why choose us

Learn with real data,
not just theory.

Seven reasons learners choose PCR Academy for Data Analysis.

Live

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.

10+

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.

Call 91213 84625
The analysis process

How analysts turn data into decisions.

You’ll practise every step of the real-world data analysis workflow.

AskDefine the business question
CollectGather data with SQL & Excel
CleanFix errors, gaps & duplicates
AnalyseFind patterns with statistics
VisualiseBuild dashboards & charts
SharePresent insights to act on
Course curriculum

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
Want the detailed syllabus, timings and fees?Message us on WhatsApp and we’ll send everything over.
Get syllabus on WhatsApp
Hands-on projects

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.

Power BIDAX

E-commerce analysis

Answer real business questions on orders, customers and revenue with SQL.

SQLJoins

HR attrition study

Find the factors behind employee attrition and present insights.

ExcelStatistics

Financial report

Automate a monthly report with pivot tables and Power Query.

ExcelPower Query

Data story

Turn a dataset into a visual story with dashboards and maps.

Tableau

Exploratory analysis

Clean, explore and visualise a real dataset end to end in Python.

PandasSeaborn
Careers

Roles you can apply for.

Every industry — from banking and e-commerce to healthcare — needs people who can make sense of data.

Data AnalystBusiness AnalystBI / Power BI DeveloperMIS AnalystReporting AnalystOperations AnalystJunior Data Scientist
How it works

Your learning journey.

01

Attend a free demo

Meet your trainer and see how we teach.

02

Master the tools

Excel, SQL, Power BI, Tableau and Python.

03

Build real projects

Analyse real datasets and build dashboards.

04

Get job-ready

Portfolio, resume and mock interviews.

FAQ

Questions, answered.

Do I need coding or maths experience?
No. We start with Excel and basic statistics, then introduce SQL and Python step by step. Basic school-level maths is enough.
What’s the difference between Data Analysis and Data Science?
Data Analysis focuses on finding insights and building reports and dashboards from existing data. Data Science goes further into machine learning and predictive models. Data Analysis is a great first step into the data field.
Which tools will I learn?
Advanced Excel, SQL, Power BI, Tableau and Python (Pandas, NumPy and visualisation libraries), plus AI tools like ChatGPT for analysis.
Is placement support available?
Yes. We help with portfolio building, resume preparation, mock interviews and job assistance.
Can I attend a demo before joining?
Yes. Call 91213 84625 or message us on WhatsApp to book a free demo class.
Get in touch

Book your free
demo class.

Talk to our team and start your data career.

  • Free demo class
  • Detailed syllabus
  • Batch timings and fee details
Start today

Take the first step toward your data career.

Book a free demo class and build your first dashboard with us.