Sample Dataset - HR Subject Areas

Dataset created as part of the Master Thesis "Business Intelligence – Automation of Data Marts modeling and its data processing". Lucerne University of Applied Sciences and Arts Master of Science in Applied Information and Data Science (MScIDS) Autumn Semester 2022 Change log Version 1.1: The following SQL scripts were added: Index Type Name 1 View pg.dictionary_table 2 View pg.dictionary_column 3 View pg.dictionary_relation 4 View pg.accesslayer_table 5 View pg.accesslayer_column 6 View pg.accesslayer_relation 7 View pg.accesslayer_fact_candidate 8 Stored Procedure pg.get_fact_candidate 9 Stored Procedure pg.get_dimension_candidate 10 Stored Procedure pg.get_columns Scripts are based on Microsoft SQL Server Version 2017 and compatible with a data warehouse built with Datavault Builder. Data warehouse objects scripts of the sample data warehouse are restricted and cannot be shared.