BlogData Analytics BasicsChapter 1
BASICS · CHAPTER 1Beginner

What is Data Analytics?

A complete beginner's guide — what data analytics means, why businesses need it, the 4 types explained with real Indian examples, the tools analysts use, and how to start.

definitionwhy it mattersfour typesreal examplestoolshow to startfaq
DATA ANALYTICS SERIES:Ch 1: What is DA ←Ch 2: Types of Data →Ch 3: The DA Process →

What is Data Analytics?

Data analytics is the process of examining raw data — numbers, transactions, clicks, sensor readings, survey responses — to find patterns, draw conclusions, and help people make better decisions.

Every business generates enormous amounts of data every day. A retail chain records every sale, every product returned, and every customer complaint. A hospital logs every patient visit, every test ordered, and every medication dispensed. A logistics company tracks every pickup, every delivery, and every route taken.

Most of this data sits unused. Data analytics is what converts it from a pile of numbers into answers to questions like: Which products should we stock more of before Diwali? Which customers are about to leave? Why did costs rise 20% this quarter? The output of analytics is always a decision or an action — not just a chart.

SIMPLE DEFINITION

Data analytics = collecting data + cleaning it + analysing it + presenting the insight so someone can make a better decision.

Why Does Data Analytics Matter?

Before data analytics, business decisions were made primarily on gut feel and experience. A store manager would decide how much stock to order based on what felt right. A bank would approve loans based on a loan officer's personal judgement. A marketing team would run the same campaigns as last year because they had worked before.

Data analytics changes this. It replaces guessing with evidence. Here is what that looks like in practice:

WITHOUT ANALYTICS

Order stock based on last year's sales

WITH ANALYTICS

Order based on a demand forecast that accounts for this year's price change, competitor launches, and festival calendar

WITHOUT ANALYTICS

Approve loans based on a loan officer's instinct

WITH ANALYTICS

Approve based on a risk score calculated from 40+ data points about the applicant's financial behaviour

WITHOUT ANALYTICS

Run the same marketing campaign as last year

WITH ANALYTICS

Run personalised campaigns to each customer segment based on what they actually responded to before

WITHOUT ANALYTICS

Fix machines after they break down

WITH ANALYTICS

Predict which machine will break down next week based on sensor data and schedule maintenance before it fails

The companies that use data analytics well make fewer expensive mistakes, spot opportunities earlier, and serve their customers more precisely. This is why demand for data analysts in India has grown every year since 2018 and shows no signs of slowing down.

The 4 Types of Data Analytics

Data analytics is not one single thing — it is a spectrum from simple to complex. The four types build on each other, and most analytics work in Indian companies sits in the first two categories, with the latter two growing rapidly.

Type 1
Descriptive Analytics
Core question: "What happened?"

Descriptive analytics summarises historical data. It tells you what has already happened. This is the most common type of analytics in Indian companies today — monthly MIS reports, dashboard KPIs, and sales summaries are all descriptive analytics.

REAL EXAMPLES
  • Total sales in Q2 FY26 were ₹4.2 crore — up 8% from Q1
  • The Delhi NCR region accounted for 34% of all orders this month
  • Average delivery time was 2.4 days in April vs 3.1 days in March
Common tools: Excel, Power BI, SQL, Tableau
Type 2
Diagnostic Analytics
Core question: "Why did it happen?"

Diagnostic analytics digs into the data to explain why something happened. It involves slicing data by different dimensions (city, category, channel, time) to isolate the cause. Think of it as detective work with data.

REAL EXAMPLES
  • Sales dropped 18% in July — investigation revealed a competitor ran a flash sale on the same dates
  • Return rate spiked to 12% in the electronics category — root cause: a defective batch from one supplier
  • App sign-ups fell after the new onboarding update — A/B comparison revealed the new flow had 2 extra steps
Common tools: SQL (drill-down queries), Excel pivot tables, Power BI drill-through
Type 3
Predictive Analytics
Core question: "What will happen?"

Predictive analytics uses historical data and statistical models to forecast future outcomes. It does not tell you what will definitely happen — it tells you what is likely to happen, with a probability. The accuracy depends on the quality of historical data and the model used.

REAL EXAMPLES
  • Based on historical patterns, Diwali season demand for electronics will be 35% higher than last year
  • Customer X has a 72% probability of churning in the next 30 days based on their activity drop
  • The model predicts 1,200 units of Product A will need to be restocked by Friday
Common tools: Python (scikit-learn), R, Excel regression, Power BI forecasting
Type 4
Prescriptive Analytics
Core question: "What should we do?"

Prescriptive analytics is the most advanced type — it not only predicts what will happen but recommends the best action to take. It combines prediction with optimisation. This is where machine learning and business rules work together.

REAL EXAMPLES
  • Send a 15% discount coupon to the 800 customers flagged as high-churn-risk — model estimates ₹12L retained revenue
  • Reroute 30% of tomorrow's Noida deliveries through the Sector 62 hub to reduce average delivery time by 40 minutes
  • Increase the bid on the "data analytics course Noida" keyword by ₹8 — conversion model shows positive ROI at this threshold
Common tools: Python (optimisation), ML models + business rules, simulation

Data Analytics in Indian Industries — Real Examples

E-Commerce (Flipkart, Meesho)

Demand forecasting for Diwali inventory. Customer segmentation to personalise recommendations. Delivery route optimisation to reduce last-mile cost.

Banking (HDFC, ICICI, SBI)

Credit risk scoring to decide loan approvals. Fraud detection in real-time transactions. Customer lifetime value prediction.

