Scribd
Upload
241 views2 pages

Introduction To Business Analytics

This document provides an introduction to the Introduction to Business Analytics course. The course objectives are to provide students with an understanding of basic analytics concepts, tools, and techniques. By the end of the course, students should be able to explain the importance of analytics and its applications, identify business processes that generate and need data, and use tools like MS Excel and R for data handling and basic statistical analysis. The course will cover topics such as current analytics trends, applications in different industries and functions, analytical tools, hands-on use of tools like R and MS Excel, and basic statistical inference.

Uploaded by

SUDIPTA SHIB
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
241 views2 pages

Introduction To Business Analytics

This document provides an introduction to the Introduction to Business Analytics course. The course objectives are to provide students with an understanding of basic analytics concepts, tools, and techniques. By the end of the course, students should be able to explain the importance of analytics and its applications, identify business processes that generate and need data, and use tools like MS Excel and R for data handling and basic statistical analysis. The course will cover topics such as current analytics trends, applications in different industries and functions, analytical tools, hands-on use of tools like R and MS Excel, and basic statistical inference.

Uploaded by

SUDIPTA SHIB
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Introduction to Business Analytics

Course Code : SLBA 502 Sessions : 33


Credit : 3 Semester : II

Course Objective:
To provide the students understanding of concepts, tools and techniques of Basic Analytics
Learning Outcomes:
At the end of the course the student should be able to
1. Explain the importance of analytics and its applications.
2. Identify business processes that generate and need data. Role of data in informed decision
making.
3. Use analytical tools like MS Excel, R to handle data and explore basic statistical functionalities.

TEXT BOOK AUTHOR/PUBLICATION


Fundamentals of Business Analytics R.Prasad & Seema Acharya, Wiley Publication
REFERENCE BOOKS AUTHOR/PUBLICATION
Business Analytics: Methods, Models and James R. Evans - Prentice Hall
Decisions, 1st Edition
Business Analytics for Managers: Taking by Gert H. N. Laursen (Author), JesperThorlund
Business Intelligence Beyond Reporting (Author) - (Wiley &Sas Business Series)
Fundamentals of Business Analytics R.Prasad and Seema Acharya

Detailed Syllabus Financial, Operation/Supply Chain/Logistics,


Marketing, HR, Banking, Retailing, etc.
Introduction to analytics: What is analytics
and why it is used. Data explosion and role of Analytical tools: R, SAS /SPSS and any other
analytics in industry today. proprietary/open source tools.

Role of analysts and job profile Tools hands-on: Hands-on class on any tools the
faculty plans to introduce as a part of the
Current trends in analytics: Data types and analytics course. Preferred Tool – R. The
sources for analytics. Technologies and domains introduction to R platform and any user
involved in analytics. Current trends, industry interface (for example R Studio) can be handled
wise. by focused exercises that cover the basics of
statistical analysis. This includes: reading data,
Application of analytics in industry, summary and structure of the data, data types,
functional area-wise: Application and data frames, sub-setting, graphs and plots,
introductory cases on importance of analytics in exploratory data analysis, basic regression.

39
MS Excel: Inference: The students are introduction to
inference and summarization, once basic
Application layout and user interface, Cell
statistical functions are executed on R. Project
referencing, formulas and functions, Graphs and
work with emphasis on inference can be
Charts. Data Handling: Sorting, Filtering and
supervised to execute this section.
accessing data from text files, databases and
World Wide Web. Data Validation, Data
Suggested Schedule of Sessions
consolidation and Conditional Formatting.
Functions: Overview of lookup, Mathematical No. of
Topic
functions. Financial functions like NPV, IRR, Sessions
PMT, PRICEDISC, PRICEMAT, EFFECT, FV,
and YIELD DISC (advance finance function) Introduction to analytics 2

Analysis Tools: Pivot table and Pivot chart, Role of analysts and job profile 2
Dynamic Pivot tables, Goal Seek, Solver.
Current trends in analytics 2
Advanced features: Macros, Linking multiple
sheets, use a slicer to filter data, creating dash Application of analytics in industry,
board through excel 4
functional area-wise
Optimization (using solver excel add in): Use of
Excel to solve business problem: Eg marketing Analytical tools 3
mix, capital budgeting, portfolio optimization
MS Excel (Advanced) 10
Data visualization and Interpretation for big
data: Different types of data, data Tool hands-on (R/SAS, etc.) 8
summarization& visualization methods, tables,
graphs, charts, histogram, frequency Inference 2
distribution, relative frequency, measures of
central tendency,, dispersion, box plot, Total 33
chebychev’s inequality(SPSS/Excel)

40

You might also like