Unit 1 of 2 · BCA Sem 3

Unit 1: Introduction to data analytics

Basics of Data Analytics using Spreadsheet notes · PTU syllabus (UGDSE101)

3 min read4 topics8 exam questions
On this page
  1. Unit summary
  2. Understanding data and its types
  3. What is data analytics?
  4. Types of data analytics
  5. Importance and applications
  6. Key terms
  7. Quick revision
  8. Important questions

Unit summary

Data is now one of the most valuable resources of any organisation. Data analytics is the process of examining data to find patterns, answer questions and support decisions. This unit introduces data and its types, what data analytics is, its four types, and why it matters across industries.

After this unit you can

  • Define data and classify it by type
  • Explain what data analytics is and its process
  • Describe descriptive, diagnostic, predictive and prescriptive analytics
  • Give applications of data analytics in different fields

PTU syllabus topics

  • Understanding data and its types
  • what data analytics is
  • types
  • importance and applications of data analytics
1

Topic 1

Understanding data and its types

Data is a collection of facts, numbers or observations. It becomes information when processed.

ClassificationTypes of data
Data
  • Quantitative (numerical)

    Discrete (count of students) or continuous (height, temperature)

  • Qualitative (categorical)

    Nominal (city, gender) or ordinal (rating: poor, good, excellent)

  • Structured

    Rows and columns: spreadsheets, databases

  • Semi-structured

    JSON, XML, emails

  • Unstructured

    Images, videos, social media posts

Exam tip

Know the difference between nominal (no order) and ordinal (order matters) data — it decides which statistics can be used.

Example

Types in a student record: name and city are qualitative (nominal). Grade A, B, C is ordinal. Number of backlogs is quantitative discrete. Height and percentage are quantitative continuous. A table of records is structured data; an essay or photo is unstructured.

2

Topic 2

What is data analytics?

Data analytics is the process of collecting, cleaning, transforming and analysing data to discover useful information and support decision-making.

ProcessThe data analytics process
  1. 1

    Define the question

    What decision must be made?

  2. 2

    Collect data

  3. 3

    Clean and prepare

    Fix errors, missing values

  4. 4

    Analyse

    Statistics, charts, models

  5. 5

    Interpret and visualise

  6. 6

    Act and communicate

    Report and decide

Example

Four types on one shop's data: total sales last month were ₹8 lakh (descriptive). Sales fell because one product was out of stock (diagnostic). Sales are expected to reach ₹9 lakh next month (predictive). Reorder that product when stock falls below 50 units (prescriptive).

3

Topic 3

Types of data analytics

HierarchyFour types of analytics
  1. Prescriptive

    What should we do? Recommends actions

  2. Predictive

    What will happen? Forecasts

  3. Diagnostic

    Why did it happen? Finds causes

  4. Descriptive

    What happened? Summarises past data

Example

A college: descriptive — 20% of students failed Maths; diagnostic — most had low attendance; predictive — students below 60% attendance are likely to fail; prescriptive — start extra classes for them.

4

Topic 4

Importance and applications

FieldUse of data analytics
Business and retailSales trends, inventory, customer segments
Banking and financeFraud detection, credit scoring
HealthcarePatient records, disease prediction
EducationStudent performance and dropout prediction
SportsPlayer performance and strategy
GovernmentCensus analysis and policy planning

Benefits: better decisions, cost savings, understanding customers, spotting problems early and gaining a competitive edge.

Example

Uses across fields: a retailer finds its best-selling products; a hospital spots which wards have the longest waiting time; a college finds which subjects have the most failures; a cricket team studies a batsman's weak zones.

Key terms

Data analytics
Examining data to support decisions
Structured data
Data organised in rows and columns
Descriptive analytics
Summarising what happened
Predictive analytics
Forecasting what will happen
Prescriptive analytics
Recommending what to do

Quick revision

  • Quantitative (discrete, continuous) vs qualitative (nominal, ordinal).
  • Process: question → collect → clean → analyse → interpret → act.
  • Four types: descriptive, diagnostic, predictive, prescriptive.

Important exam questions

Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).

Short-answer questions

  1. Q1.Differentiate between qualitative and quantitative data.
  2. Q2.Define data analytics.
  3. Q3.Differentiate between descriptive and predictive analytics.
  4. Q4.Give two applications of data analytics in banking.
  5. Q5.What is unstructured data?

Long-answer questions

  1. Q1.Explain the types of data with examples.
  2. Q2.Explain the four types of data analytics with an example from any industry.
  3. Q3.Describe the data analytics process and its importance for organisations.

Stuck on this unit?

Message SBS on WhatsApp for help with Basics of Data Analytics using Spreadsheet, or to ask about studying BCA at Synetic.

WhatsApp us