© 2014

Fuzzy Data Warehousing for Performance Measurement

Concept and Implementation

  • Presents an innovative approach for qualitative data analysis that is close to human reasoning

  • A practical use case example explains how to integrate fuzzy concepts in existing data warehouses

  • Provides a fuzzy data warehouse architecture overview using common open-source technologies


Part of the Fuzzy Management Methods book series (FMM)

Table of contents

  1. Front Matter
    Pages i-xxiv
  2. Daniel Fasel
    Pages 1-8
  3. Concept

    1. Front Matter
      Pages 9-9
    2. Daniel Fasel
      Pages 11-42
    3. Daniel Fasel
      Pages 43-114
  4. Application

    1. Front Matter
      Pages 115-115
    2. Daniel Fasel
      Pages 117-150
  5. Implementation

    1. Front Matter
      Pages 151-151
    2. Daniel Fasel
      Pages 153-182
  6. Evaluation and Conclusion

    1. Front Matter
      Pages 183-183
  7. Back Matter
    Pages 195-236

About this book


The numeric values retrieved from a data warehouse may be difficult for business users to interpret, and may even be interpreted incorrectly. Therefore, in order to better ​understand numeric values, business users may require an interpretation in meaningful, non-numeric terms. However, if the transition between non-numeric terms is crisp, true values cannot be measured and a smooth transition between classes may no longer be possible.This book addresses this problem by presenting a fuzzy classification-based approach for a data warehouses. Moreover, it introduces a modeling approach for fuzzy data warehouses that makes it possible to integrate fuzzy linguistic variables in a meta-table structure. The essence of this structure is that fuzzy concepts can be integrated into the dimensions and facts of an existing classical data warehouse without affecting its core. This allows a simultaneous analysis, both fuzzy and crisp. A case study of a movie rental company underlines and exemplifies the proposed approach.


Data analytics Data warehouse Fuzzy classification Fuzzy logic Fuzzy set theory OLAP application Soft computing

Authors and affiliations

  1. 1.Scigility Inc.MarlySwitzerland

About the authors

Dr. Daniel Fasel is the founder, CEO and President of the Managerial Board at Scigility. Previously, he served as the first data scientist on the business intelligence team at Swisscom and was key in implementing NoSQL technologies for explorative analytics during his time there. Before focusing on data science and NoSQL technologies, he was a BI Engineer for the contract and customer field - a core component of the Swisscom Data Warehouse. He also served as a BI Architect and Administrator for the Oracle Hyperion Essbase cubes. In 2012, he received his Ph.D. in economics from the University of Fribourg.


Bibliographic information

Industry Sectors
Chemical Manufacturing
IT & Software
Consumer Packaged Goods
Finance, Business & Banking