ADVANCED DATABASE SYSTEMS (4 Credits)
Learning Outcomes:
On successful completion of this course, students will be able to: Explain basic concepts of Data Warehouse, Data Warehouse development, architecture and business intelligence applications; Design a dimensional and physical model for data warehouse; Comprehend ETL strategies; Design and develop business intelligence applications.
Topics:
- Introduction to Data Warehouse
- Data Warehouse Components
- Introduction to Kimball Lifecycle
- Collecting the Requirements
- Dimensional Modelling 1
- Dimensional Modelling 2
- Designing the Physical Database and Planning for Performance
- Introducing Extract, Transformation, and Load
- Designing and Developing the ETL System
- Introducing Business Intelligence Applications
- Practice faculty members
- Practice : Design report with Pentaho
- Introducing the Technical Architecture (Guest Lecture)
- Practice : Analysis OLAP with Pentaho
- Practice : BI Pentaho
- Business Intelligence application and development (Guest Lecture).
SOCIAL MEDIA
Let’s relentlessly connected and get caught up each other.
Looking for tweets ...