國立虎尾科技大學 |

Data Warehousing and Analytics = Fueling the Data Engine /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Data Warehousing and Analytics/ by David Taniar, Wenny Rahayu.
Reminder of title:	Fueling the Data Engine /
Author:	Taniar, David.
other author:	Rahayu, Wenny.
Description:	XVIII, 635 p. 381 illus., 262 illus. in color.online resource. :
Contained By:	Springer Nature eBook
Subject:	Data Analysis and Big Data. -
Online resource:	https://doi.org/10.1007/978-3-030-81979-8
ISBN:	9783030819798

Data Warehousing and Analytics = Fueling the Data Engine /
Taniar, David.

Data Warehousing and AnalyticsFueling the Data Engine /[electronic resource] :by David Taniar, Wenny Rahayu. - 1st ed. 2021. - XVIII, 635 p. 381 illus., 262 illus. in color.online resource. - Data-Centric Systems and Applications,2197-974X. - Data-Centric Systems and Applications,.

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.

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.

ISBN: 9783030819798

Standard No.: 10.1007/978-3-030-81979-8doiSubjects--Topical Terms:

1366136
Data Analysis and Big Data.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Data Warehousing and Analytics = Fueling the Data Engine /
LDR:03964nam a22003975i 4500 001 1059881
003 DE-He213
005 20220330131405.0
007 cr nn 008mamaa
008 220414s2021 sz | s |||| 0|eng d
020 $a 9783030819798 $9 978-3-030-81979-8
024 7 $a 10.1007/978-3-030-81979-8 $2 doi
035 $a 978-3-030-81979-8
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Taniar, David. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 559387
245 1 0 $a Data Warehousing and Analytics $h [electronic resource] : $b Fueling the Data Engine / $c by David Taniar, Wenny Rahayu.
250 $a 1st ed. 2021.
264 1 $a Cham : $b Springer International Publishing : $b Imprint: Springer, $c 2021.
300 $a XVIII, 635 p. 381 illus., 262 illus. in color. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
490 1 $a Data-Centric Systems and Applications, $x 2197-974X
505 0 $a 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.
520 $a 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.
650 2 4 $a Data Analysis and Big Data. $3 1366136
650 0 $a Database management. $3 557799
650 0 $a Big data. $3 981821
650 0 $a Quantitative research. $3 635913
650 0 $a Information storage and retrieval systems. $3 561170
650 1 4 $a Database Management. $3 669820
650 2 4 $a Big Data. $3 1017136
650 2 4 $a Information Storage and Retrieval. $3 593926
700 1 $a Rahayu, Wenny. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1078107
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9783030819781
776 0 8 $i Printed edition: $z 9783030819804
830 0 $a Data-Centric Systems and Applications, $x 2197-9723 $3 1253989
856 4 0 $u https://doi.org/10.1007/978-3-030-81979-8
912 $a ZDB-2-SCS
912 $a ZDB-2-SXCS
950 $a Computer Science (SpringerNature-11645)
950 $a Computer Science (R0) (SpringerNature-43710)