Introduction to Business Analytics and Databases

Paper Code: 
MBB 126
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

Course Objective: The basic purpose of this paper is to enable students to

1.    Learn the concepts of business analytics and process of analytics

2.    Understand the concepts of database and data warehouse

3.    Design queries in MySQL

Course Outcomes (COs):  At the end of this course, a student should be able to:

 

Course

Course outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Paper Code-

Paper Title

CLO 31.     Analyse the business problems and examine the application of business analytics in solving such problems.

CLO 32.         Discover the process of business analytics with respect to different case business studies.

CLO 33.         Examine the data models of database for business applications and discuss framework of relational database.

CLO 34.         Design a database for business application and execute queries using MySQL.

CLO 35.         Compare database with Data Warehouse

CLO 36.         Design a Data Warehouse for business application using MySQL.

 

Approach in teaching:

Interactive Lectures, Group Discussion, Tutorials, Case Study, Demonstration.

 

 

Learning activities for the students:

Self-learning assignments, presentations, practical exercises

Class test, Semester end examinations, Quiz, Assignments, Presentation, Peer Review

12.00
Unit I: 
Business Analytics:

Meaning – Data Analytics, Business Analytics, Data Science, Big Data Analytics. Drivers for Business Analytics, Applications of Business Analytics, Skills Required for a Business Analyst

12.00
Unit II: 
Business Analytics Process and Data Exploration:

Business Analytics Life Cycle, Understanding the Business Problem, Collecting and Integrating the Data, Preprocessing the Data, Using Modeling Techniques and Algorithms, Evaluating the Model, Presenting a Management Report and Review.

12.00
Unit III: 
Database:

Concept of data ,files and database, Database Management Systems, Definition, Characteristics of DBMS, Architecture & Security, Types of Data Models, Concepts ,constraints and keys of RDBMS, Introduction to Normalization, 1NF, 2NF and 3NF.

12.00
Unit IV: 
SQL and MySQL :

Data definition and Manipulation using MySQL, SQL Process, SQL Commands – DDL, DML, DCL, DQL, SQL Constraints, Data Integrity, Data Types, SQL Operators, Expressions, Querying Database, Retrieving result sets, Sub Queries, Syntax for various Clauses of SQL, Functions and Joins, Indexes, Views, Transactions

12.00
Unit V: 
Data Warehousing:

Evolution of Decision Support Systems, Problems with the Naturally Evolving Architecture, Data Warehouse Environment, Definition of data warehouse, Data marts, Data quality, Data warehouse architecture, ETL tools, Metadata, Cubes and multidimensional analysis ,Dimensional data Warehouse, Implement Data Warehouse using MySQL, defining data mining , models and methods for data mining.

Essential Readings: 
  • Dr. Umesh R. Hodeghatta Umesha Nayak, “Business Analytics Using R - A Practical Approach”, Apress, 2017.
  • Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 6th Edition, McGraw Hill, 2011.
  • W. H. Inmon, “Building the Data Warehouse”, Wiley Dreamtech India Pvt. Ltd., 4th  Edition, 2005
  • Carlo Vercellis ,Business Intelligence: Data Mining and Optimization for Decision Making, John Wiley & Sons, Ltd. 2009

 

 

Academic Year: 
2021-2022
  • Printer-friendly version
  • PDF version