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 <strong>Master of Science in Applied Information and Data Science (MScIDS)</strong> Autumn Semester 2022 <em>Change log Version 1.1:</em> <em>The following SQL scripts were added:</em> <strong>Index</strong> <strong>Type</strong> <strong>Name</strong> 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.