MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY
COURSE FILE
Department : BUSINESS MANAGEMENT
Academic Year : 2023-24 Semester: III
Course Details
Name of the Course : MBA
Branch/Specialization : MBA
Class : III SEM Section: A
Name of the Subject : DATA ANALYTICS
Subject Code : R22MBA19
No. of Students : 80
Nature of the Subject : Regular (Common Specialization Paper)
Check List
Time Table Assignments/Important Questions
Students Attendance Register Course References
Syllabus Copy Hand Outs / Lecture Notes
Preface of the Course Digital Notes
Course Objectives Mid Exams Question Papers
Course Outcomes Mid Exam Marks Statement/Assessment
Course Schedule (Expected) Model Question Papers
Schedule of Instructions (Expected) Remedial Classes/ Makeup Tests
Dr.Gowsya Shaik
SUBJECT FACULTY
Dr G. NAVEEN KUMAR Dr. S. SRINIVASA RAO
HEAD OF PRINCIPAL, MRCET
DEPARTMENT
Cover Page
1. Result Analysis:
1.1 Pass Percentage :
1.2 Percentage above 60% of Marks :
2. Course Plan:
2.1 Coverage of syllabus in 60 classes
2.2 Giving assignment questions to students from each unit.
3. Method of Evaluation:
3.1 Continuous Assessment Examinations : Yes
3.2 Assignments / Seminars : Yes
3.3 Mini Projects : No
3.4 Subjective and Objective as per University Norms : Yes
3.5 Others: (Please Specify)
4. List of Additional Topics / Topics-Beyond-Syllabus or any Innovation
TEACHING LEARNING PROCESS
1. Methodologies /Teaching Aids:
a. Blackboard and white board
b. Chalk, Duster and whiteboard marker (black, blue, red, purple, green etc.)
c. Power Point presentation
d. In the first five minutes of the class, asking the questions of the previous class
to assess how thorough the students with the subject
e. Interactive sessions.
f. Giving some topics for seminar
2. Guidelines for the Students to Study the Subject:
a. Understanding of the subject by using distinctive illustrations.
b. In-depth analysis is required by studying various journals and cases.
c. Evaluation of every sub topic in each unit.
d. Neat presentation through points of every unit helps score highest marks.
1 AY 2022-2023
SYLLABUS
MBA II YEAR II SEM
R22MBA19
DATA ANALYTICS
UNIT – I: INTRODUCTION TO DATA ANALYTICS
Introduction: Meaning of Data Analytics- Need of Data Analytics- Business Analytics vs.
Data Analytics - Categorization of Data Analytical Models. Data Scientist vs. Data Engineer
vs. Data Analyst- Role of Data Analyst- Data Analytics in Practice.
UNIT – II: DEALING WITH DIGITAL DATA AND DATA SCIENCE
Data: Introduction to Digital Data- Types of Digital Data - Data Collection- Data
Preprocessing- Data Preprocessing Elements: Data Quality, Data Cleaning, and Data
Integration - Data Reduction-Data Transformation-Data Discretization.
Data Science Project Life Cycle: Business Requirement- Data Acquisition- Data
Preparation- Hypothesis and Modeling- Evaluation and Interpretation- Deployment-
Operations- Optimization- Applications for Data Science.
UNIT – III: BIG DATA MANAGEMENT AND DATA VISUALIZATION
Introduction to Big Data: Evolution of Big Data concept – Features of Big Data- Big Data
Challenges-Big Data Analytics.
Introduction to Data Visualization: Data Visualization concept- Importance of data
visualization –- Structure of Visualization - Tools for Data visualization- Data Queries-Data
Dashboards- Principles of effective Data Dashboards-Applications of Data Dashboards.
UNIT – IV: DESCRIPTIVE STATISTICAL MEASURES
Overview of using Data: Population and Samples, Measures of location, Measures of
Dispersion, Measures of Variability, Measures of Association.
Probability Distribution: Probability Distribution and Data Modeling, Discrete Probability
Distribution, Continuous Probability Distribution, Random Sampling from Probability
Distribution, Data Modeling and Distribution fitting.
UNIT – V: PREDICTIVE ANALYTICS
Introduction to predictive Analytics: Karl Pearson Correlation Technique, Multiple
Correlation, Spearman’s Rank Correlation,
Regression: Simple and Multiple Regression, Regression by the Method of Least Squares,
Building Good Regression Models. Regression with Categorical Independent Variables,
Linear Discriminate Analysis, One-Way and Two-Way ANOVA.
2 AY 2022-2023
References:
Basics of Data Analytics Richa Mishra, Dr. Nirvikar Katiyar, Apoorv Mishra.
Data Analytics: Principles, Tools, and Practices, Dr. Gaurav Arora, Chitra Lele,
Dr. Munish Jindal.
Essentials of Business Analytics Cam, Cocharan, Ohlmann, Anderson, Sweeney,
Williams, Cengage Learning.
Data Mining Concepts and Techniques, Jiawei Han, Micheline Kamber, Jian Pei.
Big Data Analytics, Seema Acharya, Subhashini Chellappan.
Statistical Methods by SP Gupta .
PREFACE
Course : MBA II Year II SEM
Academic Year : 2023-24
Name of the Course : DATA ANALYTICS (R22MBAF4)
Prescribed Textbooks :
Basics of Data Analytics Richa Mishra, Dr. Nirvikar Katiyar, Apoorv Mishra.
Data Analytics: Principles, Tools, and Practices, Dr. Gaurav Arora, Chitra Lele,
Dr. Munish Jindal.
Nature of the Subject: Common Paper
UNIT – I: INTRODUCTION TO DATA ANALYTICS
Overview: Data Analytics encompasses understanding the fundamentals and importance of
data analytics, differentiating between business analytics and data analytics, and categorizing
different analytical models such as descriptive, diagnostic, predictive, and prescriptive
analytics. It covers the roles and responsibilities of key professionals in the field, including
data scientists, data engineers, and data analysts, with a focus on the role of data analysts in
collecting, cleaning, analyzing, visualizing, and reporting data. Practical applications of data
analytics in various industries like marketing, finance, healthcare, retail, and sports are also
explored to provide real-world context and insights.
UNIT – II: DEALING WITH DIGITAL DATA AND DATA SCIENCE
Overview: Introduces digital data, its various types, and the methods for data collection. It
delves into data preprocessing, emphasizing key elements such as data quality, cleaning, and
integration. Topics like data reduction, transformation, and discretization are also covered to
streamline data for analysis. The data science project life cycle is explored, beginning with
understanding business requirements, followed by data acquisition and preparation. It
includes hypothesis formulation, modeling, and the subsequent steps of evaluation,
interpretation, deployment, and operations. The cycle concludes with optimization and real-
3 AY 2022-2023
world applications of data science, providing a comprehensive framework for managing and
utilizing data effectively.
UNIT – III: BIG DATA MANAGEMENT AND DATA VISUALIZATION
Overview: Introduction to digital data, detailing its various types and methods of data
collection. It covers essential aspects of data preprocessing, including data quality, cleaning,
and integration, along with techniques for data reduction, transformation, and discretization
to prepare data for analysis. The data science project life cycle is thoroughly examined,
starting with business requirements, followed by data acquisition, preparation, hypothesis
formulation, and modeling. It continues through evaluation, interpretation, deployment, and
operational stages, and concludes with optimization and practical applications, offering a
comprehensive framework for effective data management and utilization.
UNIT – IV: DESCRIPTIVE STATISTICAL MEASURES
Overview: Introduction to digital data, detailing its various types and methods of data
collection. It covers essential aspects of data preprocessing, including data quality, cleaning,
and integration, along with techniques for data reduction, transformation, and discretization
to prepare data for analysis. The data science project life cycle is thoroughly examined,
starting with business requirements, followed by data acquisition, preparation, hypothesis
formulation, and modeling. It continues through evaluation, interpretation, deployment, and
operational stages, and concludes with optimization and practical applications, offering a
comprehensive framework for effective data management and utilization.
UNIT – V: PREDICTIVE ANALYTICS
Overview: It covers foundational statistical concepts and probability distributions crucial for
data analysis. It begins with an exploration of population and samples, detailing measures of
location, dispersion, variability, and association. The focus then shifts to probability
distribution, including its role in data modeling. It distinguishes between discrete and
continuous probability distributions, addresses random sampling from these distributions, and
discusses techniques for data modeling and distribution fitting. Together, these topics provide
a comprehensive framework for understanding and applying statistical methods to analyze
and interpret data effectively.
Dr.Gowsya Shaik
SUBJECT FACULTY
4 AY 2022-2023
OBJECTIVES OF THE SUBJECT
On completion of this Subject / Course the Student shall be able to:
Aim of the Subject Learning Outcome
To explain the concepts of To gain a comprehensive understanding of
data analytics. data terminologies and concepts.
To provide an understanding To collect, clean, and preprocess data for
on digital data. analysis.
To impart the knowledge on To create compelling visual representations
the data visualization and of data to aid in decision-making processes.
big data analytics. To implement data analytics projects,
demonstrating project management skills,
team work and problem-solving abilities.
To develop proficiency in statistical analysis
and apply various techniques to extract
meaningful insights from data.
Uni
Objectives Outcomes
t
The objective is to facilitate the fundamental
concepts and techniques of Data Students will be proficient in using the
I Analytics as applied to business decision Data Analytics Methodologies to make
making. data driven business decisions.
To equip students with knowledge Students will be efficient in
and skills necessary to understand collecting cleaning and
II manage and leverage data and data analyzing the data to extract
science in business context. actionable insights that drive
improved business strategies.
To provide students with comprehensive Students will be proficient in
understanding of big data concept and datapresenting complex big data sets by
visualization techniques to enhance their using different data visualization tools
III
and techniques in compelling manner
ability to analyze and present large set of
that will help them in gaining insights
data effectively.
in a business context.
Students will be able to analyze and
The enable the students to understand and interpret various descriptive statistical
IV apply descriptive statistical measures to measures to effectively analyze and
summarize and interpret the data. communicate key characteristics of
data sets.
V To equip the students with knowledge and Students will be able to adapt different
skills required to apply predictive predictive models to improve business
5 AY 2022-2023
analytical techniques in solving business
problems. decisions and strategies.
COURSE SCHEDULE
(Expected)
Expected date of completion of the whole Subject / Course and remarks, if any:
Unit No. of
Topics Dates
s Classes
Meaning of Data Analytics- Need of Data Analytics- Business
Analytics vs. Data Analytics - Categorization of Data Analytical
16.10.23
I Models. Data Scientist vs. Data Engineer vs. Data Analyst- Role 6 to
of Data Analyst- Data Analytics in Practice. 21.10.23
Data: Introduction to Digital Data- Types of Digital Data - Data
Collection- Data Preprocessing- Data Preprocessing Elements:
Data Quality, Data Cleaning, and Data Integration - Data
Reduction-Data Transformation-Data Discretization.
30.10.23
II Data Science Project Life Cycle: Business Requirement- Data 17 to
Acquisition- Data Preparation- Hypothesis and Modeling- 5.11.23
Evaluation and Interpretation- Deployment- Operations-
Optimization- Applications for Data Science.
Introduction to Big Data: Evolution of Big Data concept –
Features of Big Data- Big Data Challenges-Big Data Analytics.
6.11.23
Introduction to Data Visualization: Data Visualization to
concept- Importance of data visualization –- Structure of 17.12.23
III 15
Visualization - Tools for Data visualization- Data Queries-Data
21.12.23
Dashboards- Principles of effective Data Dashboards- to
Applications of Data Dashboards. 25.12.23
Overview of using Data: Population and Samples, Measures of
location, Measures of Dispersion, Measures of Variability,
Measures of Association.
26.12.23
IV Probability Distribution: Probability Distribution and Data 17 to
Modelling, Discrete Probability Distribution, Continuous 10.1.24
Probability Distribution, Random Sampling from Probability
Distribution, Data Modelling and Distribution fitting.
6 AY 2022-2023
Introduction to predictive Analytics: Karl Pearson Correlation
Technique, Multiple Correlation, Spearman’s Rank Correlation.
Regression: Simple and Multiple Regression, Regression by the 11.1.24
V 10 To
Method of Least Squares, Building Good Regression Models. 15.02.24
Regression with Categorical Independent Variables, Linear
Discriminate Analysis, One-Way and Two-Way ANOVA.
Total no. of Classes 65
SCHEDULE OF INSTRUCTIONS
(Expected)
Internal Examinations Schedule: Course Commencing from 08.01.2019
Exam MID I MID II
From To From To
Dates
18.12.2023 21.12.2023 16.02.2024 02.02.2024
S. No. of
No Topics / Sub Topics Periods Date
. Expected
UNIT – I: INTRODUCTION TO DATA ANALYTICS
Objective: The objective is to facilitate the Outcome: Students will be proficient in
fundamental concepts and techniques of using the Data Analytics Methodologies to
Data Analytics as applied to business make data driven business decisions.
decision making.
1 Meaning of Data Analytics- 1
2 Need of Data Analytics- 1
3 Business Analytics vs. Data Analytics - 1
Categorization of Data Analytical
4 1
Models.
Data Scientist vs. Data Engineer vs. Data 16.10.23 to 21.10.23
5 Analyst- 1
Role of Data Analyst- Data Analytics in
6 1
Practice
Total Classes 6
UNIT – II: DEALING WITH DIGITAL DATA AND DATA SCIENCE
Objective: To equip students with Outcome: Students will be efficient in
knowledge and skills necessary to collecting cleaning and analyzing the data
understand manage and leverage data to extract actionable insights that drive
and data science in business context. improved business strategies.
1 Data: Introduction to Digital Data- 1 30.10.23 to
7 AY 2022-2023
Types of Digital Data - Data Collection-.
Data Preprocessing- Data Preprocessing
2 Elements: Data Quality, Data Cleaning, 1
and
Data Integration - Data Reduction-Data
3 Transformation-Data Discretization 1
Data Science Project Life Cycle: 5.11.23
4 Business Requirement- 5
Data Acquisition- Data Preparation-
5 1
Hypothesis and Modeling
Evaluation and Interpretation-
6 5
Deployment- Operations- Optimization-
Applications for Data Science.
7 3
Total Classes 17
UNIT – III: BIG DATA MANAGEMENT AND DATA VISUALIZATION
Objective: To provide students with Outcome: Students will be proficient in
comprehensive understanding of big data presenting complex big data sets by using
concept and data visualization techniques to different data visualization tools and
techniques in compelling manner that will
enhance their ability to analyze and present
help them in gaining insights in a business
large set of data effectively. context.
Introduction to Big Data: Evolution of
1 Big Data concept . 4
Features of Big Data- Big Data
2 Challenges-Big Data Analytics. 3
Introduction to Data Visualization:
Data Visualization concept- Importance 6.11.23 to
3 of data visualization –- Structure of 1 17.12.23
Visualization - 21.12.23 to 25.12.23
Tools for Data visualization- Data
Queries-Data Dashboards- Principles of
4 effective Data Dashboards-Applications 7
of Data Dashboards.
Total Classes 15
UNIT – IV: DESCRIPTIVE STATISTICAL MEASURES
Objective: The enable the students to Outcome: Students will be able to analyze
understand and apply descriptive statistical and interpret various descriptive statistical
measures to summarize and interpret the data. measures to effectively analyze and
communicate key characteristics of data
sets.
8 AY 2022-2023
Overview of using Data: Population and
1 Samples. 1
Measures of location, Measures of
2 Dispersion, Measures of Variability. 2
3 , Measures of Association. 1
Probability Distribution: Probability 26.12.23
4 Distribution and Data Modelling. 2 to
10.1.24
Discrete Probability Distribution,
5 Continuous Probability Distribution. 1
6 Random Sampling from 6
7 Probability Distribution 1
8 Data Modelling and. 2
9 Distribution fitting 1
Total Classes 17
UNIT – V: PREDICTIVE ANALYTICS
Objective: To equip the students with Outcome: Students will be able to adapt
knowledge and skills required to apply different predictive models to improve
predictive analytical techniques in solving business decisions and strategies.
business problems.
Introduction to predictive Analytics:
1 Karl Pearson . 1
Correlation Technique, Multiple
2 Correlation, 3
3 Spearman’s Rank Correlation. 1
Regression: Simple and Multiple
11.1.24
4 Regression, Regression by the Method of 2 To
Least Squares, 15.02.24
Building Good Regression Models.
5 Regression with Categorical Independent 1
Variables
6 Linear Discriminate Analysis. 1
7 One-Way and Two-Way ANOVA. 3
Total Classes 12
REFERENCES:
Basics of Data Analytics Richa Mishra, Dr. Nirvikar Katiyar, Apoorv Mishra.
Data Analytics: Principles, Tools, and Practices, Dr. Gaurav Arora, Chitra Lele, Dr.
Munish Jindal.
9 AY 2022-2023
Essentials of Business Analytics Cam, Cocharan, Ohlmann, Anderson, Sweeney,
Williams, Cengage Learning.
Data Mining Concepts and Techniques, Jiawei Han, Micheline Kamber, Jian Pei.
Big Data Analytics, Seema Acharya, Subhashini Chellappan.
Statistical Methods by SP Gupta.
10 AY 2022-2023
