PAHSU · Final Year B.Tech. Computer Science and Engineering · NEP 2020
Business Intelligence
CSEPEC-04B · Programme Elective IV · Semester VII · 4 credits · End-semester 100 only
One of the Programme Elective IV options. Programme Elective IV: examined by a 100-mark end-semester exam only.
Unit 1: Introduction to Business Intelligence
8 hoursBI concepts and evolution; BI architecture and components; BI applications; BI versus business analytics.
Examined in the 100-mark end-semester paper
- Business intelligence: components and architecture
- BI applications across business functions
- The BI life cycle
- BI versus data warehousing and data mining
Unit 2: Data Warehousing
7 hoursData warehouse concepts and architecture; the ETL process; dimensional modelling; star and snowflake schemas.
Examined in the 100-mark end-semester paper
- BI and data warehouse architectures
- Data warehouse concepts and architecture
- ETL and the metadata repository
- Star, snowflake and fact constellation schemas
Unit 3: OLAP
8 hoursOLAP concepts and operations; MOLAP, ROLAP and HOLAP; OLAP versus OLTP; OLAP tools.
Examined in the 100-mark end-semester paper
- OLAP vs OLTP and data cubes
- OLAP operations and ROLAP vs MOLAP
Unit 4: Data Mining
8 hoursData mining concepts; preprocessing; classification, clustering and association rule mining.
Examined in the 100-mark end-semester paper
- Data mining for BI
- Data validation and transformation
- Classification for BI: Bayesian methods and logistic regression
- Clustering for BI
- Association rules and Apriori
Unit 5: Business Analytics and BI Tools
7 hoursTypes of business analytics; dashboards and KPIs; BI tools such as Power BI and Tableau; future trends.
Examined in the 100-mark end-semester paper
- Predictive, descriptive and prescriptive analytics
- Dashboards, EIS and MIS
- KPIs and balanced scorecards
- BI tools: Tableau and Power BI
Unit contents are summarised from the official PAHSU syllabus . AiCanCode.org is not affiliated with Punyashlok Ahilyadevi Holkar Solapur University (PAHSU).