SUK · Third Year B.Tech. Computer Science and Engineering (Artificial Intelligence and Data Science) · NEP 2020
Business Intelligence System
AI&DS3204 · Elective II · Semester VI · 3 credits · ISE 10 + mid-semester 30 + ESE 60
One of the Elective II options.
Unit 1: Introduction to Business Intelligence
5 hoursLeveraging data and knowledge; BI components, dimensions and the information hierarchy; BI and business analytics; the BI life cycle; data issues and data quality for BI.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- BI architecture and components
- The business intelligence value proposition
- Data quality and validation
Unit 2: BI Implementation
7 hoursKey drivers, KPIs and operational metrics; BI architectures and best practices; business decision making; business analytics, web analytics and intelligence, CRM.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- KPIs, metrics and briefing books
- Strategic, tactical and departmental BI
- Decision support systems
- ERP, CRM and business intelligence
Unit 3: Business and Corporate Performance Management
6 hoursDashboards and scorecards, business activity monitoring and Six Sigma; big data, social networks, mobile BI and emerging trends; managerial, strategic and technical issues of BI and data warehouses.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Dashboards and performance management
- Mobile and cloud BI
Unit 4: Data Warehousing
6 hoursData marts and warehouse architecture, components and implementation options; metadata and information delivery; ETL: extraction, transformation (conditioning, scrubbing, merging), loading, staging and data quality.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Data warehouse architecture
- Data marts and OLAP cubes
- ETL and change data capture
Unit 5: Dimensional Modelling and OLAP
6 hoursFacts, dimensions and measures; star, snowflake and fact-constellation schemas and slowly changing dimensions; OLAP versus OLTP, multidimensional databases, ROLAP, MOLAP and HOLAP.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Data warehouse schemas
- Fact and dimension tables, factless facts and granularity
- OLTP versus the data warehouse
- ROLAP, MOLAP and HOLAP
Unit 6: Business Analytics and Data Mining
6 hoursDescriptive, diagnostic, predictive and prescriptive analytics; data-mining concepts and tasks; classification, clustering, association rules and time series.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Types and phases of data analytics
- Classification in BI
- Clustering in BI
- Association rules
Unit contents are summarised from the official SUK syllabus . AiCanCode.org is not affiliated with Shivaji University, Kolhapur.