Data warehousing and analytics : fueling the data engine / David Taniar, Wenny Rahayu.
Taniar, David, author.; Rahayu, Johanna Wenny, author.
2021
QA76.9.D37 T36 2021
Available Online

Linked e-resources

Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks

Details

Title
Data warehousing and analytics : fueling the data engine / David Taniar, Wenny Rahayu.
Author
Taniar, David, author.
ISBN
9783030819798 (electronic bk.)
3030819795 (electronic bk.)
9783030819781
3030819787
DOI
https://doi.org/10.1007/978-3-030-81979-8
Published
Cham : Springer, [2021]
Copyright
©2021
Language
English
Description
1 online resource : illustrations (some color).
Item Number
10.1007/978-3-030-81979-8 doi
Call Number
QA76.9.D37 T36 2021
Dewey Decimal Classification
005.74/5
Summary
This textbook covers all central activities of data warehousing and analytics, including transformation, preparation, aggregation, integration, and analysis. It discusses the full spectrum of the journey of data from operational/transactional databases, to data warehouses and data analytics; as well as the role that data warehousing plays in the data processing lifecycle. It also explains in detail how data warehouses may be used by data engines, such as BI tools and analytics algorithms to produce reports, dashboards, patterns, and other useful information and knowledge. The book is divided into six parts, ranging from the basics of data warehouse design (Part I - Star Schema, Part II - Snowflake and Bridge Tables, Part III - Advanced Dimensions, and Part IV - Multi-Fact and Multi-Input), to more advanced data warehousing concepts (Part V - Data Warehousing and Evolution) and data analytics (Part VI - OLAP, BI, and Analytics). This textbook approaches data warehousing from the case study angle. Each chapter presents one or more case studies to thoroughly explain the concepts and has different levels of difficulty, hence learning is incremental. In addition, every chapter has also a section on further readings which give pointers and references to research papers related to the chapter. All these features make the book ideally suited for either introductory courses on data warehousing and data analytics, or even for self-studies by professionals. The book is accompanied by a web page that includes all the used datasets and codes as well as slides and solutions to exercises.
Bibliography, etc. Note
Includes bibliographical references.
Access Note
Access limited to authorized users.
Source of Description
Description based on print version record.
Added Author
Rahayu, Johanna Wenny, author.
Series
Data-centric systems and applications.
Available in Other Form
Data warehousing and analytics.
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
1. Introduction
Part I: Star Schema
2. Simple Star Schemas
3. Creating Facts and Dimensions: More Complex Processes
Part II: Snowflake and Bridge Tables
4. Hierarchies
5. Bridge Tables
6. Temporal Data Warehousing
Part III: Advanced Dimension
7. Determinant Dimensions
8. Junk Dimensions
9. Dimension Keys
10. One-Attribute Dimensions
Part IV: Multi-Fact and Multi-Input
11. Multi-Fact Star Schemas
12. Slicing a Fact
13. Multi-Input Operational Databases
Part V: Data Warehousing Granularity and Evolution
14. Data Warehousing Granularity and Levels of Aggregation
15. Designing Lowest-Level Star Schemas
16. Levels of Aggregation: Adding and Removing Dimensions
17. Levels of Aggregation and Bridge Tables
18. Active Data Warehousing
Part VI: OLAP, Business Intelligence, and Data Analytics
19. Online Analytical Processing (OLAP)
20. Pre- and Post-Data Warehousing
21. Data Analytics for Data Warehousing.

Browse Subjects

Show more subjects...

Statistics

from
to
Export