Healthcare (Apollo, Fortis)

Predicting ICU bed requirement by day of week. Identifying high-risk patients for follow-up. Supply planning for medicines and consumables.

Manufacturing (Noida/Greater Noida)

Quality defect detection from sensor data. Predictive maintenance on factory equipment. Vendor delivery performance tracking.

FMCG (HUL, Dabur, Marico)

Retail distribution efficiency analysis. Promotion effectiveness measurement. Seasonal demand planning.

Ed-Tech & Online Platforms

Course completion rate analysis. Student engagement prediction. Personalised learning path recommendations.

Tools Data Analysts Use

ToolWhat It DoesWhen to Learn ItCost
Microsoft ExcelSpreadsheet analysis, pivot tables, formulas, basic chartsFirst — foundation for everything elsePaid (often included in Office)
SQLQuery databases, filter/join/aggregate large datasetsSecond — most tested in interviewsFree (MySQL, SQLite, PostgreSQL)
Power BIInteractive dashboards and data visualisationThird — dominant BI tool in IndiaFree desktop; paid for sharing
Python (pandas)Data wrangling, analysis, automation, ML basicsFourth — adds significant career valueFree
TableauData visualisation, alternative to Power BIOptional — mainly MNCs and GCCsPaid (free Public version)
Google SheetsCloud spreadsheet, similar to ExcelAlongside Excel — useful for collaborationFree

How to Start Learning Data Analytics

1
Start with Excel

Excel is the entry point. Learn pivot tables, SUMIFS, VLOOKUP/XLOOKUP, and basic charts. You do not need to know everything — just enough to manipulate a dataset and answer a question. This takes 2–3 weeks of daily practice.

2
Learn SQL next

SQL is the most universally required skill for data analyst jobs in India. It lets you query databases — the primary source of business data. Learn SELECT, WHERE, JOIN, GROUP BY, and window functions. Most people are interview-ready in SQL within 4–6 weeks.

3
Pick a visualisation tool

Learn Power BI (recommended for most Indian roles) or Tableau. Build a dashboard on real data. The goal is a published dashboard link you can put in your resume.

4
Add Python

Python extends what you can do — larger datasets, automation, and eventually machine learning. Focus on pandas for data manipulation and Matplotlib/Seaborn for charts. Python for data analysis is approachable even if you have never coded before.

5
Build a portfolio project

Apply all the above to a real business question using an Indian dataset. Document the question, the data, and the insight. Put it on GitHub. This is what differentiates you in interviews.

Continue the Series
Ch 2: Types of Data →Ch 3: The DA Process →Full Learning Roadmap →

Frequently Asked Questions

What is data analytics in simple terms?

Data analytics is the process of examining raw data to find patterns, draw conclusions, and support better decisions. In simple terms: you collect data, clean it, analyse it, and present what you found so someone can make a smarter choice. A supermarket analysing which products sell more on weekends, a bank identifying customers likely to miss a loan payment, or a hospital tracking which ward has the longest wait times — all of these are data analytics. The scale and tools differ, but the core process is the same: data in, insight out.

What are the 4 types of data analytics?

The 4 types of data analytics are: (1) Descriptive analytics — what happened? (sales last month, website visitors this week). (2) Diagnostic analytics — why did it happen? (why did sales drop in July — was it pricing, competition, or seasonality?). (3) Predictive analytics — what will happen? (which customers are likely to churn next quarter). (4) Prescriptive analytics — what should we do about it? (if we offer a 10% discount to high-churn-risk customers, we can retain 35% of them). Most analytics work in India is currently at the descriptive and diagnostic level, with predictive growing fast.

What is the difference between data analytics and data science?

Data analytics focuses on examining existing data to answer specific business questions — what happened, why, and what to do next. It uses SQL, Excel, Power BI, and some Python. Data science is broader and more technical — it includes building machine learning models, working with unstructured data (text, images), and creating predictive systems from scratch. Data scientists typically use Python, R, and cloud platforms. In practice: a data analyst answers "why did revenue drop 12%?" A data scientist builds a model that predicts revenue 3 months ahead. Both are important, and many professionals move from analytics to data science as they grow.

Do I need to know coding to learn data analytics?

Not at first, but eventually yes — and it is more manageable than most people fear. You can start with Excel and Power BI, which require no coding and cover a large portion of what analysts do in practice. SQL is the next step — it reads almost like English and most people become confident in SQL within 4–6 weeks. Python is the third skill, and while it requires more learning, you only need a practical subset (reading a file, filtering rows, grouping data, plotting a chart) to be productive as an analyst. The good news: data analytics coding is much simpler than software engineering. You write short scripts to answer questions, not complex applications.

What is the salary of a data analyst in India?

A data analyst fresher in India earns ₹3.5–7 LPA depending on city, skills, and company type. At the mid-level (3–5 years), the range is ₹9–18 LPA. Senior analysts and analytics managers earn ₹18–40 LPA. Bangalore pays the highest, followed by Hyderabad, Mumbai, and Delhi NCR. Skills that increase pay: Python (adds ₹1–3 LPA), cloud platforms (adds ₹2–4 LPA), and domain expertise in BFSI or e-commerce (adds ₹1–3 LPA).

EVIKA ACADEMY · NOIDA SECTOR 51

Ready to go from basics to job-ready?

Live structured training — SQL, Python, Power BI, and portfolio guidance. Free demo class, no commitment.

Book Free Demo Class →
🎓 Free Demo Class — Online & Offline · Noida Sector 51