Unit 1 of 4 · MBA Sem 3

Unit 1: Data science and R fundamentals

Data Sciences Using R notes · PTU syllabus (MBA 962-18)

5 min read10 topics10 exam questions
On this page
  1. Unit summary
  2. Components of data science
  3. Roles in data science
  4. Big data and data pre-processing
  5. Supervised and unsupervised learning
  6. Business applications of data science
  7. Introduction to R
  8. Basic elements of R
  9. R data interfaces
  10. Charts and graphs in R
  11. Statistics in R
  12. Key terms
  13. Quick revision
  14. Important questions

Unit summary

Data science combines statistics, computing and business knowledge to extract value from data, and R is one of its most widely used tools. This unit covers the components and roles in data science, big data, data pre-processing, supervised and unsupervised learning, business applications, installing R and its basic elements, R data interfaces, charts and graphs, and computing statistics in R.

After this unit you can

  • Explain the components, roles and business applications of data science
  • Explain big data, pre-processing and supervised and unsupervised learning
  • Install R and use its basic elements and data interfaces
  • Create charts and compute descriptive statistics in R

PTU syllabus topics

  • Components and roles in data science
  • big data/data pre-processing/supervised and unsupervised learning concepts
  • business applications of data science
  • introduction to R software installation and basic elements
  • R data interfaces
  • charts
  • graphs and statistics
  • mean/median/SD/variance/correlation/covariance through R
1

Topic 1

Components of data science

Data science combines three areas: knowledge of the business problem, mathematics and statistics, and computing. A project follows a life cycle from understanding the problem to deploying a model.

ClassificationComponents of data science
Data science
  • Domain knowledge

    Understanding the business problem

  • Mathematics and statistics

    Probability, inference, modelling

  • Computer science

    Programming, databases, algorithms

  • Data engineering

    Collecting, storing and preparing data

  • Machine learning

    Models that learn from data

  • Communication

    Visualisation and storytelling

ProcessData science life cycle
  1. 1

    Business understanding

  2. 2

    Data acquisition

  3. 3

    Data preparation

  4. 4

    Exploratory analysis

  5. 5

    Modelling

  6. 6

    Evaluation

  7. 7

    Deployment and monitoring

Example

Reducing loan defaults: domain knowledge defines what counts as a default; statistics builds a logistic regression on past loans; programming in R cleans the data and runs the model; communication turns the result into a lending rule.

2

Topic 2

Roles in data science

A data team has several roles with different responsibilities. On small teams one person may cover more than one.

RoleMain responsibility
Data scientistBuilds models, experiments and insights
Data analystReports, dashboards, descriptive and diagnostic analysis
Data engineerBuilds data pipelines, warehouses and lakes
Machine learning engineerDeploys and scales models in production
Business analyst or translatorLinks business problems to analytics solutions
Data stewardData quality, governance and privacy

Example

Who does what: the data engineer builds the pipeline that brings sales data into a warehouse; the data analyst builds the monthly dashboard; the data scientist builds the demand forecast; the ML engineer puts the model into production.

3

Topic 3

Big data and data pre-processing

Pre-processing makes raw data ready for analysis: cleaning (missing values, errors, duplicates), integration, transformation (scaling, encoding categories), reduction (fewer variables or records) and discretisation.

  • Big data: data sets too large or complex for traditional tools, described by the 5 Vs — volume, velocity, variety, veracity and value.
  • Technologies: Hadoop (HDFS, MapReduce), Spark, NoSQL databases, cloud data platforms.
  • Pre-processing: cleaning (missing values, outliers, duplicates), integration, transformation (scaling, encoding categories as dummies), reduction (feature selection, PCA), splitting into training and test sets.

Example

Cleaning in R: a customer file has missing ages and income in different units. In R, df$age[is.na(df$age)] <- median(df$age, na.rm = TRUE) fills missing ages, and df$income_scaled <- scale(df$income) puts income on a common scale before clustering.

Exam tip

The 5 Vs of big data: volume, velocity, variety, veracity and value.

4

Topic 4

Supervised and unsupervised learning

Supervised learning uses labelled data (a known outcome) to predict — classification (categories) or regression (numbers). Unsupervised learning finds structure in unlabelled data — clustering and association.

Graphk-means: two clusters with centroids
Feature 2Feature 1O

The open circles are the centroids. Assign each point to the nearest centroid, recompute centroids, repeat until they stop moving

ComparisonTypes of machine learning
Supervised learning
Unsupervised learning

Data

Labelled — target variable known

Unlabelled

Goal

Predict or classify

Find structure or groups

Techniques

Regression, logistic regression, decision trees, SVM, random forests

Clustering (K-means, hierarchical, DBSCAN), PCA, association rules

Example

Predict loan default

Segment customers

  • Reinforcement learning: an agent learns by trial and reward — used in recommendation, robotics and dynamic pricing.

Example

One business, both methods: a bank predicts which customers will default using past loans labelled 'defaulted' or 'repaid' (supervised). It also groups customers into segments by spending behaviour without any labels (unsupervised).

Exam tip

If the outcome is known in the training data, it is supervised learning.

5

Topic 5

Business applications of data science

Data science is used across every function, from marketing and finance to operations and HR.

  • Marketing: segmentation, recommendation, churn prediction, marketing mix modelling.
  • Finance: credit scoring, fraud detection, algorithmic trading, risk modelling.
  • Operations: demand forecasting, inventory optimisation, predictive maintenance, route optimisation.
  • HR: attrition prediction, resume screening, workforce planning.
  • Healthcare and public sector: diagnosis support, disease surveillance, tax fraud analytics.

Example

