Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Using Work Domain Analysis to Evaluate the Design of a Data Warehouse System
Uppsala University, Disciplinary Domain of Science and Technology, Mathematics and Computer Science, Department of Information Technology, Division of Visual Information and Interaction.
2019 (English)Independent thesis Advanced level (professional degree), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

Being able to perform good data analysis is a fundamental part of running any business or organization. One way of enabling data analysis is with a data warehouse system, a type of database that gathers and transforms data from multiple sources and structures it in the goal of simplifying analysis. It is commonly used to provide support in decision-making.

Although a data warehouse enables data analysis, it is also relevant to consider how well the system supports analysis. This thesis is a qualitative research that aims to investigate how work domain analysis (WDA) can be used to evaluate the design of a data warehouse system. To do so, a case study at the IT company Norconsult Astando was performed. A data warehouse system was designed for an issue management system and evaluated using the abstraction hierarchy (AH) model.

The research done in this thesis showed that analysis was enabled by adopting Kimball’s bottom-up approach and a star schema design with an accumulating snapshot fact table. Through evaluation of the design, it was shown that most of the design choices made for the data warehouse were captured in the AH. It was concluded that with sufficient data collection methods, WDA can be used to a large extent when evaluating a data warehouse system.

Place, publisher, year, edition, pages
2019. , p. 63
Series
UPTEC STS, ISSN 1650-8319 ; 19012
Keywords [en]
data warehouse, work domain analysis, cognitive work analysis, abstraction hierarchy, star schema, accumulating snapshot fact table, evaluation, issue management system, waterfall model
National Category
Computer and Information Sciences
Identifiers
URN: urn:nbn:se:uu:diva-384575OAI: oai:DiVA.org:uu-384575DiVA, id: diva2:1320992
External cooperation
Norconsult Astando
Educational program
Systems in Technology and Society Programme
Supervisors
Examiners
Available from: 2019-06-19 Created: 2019-06-06 Last updated: 2019-06-19Bibliographically approved

Open Access in DiVA

fulltext(3405 kB)33 downloads
File information
File name FULLTEXT01.pdfFile size 3405 kBChecksum SHA-512
186c6e2d3fa0c231d0f59a364c4258ef190cb2d6eebc4d9533626655a8592f93b7d3e18afcec630eb28ac6dee64a602b4d835283f7656fafb1108b191eb74bcd
Type fulltextMimetype application/pdf

By organisation
Division of Visual Information and Interaction
Computer and Information Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 33 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 160 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf