Sample Dataset - HR Subject Areas

<p>Dataset created as part of the Master Thesis &quot;Business Intelligence &ndash; Automation of Data Marts modeling and its data processing&quot;.</p> <p>&nbsp;</p> <p>Lucerne University of Applied Sciences and Arts</p> <p><strong>Master of Science in Applied Information and Data Science (MScIDS)</strong></p> <p>Autumn Semester 2022</p> <p>&nbsp;</p> <p><em>Change log Version 1.1:</em></p> <p><em>The following SQL scripts were added:</em></p> <table> <tbody> <tr> <td><strong>Index</strong></td> <td><strong>Type</strong></td> <td><strong>Name</strong></td> </tr> <tr> <td>1</td> <td>View</td> <td>pg.dictionary_table</td> </tr> <tr> <td>2</td> <td>View</td> <td>pg.dictionary_column</td> </tr> <tr> <td>3</td> <td>View</td> <td>pg.dictionary_relation</td> </tr> <tr> <td>4</td> <td>View</td> <td>pg.accesslayer_table</td> </tr> <tr> <td>5</td> <td>View</td> <td>pg.accesslayer_column</td> </tr> <tr> <td>6</td> <td>View</td> <td>pg.accesslayer_relation</td> </tr> <tr> <td>7</td> <td>View</td> <td>pg.accesslayer_fact_candidate</td> </tr> <tr> <td>8</td> <td>Stored Procedure</td> <td>pg.get_fact_candidate</td> </tr> <tr> <td>9</td> <td>Stored Procedure</td> <td>pg.get_dimension_candidate</td> </tr> <tr> <td>10</td> <td>Stored Procedure</td> <td>pg.get_columns</td> </tr> </tbody> </table> <p>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&nbsp;are restricted and cannot be shared.</p> <p>&nbsp;</p>