22MBABA305 Business Analytics and Intelligence syllabus for MBA

INTRODUCTION TO BUSINESS ANALYTICS:

What is business analytics? Historical Overview of data analysis, Data Scientist vs. Data Engineer vs. Business Analyst, Career in Business Analytics.

INTRODUCTION TO BUSINESS INTELLIGENCE:

Meaning, Purpose and Structure of Business Intelligence Systems. Understanding Multidimensional Analysis Concepts: Attributes, Hierarchies and Dimensions in data Analysis. Understanding Dimensional Data Warehouse: Fact Table, Dimension Tables, Surrogate Keys and Alternative Table Structure. What is multi-dimension

BUSINESS PROBLEM SOLVING AND TABULEAU:

Introduction to Tableau, Evaluation of Tableau, Tableau Architecture and Installation of Tableau. Data analysis and data communication with Tableau. Tableau public and desktop. Knowing Your Data, importing data, the “Data Visualization Process”, table view, Dashboard, Tableau Basics: Dimensions, Measures, Tableau Workspace, cards and shelves, marks card, formatting how to analyse structured data using Tableau, exporting data.

BUSINESS PROBLEM SOLVING AND VISUALISATION USING TABULEAU:

Visualization Graphs and Application: using device designer, maps in Tableau, editing unrecognized locations, custom geocoding, polygon maps, map box integration, types of calculations, calculation syntax.

INTRODUCTION TO POWER BI, SQL Server Introduction, Introduction to Power Bi, Basic Report Design, Visual sync, Grouping, Visualization Properties.

VISUALISATION USING POWER BI, Data preparation, Visualizing data in charts and tables, Relationships in tables, Spatial visualization.

Assessment Details (both CIE and SEE)

• The weightage of Continuous Internal Evaluation (CIE) is 50% and for Semester End Exam (SEE) is 50%.
• The minimum passing marks for the CIE is 50% of the maximum marks.
• Minimum passing marks in SEE is 40% of the maximum marks of SEE.
• A student shall be deemed to have satisfied the academic requirements (passed) and earned the credits allotted to each course if the student secures not less than 50% in the sum total of the CIE (Continuous Internal Evaluation) and SEE (Semester End Examination) taken together.

Continuous Internal Evaluation:

There shall be a maximum of 50 CIE Marks. A candidate shall obtain not less than 50% of the maximum marks prescribed for the CIE.

CIE Marks shall be based on:

a) Tests (for 25Marks) and

b) Assignments, presentations, Quiz, Simulation, Experimentation, Mini project, oral examination, field work and class participation etc., (for 25 Marks) conducted in the respective course. Course instructors are given autonomy in choosing a few of the above based on the subject relevance and should maintain necessary supporting documents for same.

Semester End Examination:

The SEE question paper will be set for 100 marks and the marks scored will be proportionately reduced to 50.

• The question paper will have 8 full questions carrying equal marks.
• Each full question is for 20 marks with 3 sub questions.
• Each full question will have sub question covering all the topics.
• The students will have to answer five full questions; selecting four full question from question number one to seven in the pattern of 3, 7 & 10 Marks and question number eight is compulsory.

Suggested Learning Resources:

Recommended Books

1. Business Intelligence and Analytics: Systems for Decision Support : by Ramesh Sharda, Pearson.

2. Business Intelligence, Analytics, and Data Science: A Managerial Perspective | Fourth Edition | By Pearson Paperback by Ramesh Sharda / DursunDelen / Efraim Turban

3. Visual Analytics with Tableau,by Alexander Loth,Wiley

4. Learning Tableau 2020: Create effective data visualizations, build interactive visual analytics, and transform your organization, 4th Edition,by Joshua N. Milliga

5. Data Visualization: Using Power BI, Orange and Excel- by Dr.Shirshendu Roy , sold by BOOKNETZ

6. Mastering Power BI- by Chandraish Sinha , Sold by Epitome Books

Course outcome :

At the end of the course the student will be able to :

CO1 To understand concepts of business analytics and business intelligence L2

CO2 To apply the knowledge of the processes needed to develop, report, and analyse business data. L3

CO3 Analyse data using Excel and Excel add-ins to solve business problems. L4

CO4 Evaluate the Data Structure and pattern for Decision making in business management L5