BMBA152

Basics of Data Management with “R”

L-T-P1-0-3 Credits3 Session2024-25 TypeTheory
Appears in 1 semester

MBA Business Analytics · Sem 1 (Core)

Syllabus

5 units · 40 lecture hours
Unit1

Unit 1: Introduction to R and Data Handling

8 hrs

Learn the basics of R Syntax: Introduction to RStudio, R data types (vectors, lists, matrices, data frames, and factors), basic R commands, writing R scripts, and understanding the workspace. Loading and exploring datasets, sub-setting and filtering data, renaming and reordering columns, and creating new variables using the dplyr package.

Unit2

Unit 2: Data Preparation in R

6 hrs

Learn how to prepare data for analysis in R using dplyr and tidyr: Data cleaning techniques, handling missing values, data transformation, reshaping data using pivoting (long to wide and vice versa), combining and splitting datasets, and data manipulation using the tidyr package (e.g., gather, spread, separate, unite).

Unit3

Unit 3: Data Visualization in R

8 hrs

Learn the basics of how to create visualizations using the popular R package ggplot2: creating different types of plots (scatter plots, line plots, bar charts, histograms, and boxplots), customizing plots (titles, labels, colors, themes), adding layers (geoms), faceting, and saving and exporting plots. Explore advanced visualization techniques like creating multi-panel plots, and handling overplotting using transparency and jittering.

Unit4

Unit 4: Descriptive Statistics in R

10 hrs

Introduction to summarizing data, using functions like summarize(), group_by(), and mutate(). Understanding central tendency, calculating mean, median, mode, and interpreting results in the context of datasets. Understanding and calculating variance, standard deviation, and their importance in data analysis. Understanding quartiles, quantiles, and how they describe data spread, using R functions to compute these statistics, and interpreting boxplots.

Unit5

Unit 5: Advanced Data Analysis and Hypothesis Testing in R

8 hrs

Introduction to joins in R, different types of joins (inner, left, right, full), merging datasets using dplyr functions (inner_join, left_join, etc.), and working with multiple data sources. Introduction to hypothesis testing, types of t-tests (one-sample, independent two-sample, paired sample), assumptions of t-tests, conducting t-tests in R, interpreting results, and understanding p-values and confidence intervals. Explore the concept of effect size and its calculation.

Course Objectives5 points
  • Develop an understanding of the basic syntax and operations in R programming.
  • Equip students with the ability to organize, clean, and modify data using R’s data frames and dplyr package.
  • Teach students how to create various data visualizations using the ggplot2 package in R.
  • Provide knowledge on applying descriptive statistics in R to summarize and describe data distributions.
  • Enable students to perform advanced data analysis and hypothesis testing using R.
Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Students will be able to write and execute basic R scripts to manipulate data and perform simple calculations.K2 (Understand)
  2. CO2Students will be able to effectively clean, organize, and transform datasets using data frames and dplyr in R.K3 (Apply)
  3. CO3Students will be able to create and customize a variety of data visualizations, such as scatter plots, bar charts, and histograms using ggplot2.K5 (Create)
  4. CO4Students will be able to calculate and interpret key descriptive statistics (mean, median, mode, variance, standard deviation, quartiles) in R.K4 (Analyze)
  5. CO5Students will be able to conduct hypothesis tests (e.g., t-tests) using R and interpret the results to make informed decisions based on data.K6 (Evaluate)

Suggested Readings

  1. “The R Book” Michael J. Crawley, Wiley
  2. “R in Action” -Robert L. Kabacoff, Dream Tech Press
  3. “R for Data Science” – Hadley Wickham and Garrett Gorlemund, O’Reilly
  4. “A First Course in Statistical Programming with R” - by W. John Braun Duncan J. Murdoch, Cambridge University Press
  5. “Exploratory Data Analysis Using R” - by Ronald K. Pearson, CRC Press
  6. “Beginning Data Science in R: Data Analysis, Visualization, and Modelling for the Data Scientist” - by Thomas Mailund, Apress

Official AKTU syllabus

This subject is on page 18, 19 of the original AKTU PDF.

Official AKTU syllabus PDF ↗