Analytical Puzzle de David Haertzen

Analytical Puzzle: Profitable Data Warehousing, Business Intelligence & Analytics

David Haertzen

en Limba Engleză Paperback – 18 oct 2012

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 organisation. 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 visualisation and mobile devices. This book describes an unbiased, practical, and comprehensive approach to building a data warehouse which will lead to an increased level of business intelligence within your organisation. 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 visualisation and mobile devices.

Citește tot Restrânge

Cuprins

Develop a foundational knowledge of data warehousing, business intelligence & analytics; Build the business case needed to sell your data warehousing project, & then produce a project plan that avoids common pitfalls ; Elicit & organize business intelligence & data warehousing business requirements; Specify the technical architecture of the data warehousing system, including software & infrastructure components, technology stack, & non-functional requirements. Gain an understanding of cloud based data warehousing & data warehouse appliances; Learn about data attributes including metrics & key performance indicators (KPIs), the raw material of data warehousing & business intelligence; Learn about data modeling & how to apply design patterns for each part of the data warehouse; Speak the dimensional modeling language of measures, dimensions, facts, cubes, stars, & snowflakes; Organize a successful data governance program. Learn how to manage metadata for your data warehousing & business intelligence project; Identify useful data sources & implement a data quality program; Use database technology for your data warehousing project, & understand the impact of data warehouse appliances, big data, in memory databases, columnar databases & OnLine Analytical Processing (OLAP); Apply data integration & understand the role data mapping, data cleansing, data transformation, & loading data play in a successful data warehouse; Use the business intelligence (BI) operations of slice, dice, drill down, roll up, & pivot to analyze & present data; Learn about descriptive & predictive statistics, & calculate mean, median, mode, variance & standard deviation; Harness analytical methods such as regression analysis, data mining, & statistics to make profitable decisions & anticipate the future; Appreciate the components & design patterns that compose a successful analytic application; Gain an understanding of the uses & benefits of scorecards & dashboards including support of mobile device users; Gain insight into applications of business intelligence that could profit your organization, including risk management, finance, marketing, government, healthcare, science & sports; Perform customer analytics to better understand & segment your customers; Test, roll out, & sustain the data warehouse.