BUSINESS INTELLIGENCE (BA)

Course Objectives:

The Objective of this course to introduce the Business Intelligence methods that supports the decision

process in business operations and understand the business analytics strategy with the using of Data

Mining and Data Warehousing in decision making.

Course Outcomes: After completion of this course, students will be able to:

CO-1: Explain the fundamentals of business intelligence. (Understand)

CO-2: Identify the concepts of business analytics and business intelligence methods for decision

Process (Understand)

CO-3: Compare and contrast the strengths and limitations of various data mining and data

warehousing models (Analyze)

CO-4: Describe different methodologies used in data mining and data ware housing. (Analyze)

CO-5: Apply business intelligence methods to various situations. (Apply)

UNIT- I: INTRODUCTION

Business Intelligence: definition, concept and need for Business Intelligence, Case studies BI Basics:

Data, information and knowledge, Role of Mathematical models

UNIT –II: ANALYTICS STRATEGY

Business Analytics at the strategic level: Strategy and BA, Link between strategy and Business

Analytics, BA supporting strategy at functional level, dialogue between strategy and BA functions,

information as strategic resource.

UNIT- III: DATA MINING

Business Analytics at Analytical level: Statistical data mining, descriptive Statistical methods, lists,

reports, automated reports, hypothesis driven methods, data mining with target variables, cluster
analysis, Discriminate analysis, logistic regression, principal component analysis.

UNIT- IV: DATA WAREHOUSING

Business Analytics at Data Warehouse Level, designing physical database, Deploying and supporting

DW/BI system

UNIT- V: BUSINESS INTELLIGENCE

Business Intelligence Architectures: Cycle of Business Intelligence Analysis, Development of

Business Intelligence System, spread sheets, concept of dashboard, CLAP, SQA, decision

Engineering. BI Tools: Concept of dashboard. BI Applications in different domains- CRM, HR,

Production

SUGGESTED BOOKS:

1. Turban, Sharda, Decision Support and Business Intelligence Systems, Delen, Pearson, 9th Edition,

2014

2. Olivia Parr Rud, Business Intelligence Success Factors Tools for aligning your business in the

global economy, John Wiley and Sons, 2009

3. Steve Williams and Nancy Williams, The Profit impact of Business Intelligence, Morgan

Kauffman Publishers! Elsevier, 2007

4. Data Mining & Warehousing 1St Edition 2014 by Ikvinderpal Singh, Khanna

Publishing House

5. Data Warehousing & Data Mining by Bhosale Varsha Dreamtech Press India Pvt. Ltd
 SPREADSHEET MODELLING (BA)

Course Objectives:

The Objective of this course will cover all aspects of creating spreadsheet, performing calculations,

formatting and widely used formulas, and also enable the students to create, build models and

customize graphs, develop advanced solutions on the worksheet in the areas of Marketing, Finance,

Statistics, production and Human Resource and to assemble the proper Excel tools.

Course Outcomes: After Completion of the Course, students will be able to:

CO-1: Explain the basic features of Excel Spreadsheets functions (Understand)

CO-2: Identify the MS Excel based Financial Models (Understand)

CO-3: Apply the Excel tools for Finance, Marketing, Statistics and HR (Apply)

CO-4: Analyze the advanced tools of Excel (Analyze)

CO5: Evaluate and Build Excel Macros for implementing advanced functionalities in Excel.

(Evaluate)

UNIT- I: INTRODUCTION

Module: Introduction to Spread sheet, Cell references, Modeling Functions, Formulas/ Formatting/

Printing, Lookup tables, linking disparate workbooks, Dynamic linking, updating links, data

validation, Goal seek, Pivot table, Sorting, Charting and filtering and protecting spreadsheets.

UNIT –II: SPREADSHEET MODELLING IN SALES AND MARKETING

New product decision making –Sales and marketing data analysis.

UNIT –III: SPREADSHEET MODELLING IN FINANCE

Forecasting financial statements – Capital budgeting, decisions, Bond valuation, Stock valuation,

Break even analysis, Budgeting, Ratio analysis, Sensitivity analysis, Simulation analysis, Portfolio

construction and Working capital.

Measures of central tendency, Measures of Dispersion, T test, ANOVA, Correlation, Regression

and Time series analysis.

UNIT –V SPREADSHEET MODELING IN PRODUCTION AND HUMAN RESOURCS

ABC analysis, Economic order quantity, Production budget – employee and payroll decision

making.

SUGGESTED BOOKS

1. Walkenbach, John. Excel Bible. New Delhi: Wiley India PvtLtd.2ndedition,2010

2. MacDonald, Mathew, Excel: The Missing Manual.Sebastopol:O’reilly.2ndedition,

2010

3. Ragsdale, Cliff. T, spreadsheet Modeling and Decision Analysis. New York: Thomson south –

western publications. 6thedition, 2008

4. Microsoft Excel Data Analysis and Business Modeling, 5th Edition By Wayne

Winston,Pearson Education

5. Business Analytics: The Art of Modeling With Spreadsheets, 5th Edition Stephen G.Powell,

Kenneth R. Baker, Willy Publishers

Course Objectives:

The Objective of this course to familiarize the basic concepts of e-commerce, Electronic payment

systems, electronic fund transfer, web branding strategies, mobile commerce strategies for business

over web, web hosting and as well as its technological, political, security and economic

components.

Course Outcomes:

After Completion of this course, students will be able to:

CO-1: Explain the basic concepts and importance of E-commerce (Understand)

CO-2: Analyze the impact of E-Commerce on business models and strategies (Analyze)

CO-3: Illustrate different protocols and script languages for E-Commerce (Apply)

CO-4: Describe the web-based tools for E-Commerce (Analyze)

CO-5: Discuss legal issues and privacy in E-Commerce and assessing of e-payment systems

(Analyze)

CO-6: Explain the security Agents and web-based marketing (Understand)

UNIT- I: INTRODUCTION

Traditional Commerce and E Commerce- Internet and WWW – role of WWW – Value Chains –

strategic business and Industry value Chains – role of E Commerce.

UNIT- II: INFRASTRUCTURE FOR E COMMERCE

Packet switched networks – TCP/IP protocol script – Internet utility programmes –SGML, HTML

and XML – web client and servers – Web client/server architecture – intranet and extranets.

UNIT- III: WEB BASED TOOLS FOR E COMMERCE

Web server – performance evaluation – web server software feature sets – web server –software
and tools – web protocol – search engines – intelligent agents –EC software – web hosting – cost

analysis.

UNIT- IV: SECURITY

Computer security classification – copy right and Intellectual property – electronic –commerce

threats – protecting client computers – electronic payment systems – electronic cash – strategies for

marketing – sales and promotion – cryptography – authentication.

UNIT –V: INTELLIGENT AGENTS

Definition and capabilities – limitation of agents – security – web-based marketing – search engines

and Directory registration – online advertisements – Portables and info mechanics – website design

issues.

SUGGESTED BOOKS:

1. Gary P Schneider “Electronic commerce”, Thomson learning & James T Peny

Cambridge USA, 5th edition 2001.

2. Manlyn Greenstein and Miklos “Electronic commerce” McGraw-Hill, 7 th edition 2002.

3. EfraimTurvanJ.Lee, David Kug and Chung, “Electronic commerce” Pearson Education

Asia, 7th edition, 2001.

4. E-Commerce: An Indian Perspective by P.T. Joseph S.J. PHI Learning Pvt Ltd

5. Concepts of E-Eommerce by Pandey Adesh, S. K., & Sons