The Analytical Puzzle: Profitable Data Warehousing, Business Intelligence and Analytics

Book Description

Do you enjoy completing puzzles? Perhaps one of the most challenging (yet rewarding) puzzles is delivering a successful data warehouse suitable for data mining and analytics. The Analytical Puzzle describes an unbiased, practical, and comprehensive approach to building a data warehouse which will lead to an increased level of business intelligence within your organization. New technologies continuously impact this approach and therefore this book explains how to leverage big data, cloud computing, data warehouse appliances, data mining, predictive analytics, data visualization and mobile devices.

Here are the main objectives for each of the book's 19 chapters:

Chapter 1: Develop a foundational knowledge of data warehousing, business intelligence and analytics

Chapter 2: Build the business case needed to sell your data warehousing project, and then produce a project plan that avoids common pitfalls

Chapter 3: Elicit and organize business intelligence and data warehousing business requirements

Chapter 4: Specify the technical architecture of the data warehousing system, including software and infrastructure components, technology stack, and non-functional requirements. Gain an understanding of cloud based data warehousing and data warehouse appliances

Chapter 5: Learn about data attributes including metrics and key performance indicators (KPIs), the raw material of data warehousing and business intelligence

Chapter 6: Learn about data modeling and how to apply design patterns for each part of the data warehouse