BUSINESS INTELLIGENCE AND STATISTICS

Paper Code: 
24MCA325A
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

 

This course enables the students to

  1. Define the concepts of business intelligence and statistics.
  2. Understand the concepts of knowledge delivery in business intelligence.
  3. Demonstrate the concept of peer groups and cross efficiency analysis.
  4. Differentiate between business intelligence and business statistics.
  5. Evaluate using different distributions and testing techniques.
  6. Create new ideas where the knowledge of business intelligence and statistics can be implemented.
Course Outcomes: 

 

Course

Learning Outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

24MCA 325A

Business Intelligence and Statistics

(Theory)

 

  1. Analyse the concepts of business intelligence and statistics.
  2. Examine the concepts of knowledge delivery and interactive reports
  3. Analyse the concept of pattern matching and cluster analysis
  4. Differentiate different distributions and testing techniques.
  5. Evaluate using different testing techniques.
  6. Contribute effectively in course-specific interaction

Approach in teaching:

Interactive Lectures,

Modeling, Discussions, implementing enquiry based learning.

 

Learning activities for the students:

Experiential Learning, Presentations, Case based learning, Discussions, Quizzes and Assignments

 

  • Assignments
  • Written test in classroom
  • Classroom activity
  • Continues Assessment
  • Semester End Examination

 

12.00

 

Business intelligence  

Effective and timely decisions, Data, information and knowledge, Role of mathematical models, Business intelligence architectures: Cycle of a business intelligence analysis,  Enabling factors in business intelligence projects – Development of a business intelligence system, Ethics and business intelligence. Data Science Vs. business intelligence

12.00

 Knowledge delivery

The business intelligence user types, Standard reports, Interactive Analysis and Ad Hoc Querying, Parameterized Reports and Self-Service Reporting, dimensional analysis, Alerts/Notifications, Visualization: Charts, Graphs, Widgets, Scorecards and Dashboards, Geographic Visualization, Integrated Analytics, Considerations: Optimizing the Presentation for the Right Message.

12.00

Efficiency       

Efficiency measures – The CCR model: Definition of target objectives- Peer groups – Identification of good operating practices; cross efficiency analysis – virtual inputs and outputs – Other models. Pattern matching – cluster analysis, outlier analysis, Business Intelligence Applications.

 

12.00

Distributions

Introduction to Population, Sample, Variable, Continuous Distribution, Discrete Distribution, Normal Distribution, Standard Deviation, Skewness, Mean, Mode, Median, Sampling Distribution, Central Limit Theorem, Z-Score.

 

12.00

Hypothesis Testing

Steps for Hypothesis Testing, Statistical Significance, Hypothesis Testing Assumptions, Proportion Testing, Null Hypothesis, t-Distribution, t-tests, one-tailed and two-tailed t tests, Significance of p-values. Pareto Principle, Trends in analytics.

 

ESSENTIAL READINGS: 

1.Ramesh Sharda, Dursun Delen and Efraim Turban, “Business Intelligence,     Analytics, and Data Science: A Managerial Perspective”,  4th Edition, Pearson, 2019

2.David Loshin, “Business Intelligence”, Second Edition, Morgan Kaufmann, 2012.

                             

 

 

 

REFERENCES: 

Suggested Readings:

1.Levin Richard, H. Siddiqui Masood, S. Rubin David, Rastogi Sanjay, Statistics for Management, 8th Edition, Pearson, 2017.

2.Cindi Howson, “Successful Business Intelligence: Secrets to Making BI a Killer App”, McGraw-Hill, 2007.

3.Ralph Kimball , Margy Ross , Warren Thornthwaite, Joy Mundy, Bob Becker, “The Data Warehouse Lifecycle Toolkit”, Wiley Publication Inc.,2007.

E-Resources

1.Business Intelligence Tutorial - Learn Latest BI ... – DataFlair(https://data-flair.training/blogs/business-intelligence/)                                                                                                                                                                                                                            2.Data Science & Business Analytics Tutorials by Simplilearn (https://www.simplilearn.com/resources/data-science-business-analytics/tutorials.                                                                                                      3.Business Intelligence Tutorials - Tutorialspoint(https://www.tutorialspoint.com/what-is-business-intelligence)                                                                                           4.www.tutorialslink.com(https://tutorialslink.com/Articles/What-is-BI-(Business-Intelligence)-Definition-and-Examples-BI-Tutorial/2059)                                              

Journals

1.International Journal of Business Intelligence and Data Mining, InderScience Publishers (https://www.inderscience.com/jhome.php?jcode=ijbidm)                                           2.International Journal of Business Intelligence Research(IJBIR), IGI Global (https://www.igi-global.com/journal/international-journal-business-intelligence-research/1168)     3.Computational Statistics & Data analysis, Elsevier (https://www.journals.elsevier.com/computational-statistics-and-data-analysis)                                                     4.International Journal of Business and Data Analytics, InderScience Publishers (https://www.inderscience.com/jhome.php?jcode=ijbda)

 

Academic Year: