315328: Business Intelligence Syllabus for Data Science 5th Sem K Scheme MSBTE PDF

Business Intelligence detailed Syllabus for Data Science (DS), K scheme PDF has been taken from the MSBTE official website and presented for the diploma students. For Subject Code, Subject Name, Lectures, Tutorial, Practical/Drawing, Credits, Theory (Max & Min) Marks, Practical (Max & Min) Marks, Total Marks, and other information, do visit full semester subjects post given below.

For all other MSBTE Data Science 5th Sem K Scheme Syllabus PDF, do visit MSBTE Data Science 5th Sem K Scheme Syllabus PDF Subjects. The detailed Syllabus for business intelligence is as follows.

Rationale

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Course Outcomes:

Students will be able to achieve & demonstrate the following COs on completion of course based learning

1. Describe Business Intelligence and its framework.
2. Apply Business Intelligence Planning Process.
3. Analyze Business Intelligence Database Design.
4. Implement Extraction ,Transformation and Loading process.
5. Develop Business application and generate its Report.

Unit I

Introduction To Business Intelligence 1.1 BI Definitions & Concepts, Applications of Business intelligence ,Benefits of business intelligence 1.2 Categories of BI analysis, Advantages and disadvantages of BI 1.3 Business intelligence platforms, Types of BI Tools and Software 1.4 BI Framework, Business intelligence platforms, Role of Data Warehousing in BI ,BI and big data 1.5 BI Infrastructure Components – BI Process, BI Technology, BI Roles & Responsibilities

Suggested Learning Pedagogie
Lecture Using Chalk-Board Hands-on Presentations

Unit II

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Unit III

Business Intelligence Database Designing 3.1 Database Design – Differences in Database Design Philosophies, Operational Databases, Operational Databases versus BI Target Databases, BI Target Databases 3.2 Logical Database Design – The Star Schema, The Snowflake Schema 3.3 Physical Database Design- Physical Dataset Placement, Partitioning ,Clustering ,Indexing ,Reorganizations ,Backup and Recovery ,Parallel Query Execution

Suggested Learning Pedagogie
Lecture Using Chalk-Board Presentations Hands-on

Unit IV

Extraction, Transformation and Loading 4.1 ETL Development Source -Heterogeneous Data Sources ,Integrated BI Implementation Strategy 4.2 Implementation Strategies for BI – Preparing for the ETL Process, Designing the Extract Programs, Designing the Transformation Programs ,Designing the Load Programs 4.3 Designing the ETL Process Flow- The Source-to-Target Mapping Document , The ETL Process Flow Diagram , The Staging Area ,Evaluating ETL Tools

Suggested Learning Pedagogie
Presentations Hands-on Lecture Using Chalk-Board

Unit V

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

List of Experiments:

1. *Power BI Software:- a) Download and Install the Power BI Software b) Write the features of Power BI software
2. * Analyze the Power BI Desktop Version using following steps- 1 .Connect to data with Power BI Desktop 2 .3 .Create visualizations and reports with Power BI Desktop 4 .Publish report to Power BI service 5 .Distribute and manage reports in the Power BI service
3. * Implement data importing from the Excel and load it in the target system
4. * Implement data extraction process in Power BI with respective data source
5. * Apply data transformation process to construct database in Power BI with respective data source
6. Apply relationship modeling on different tables in power BI
7. Apply data loading process to construct database in Power BI with respective datasource
8. Apply modeling and data drill feature to visualize database in Power BI
9. * Create different visuals to build a report in Power BI
10. Publish a report in Power BI

Self Learning

Micro Project

• Apply the BI solutions on the food industry for use of nutritious product in last two years manufacturing to take appropriate decision to enhance the sale and record it in report.
• Apply the BI solutions on the E-commerce industry for any five seasonal products in last two years sale to take appropriate decision to enhance the sale and record it in the report.
• Apply the BI solutions on the product based industry for sale of product in last five years to take appropriate decision to enhance the sale and record it in the report.

Assignment

• Solve an assignment on any relevant topic given by the teacher.

Laboratory Equipment

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Learning Materials

1. David Loshin Business Intelligence : The Savvy Manager’s Guide Morgan Kaufmann ISBN-13:978-1-55860-916-7
2. Larissa T. Moss, Shaku Atre Business intelligence roadmap Addison Wesley ISBN: 0-201-78420-3
3. Mike Biere Business intelligence for the enterprise Pearson Publication ISBN 10: 0131413031 / ISBN 13: 9780131413030

Learning Websites

1. https://learn.microsoft.com/en-us/training/modules/get-start ed-with-power-bi/2-using-power-bi Help on usage of Power BI a Business Intelligence Software
2. https://onlinecourses.nptel.ac.in/noc24_cs65 Course on Business Intelligence from NPTEL
3. https://www.geeksforgeeks.org/power-bi-tutorial/ Content on Power BI a Business Intelligence Software
4. https://infyspringboard.onwingspan.com/web/en/app/toc/lex_au th_0135015618300805128495/overview Course on Business Intelligence Tools from Infosys SpringBoard
5. https://infyspringboard.onwingspan.com/web/en/app/toc/lex_au th_01384295711430246427496_shared/overview Course on Business Intelligence from Infosys SpringBoard
6. https://www.tableau.com/learn/articles/business-intelligence #bi-analysis Basics of Business Intelligence

For detail Syllabus of all other subjects of Data Science, K scheme do visit Data Science 5th Sem Syllabus for K scheme.

For all Data Science results, visit MSBTE Data Science all semester results direct links.