City Intelligence
Code
400046
Academic unit
NOVA Information Management School
Credits
7.5
Teacher in charge
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Objectives
This course looks at the importance of business intelligence as a data management tool. It also focuses of the vital role that data warehousing and archiving play in the context of smart cities.
Prerequisites
Subject matter
• Introduction to BI for smart cities
• Introduction to database modelling and SQL
• Data Warehousing
o Definitions and Concepts
o Process Overview
o Architectures
• Data Warehouse Development. Data Warehousing Implementation Issues. Data Warehouse Administration and Security Issues
• DW Implementation. Implement dimensions and fact tables. Managing performance.
• Data Integration and the Extraction, Transformation, and Load (ETL) Process
• Introduction to Data Quality
• Business Analytics and Data Visualization
• Future Trends in BI
Bibliography
The Data Warehouse Lifecycle Toolkit, 2008 by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker
Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit), 2012 by Dejan Sarka, Matija Lah, Grega Jerkic
Building a Data Warehouse: With Examples in SQL Server, 2007 by Vincent Rainard
Teaching method
Evaluation method