Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • 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
Design of Data Warehouse and Business Intelligence System: A case study of Retail Industry
Blekinge Institute of Technology, School of Computing.
Blekinge Institute of Technology, School of Computing.
2011 (English)Independent thesis Advanced level (degree of Master (One Year))Student thesis
Abstract [en]

Business Intelligence (BI) concept has continued to play a vital role in its ability for managers to make quality business decision to resolve the business needs of the organization. BI applications comes handy which allows managers to query, comprehend, and evaluate existing data within their organizations in order to obtain functional knowledge which then assist them in making improved and informed decisions. Data warehouse (DW) is pivotal and central to BI applications in that it integrates several diverse data sources, mainly structured transactional databases. However, current researches in the area of BI suggest that, data is no longer always presented in only to structured databases or format, but they also can be pulled from unstructured sources to make more power the managers’ analysis. Consequently, the ability to manage this existing information is critical for the success of the decision making process. The operational data needs of an organization are addressed by the online transaction processing (OLTP) systems which is important to the day-to-day running of its business. Nevertheless, they are not perfectly suitable for sustaining decision-support queries or business questions that managers normally needs to address. Such questions involve analytics including aggregation, drilldown, and slicing/dicing of data, which are best supported by online analytical processing (OLAP) systems. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Data in an OLAP warehouse is extracted and loaded from multiple OLTP data sources (including DB2, Oracle, SQL Server and flat files) using Extract, Transfer, and Load (ETL) tools. This thesis seeks to develop DW and BI system to support the decision makers and business strategist at Crystal Entertainment in making better decision using historical structured or unstructured data.

Place, publisher, year, edition, pages
2011. , 81 p.
Keyword [en]
Business Intelligence, Data Warehouse and OLTP, OLAP, ETL, SQL Server
National Category
Computer Science Information Systems Human Computer Interaction
Identifiers
URN: urn:nbn:se:bth-3738Local ID: oai:bth.se:arkivex812F5660B5F65276C125796A0064799COAI: oai:DiVA.org:bth-3738DiVA: diva2:831050
Uppsok
Technology
Supervisors
Available from: 2015-04-22 Created: 2011-12-18 Last updated: 2015-06-30Bibliographically approved

Open Access in DiVA

fulltext(3316 kB)17491 downloads
File information
File name FULLTEXT01.pdfFile size 3316 kBChecksum SHA-512
6828a82efbc8d1c0641871b70a9f09e0b19c742cc0e89658a119ba2b0d4d75562bf74bbc9b11f1417dd40e2eb9cbde51bb7266e011ddaafceb0f35c7d8937c51
Type fulltextMimetype application/pdf

By organisation
School of Computing
Computer ScienceInformation SystemsHuman Computer Interaction

Search outside of DiVA

GoogleGoogle Scholar
Total: 17492 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

Total: 341 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • 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