Title: Data warehousing and exploratory analysis for market monitoring
Authors : Geiger, Melanie
Stockinger, Kurt
et. al : No
Published in : Applied data science : lessons learned for the data-driven business
Pages : 333
Pages to: 351
Publisher / Ed. Institution : Springer
Publisher / Ed. Institution: Cham
Issue Date: 2019
License (according to publishing contract) : Licence according to publishing contract
Type of review: Editorial review
Language : English
Subjects : Data warehousing; Machine learning; Query processing; Database
Subject (DDC) : 005: Computer programming, programs and data
Abstract: With the growing trend of digitalization, many companies plan to use machine learning to improve their business processes or to provide new data-driven services. These companies often collect data from different locations with sometimes conflicting context. However, before machine learning can be applied, heterogeneous datasets often need to be integrated, harmonized, and cleaned. In other words, a data warehouse is often the foundation for subsequent analytics tasks. In this chapter, we first provide an overview on best practices of building a data warehouse. In particular, we describe the advantages and disadvantage of the major types of data warehouse architectures based on Inmon and Kimball. Afterward, we describe a use case on building an e-commerce application where the users of this platform are provided with information about healthy products as well as products with sustainable production. Unlike traditional e-commerce applications, where users need to log into the system and thus leave personalized traces when they search for specific products or even buy them afterward, our application allows full anonymity of the users in case they do not want to log into the system. However, analyzing anonymous user interactions is a much harder problem than analyzing named users. The idea is to apply modern data warehousing, big data technologies, as well as machine learning algorithms to discover patterns in the user behavior and to make recommendations for designing new products.
Departement: School of Engineering
Organisational Unit: Institute of Applied Information Technology (InIT)
Publication type: Book Part
DOI : 10.1007/978-3-030-11821-1_18
ISBN: 978-3-030-11820-4
978-3-030-11821-1
URI: https://digitalcollection.zhaw.ch/handle/11475/17803
Published as part of the ZHAW project : Market Monitoring
Appears in Collections:Publikationen School of Engineering

Files in This Item:
There are no files associated with this item.


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.