MULTIDIMENSIONAL DATA MODELLING: DATA SETS AND TOOLS FOR BUSINESS INTELLIGENCE

STANIER, Clare (2013) MULTIDIMENSIONAL DATA MODELLING: DATA SETS AND TOOLS FOR BUSINESS INTELLIGENCE. In: 11th International Workshop on the Teaching, Learning and Assessment of Databases, 5 July 2013, University of Sunderland.

Text TLAD13_Multidimensional Data Modelling.docx.doc - AUTHOR'S ACCEPTED Version (default) Available under License All Rights Reserved. Download (263kB)

Abstract or description

Business Intelligence (BI) is an expanding data management area. BI analysis requires students to understand key concepts such as multidimensional data modelling, data cleansing and data mining algorithms, tools and techniques. Practical work for BI is often based around Excel which has a number of limitations as far as the teaching of BI is concerned. This paper discusses the experience of using the SSAS (SQL Server Analysis Services) tool to introduce students to multidimensional data modelling. We describe the way in which the tool was used, the issues encountered, the strengths and limitations of working with SSAS and possible future extensions. We also discuss issues with identifying and using data sets and outline a proposal to extend the data sets available to our students

Item Type:	Conference or Workshop Item (Paper)
Uncontrolled Keywords:	Business Intelligence; Multidimensional Data Modelling; Data Sets; Data Mining.
Faculty:	Previous Faculty of Computing, Engineering and Sciences > Computing
Event Title:	11th International Workshop on the Teaching, Learning and Assessment of Databases
Event Location:	University of Sunderland
Event Dates:	5 July 2013
Depositing User:	Clare STANIER
Date Deposited:	09 Nov 2016 11:33
Last Modified:	24 Feb 2023 13:45
URI:	https://eprints.staffs.ac.uk/id/eprint/2883

Actions (login required)

View Item