Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

1.2 Analytics Fundamentals

Lesson 2 of 32 in the free Data Visualisation and Analytics notes on Siksha Sarovar, written by Rohit Jangra.

Analytics: Basic Nomenclature

1. What is Analytics?

Analytics is the systematic, computational process of collecting, cleaning, analyzing, and interpreting data to discover useful patterns, trends, and insights that help in decision-making. It transforms raw data into actionable intelligence using statistical methods, algorithms, and domain knowledge.

Study Deep: The DIKW Pyramid Logic

The DIKW Pyramid (Data, Information, Knowledge, Wisdom) represents the structural hierarchy of how we process raw facts into strategic decisions.

  1. Data: The raw, atomic facts (e.g., "102").
  2. Information: Data with context (e.g., "102 is the temperature in Fahrenheit").
  3. Knowledge: Information with experience (e.g., "102°F means the patient has a high fever").
  4. Wisdom: Knowledge with judgment (e.g., "Administer paracetamol and monitor the patient").

2. Data vs. Information vs. Knowledge

Understanding this hierarchy is fundamental:

ConceptDefinitionExampleCharacteristics
DataRaw, unprocessed facts and figures without context45, "Red", 12-07-2025Objective, unorganized, meaningless alone
InformationData that has been processed, organized, and given context"The red car was sold on 12-07-2025 for $45,000"Contextual, organized, answers Who/What/When
KnowledgeInformation combined with experience and judgment"Red cars sell 20% faster in summer; stock more for Q2"Actionable, experience-driven, answers How/Why
WisdomApplying knowledge ethically and strategically"We should focus marketing on red cars in spring to maximize summer sales"Strategic, forward-looking, answers "What's best?"

This hierarchy is known as the DIKW Pyramid (Data → Information → Knowledge → Wisdom).

3. Types of Data

Data can be classified along multiple dimensions. The two foundational categories are:

FeatureStructured DataUnstructured DataSemi-Structured Data
FormatHighly organized, fixed schemaNo predefined formatPartially organized (tags/markers)
StorageRelational Databases (SQL), SpreadsheetsData Lakes, NoSQL, File SystemsJSON, XML, Email (header + body)
ExamplesStudent records, bank transactions, inventoryEmails, social media posts, videos, imagesJSON API responses, HTML pages, log files
Ease of AnalysisEasy — direct queries with SQLDifficult — requires NLP, Computer VisionModerate — requires parsing
% of All Data~20%~80%Varies

Data can also be classified by measurement scale:

  • Nominal: Categories without order (e.g., Color: Red, Blue, Green).
  • Ordinal: Categories with a meaningful order but unequal intervals (e.g., Rating: Low, Medium, High).
  • Interval: Numeric with equal intervals but no true zero (e.g., Temperature in °C: 0°C ≠ "no heat").
  • Ratio: Numeric with equal intervals AND a true zero (e.g., Weight: 0 kg = no weight).

4. The Four Types of Analytics

Analytics is categorized into four types, progressing in both complexity and business value:

TypeCore QuestionTechniquesExampleValue Level
DescriptiveWhat happened?Averages, percentages, dashboards, charts"Sales dropped by 10% last month"Low (Hindsight)
DiagnosticWhy did it happen?Drill-down, data discovery, correlations, root cause analysis"Sales dropped because a competitor launched a cheaper product"Medium (Insight)
PredictiveWhat is likely to happen?Regression, forecasting, ML models, time-series analysis"Sales are likely to drop another 5% next month"High (Foresight)
PrescriptiveWhat should we do?Optimization, simulation, decision trees, A/B testing"Lower prices by 15% to regain market share"Very High (Action)
Analytics Maturity Model: Most organizations start at Descriptive and progressively adopt more advanced types. Only ~3% of enterprises fully leverage Prescriptive Analytics.

5. Key Terms Glossary

TermDefinitionExample
DatasetA collection of related data organized in rows and columnsA table of student marks
Variable (Feature)A characteristic that can vary across observationsAge, Height, Income
Observation (Record)A single row in a dataset representing one entityOne student's complete data
InsightA valuable, actionable conclusion drawn from analysis"Customers buy more on weekends"
KPI (Key Performance Indicator)A measurable value that shows progress toward a goalMonthly Revenue, Customer Churn Rate
MetricA quantifiable measure used to track performanceAverage Order Value, Click-Through Rate
DimensionA categorical attribute used to slice dataRegion, Product Category, Time Period