HR analytics: a company builds a model on past employee data and finds that long commutes and no promotion in three years strongly predict resignation. HR uses this to plan transfers and career discussions.

Exam tip

Give at least one application each for marketing, finance, operations and HR.

6

Topic 6

Introduction to R

R is popular in analytics because it is free, has thousands of packages on CRAN (for example, dplyr for data manipulation and ggplot2 for charts), and produces high-quality graphics. RStudio is the most common working environment.

  • R is a free, open-source language and environment for statistical computing and graphics; RStudio (Posit) is the popular IDE with console, script editor, environment and plots panes.
  • Installation: install R from CRAN, then RStudio; add packages with install.packages("name") and load with library(name).
  • Popular packages: tidyverse (dplyr, ggplot2, readr, tidyr), caret and tidymodels (machine learning), randomForest, e1071 (SVM), cluster, rpart (decision trees).

Example

First steps in R: sales <- c(120, 135, 150, 160) creates a vector; mean(sales) returns 141.25; plot(sales, type = "l") draws a line chart of the four months.

Exam tip

Install a package once with install.packages("name"), then load it in each session with library(name).

7

Topic 7

Basic elements of R

R's main objects are vectors, matrices, arrays, lists, factors and data frames. A data frame — like a spreadsheet, with columns of different types — is the most used structure in analytics.

ClassificationR data structures
R objects
  • Vector

    c(10, 20, 30) — one data type

  • Matrix

    matrix(1:6, nrow = 2) — two dimensions, one type

  • List

    list(name = "A", marks = c(80, 90)) — mixed types

  • Data frame

    data.frame(name, age) — table with columns of different types

  • Factor

    factor(c("Low", "High")) — categorical data

  • Data types: numeric, integer, character, logical (TRUE or FALSE), complex.
  • Operators and assignment: x <- 5; arithmetic (+, −, the asterisk for multiplication, /, ^), relational (==, !=, >, <), logical (&, and the "or" operator).
  • Control structures and functions: if–else, for and while loops, user-defined functions with function().

Example

A data frame: df <- data.frame(name = c("Asha", "Ravi"), marks = c(78, 85)) creates a two-column table. df$marks gives the marks column and df[df$marks > 80, ] returns the rows with marks above 80.

Exam tip

Know the difference: a vector holds one data type; a list can hold mixed types.

8

Topic 8

R data interfaces

R reads and writes data in many formats. Most projects begin by importing a CSV or Excel file into a data frame.

TaskR command
Read CSVread.csv("sales.csv") or readr::read_csv()
Read Excelreadxl::read_excel("data.xlsx")
Write CSVwrite.csv(df, "out.csv")
Connect to a databaseDBI::dbConnect() with odbc or RMySQL
Read JSON or web datajsonlite::fromJSON(url)
Inspect datahead(df), str(df), summary(df), dim(df)

Example

Import, check, export: sales <- read.csv("sales.csv") loads the file. str(sales) shows its columns and types, and head(sales) shows the first six rows. write.csv(sales, "clean.csv", row.names = FALSE) saves the result.

Exam tip

Check your working directory with getwd() and set it with setwd() if R cannot find the file.

9

Topic 9

Charts and graphs in R

  • Base graphics: plot(x, y), hist(x), boxplot(y ~ group), barplot(table(x)), pie(x).
  • ggplot2: grammar of graphics — ggplot(df, aes(x = month, y = sales)) + geom_line(); layers for points, bars, smoothing, facets and themes.

Example

ggplot(sales, aes(x = region, y = revenue)) + geom_col() draws a bar chart of revenue by region in one line.

10

Topic 10

Statistics in R

Key formulasDescriptive statistics in R
  • Mean and median

    mean(x), median(x)

  • Spread

    sd(x), var(x), range(x), IQR(x), quantile(x)

  • Relationship

    cor(x, y), cov(x, y)

  • Summary

    summary(df) gives min, quartiles, mean and max

  • Handling missing values: mean(x, na.rm = TRUE); is.na(); na.omit().
  • Correlation matrix: cor(df[, c("price", "ads", "sales")]).

Example

Quick summary: summary(df$sales) gives the minimum, quartiles, median, mean and maximum. cor(df$ad_spend, df$sales) gives the correlation, and t.test(sales ~ region, data = df) tests whether average sales differ between two regions.

Exam tip

Use summary(), table() and hist() first to understand the data before modelling.

Key terms

Data science
Field extracting knowledge from data using statistics and computing
Big data
Data with high volume, velocity and variety
Supervised learning
Learning from labelled data
Data frame
R table with columns of different types
ggplot2
R package for layered graphics

Quick revision

  • Components and life cycle of data science; roles.
  • Big data 5 Vs; pre-processing steps.
  • Supervised vs unsupervised vs reinforcement learning; applications.
  • R and RStudio; packages; vectors, matrices, lists, data frames, factors.
  • Data import and export; base graphics and ggplot2; mean, median, sd, var, cor, cov.

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.Name the components of data science.
  2. Q2.What are the 5 Vs of big data?
  3. Q3.Distinguish supervised and unsupervised learning.
  4. Q4.What is a data frame in R?
  5. Q5.Write the R command to read a CSV file.
  6. Q6.Which R functions give variance and correlation?

Long-answer questions

  1. Q1.Explain the components, roles and life cycle of data science.
  2. Q2.Discuss big data, data pre-processing and types of machine learning.
  3. Q3.Explain the basic data structures and data interfaces of R.
  4. Q4.Explain how charts and descriptive statistics are produced in R.

Stuck on this unit?

Message SBS on WhatsApp for help with Data Sciences Using R, or to ask about studying MBA at Synetic.

Planning your MBA in Ludhiana? See the MBA at SBS →

WhatsApp us