Present the terminology and general concepts related to the field of data warehousing systems.
Know how to justify the implementation of a data warehousing system in an organization as a fundamental element of a enterprise decision support system.
Provide the necessary bases for developing analysis, planning and design processes of dimensional models for data warehouses.
Know how to plan and implement a data warehousing system, constructing appropriate staging areas and appropriate means for collecting, transforming and loading data into a data warehouse.
Know how to use the various process development standards for data warehousing systems, including the use of data vaults.
Know how to design and implement a data lakehousing system.
Program
Introduction to Data Warehousing Systems.
Architectures and Services of a Data Warehousing System.
Data warehousing System development life-cycle.
Data Warehousing System Administration.
Data Warehousing System Design.
Dimensional Data Modeling.
Populating Data Warehouses.
Exploration of Data Warehouses.
Using Data Vaults in Data Warehousing Systems.
Implementation of Data Lakehouses.
Bibliography
Corr, L., Stagnitto, J., Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema, 5th Edition, DecisionOne Press, November 24, 2011. ISBN-10 : 0956817203, ISBN-13 : 978-0956817204.
Golfarelli, M., Rizzi, S., Data Warehouse Design: Modern Principles and Methodologies, McGraw-Hill Osborne Media; 1st Edition, May 26, 2009.
Kimball, R., Margy Ross, M., The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition, Wiley, 3rd edition, July 1, 2013. ISBN-10 : 1118530802, ISBN-13 : 978-1118530801.
Kimball, R., Reeves, L., Ross, M., Thornthwait, W., The Data Warehouse Lifecycle Toolkit - Pratical Techiniques for Building Data Warehouse and Business Intelligence Systems, John Wiley & Sons, 2ª Edição, 2008. ISBN-10: 0470149779. ISBN-13: 978-0470149775.