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.