Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance

Mastering Data Warehouse Aggregates

This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance

Mastering Data Warehouse Aggregates

Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover begininning to advanced-level material Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Mastering Data Warehouse Design

Relational and Dimensional Techniques

Mastering Data Warehouse Design

A cutting-edge response to Ralph Kimball's challenge to thedata warehouse community that answers some tough questions aboutthe effectiveness of the relational approach to datawarehousing Written by one of the best-known exponents of the Bill Inmonapproach to data warehousing Addresses head-on the tough issues raised by Kimball andexplains how to choose the best modeling technique for solvingcommon data warehouse design problems Weighs the pros and cons of relational vs. dimensional modelingtechniques Focuses on tough modeling problems, including creating andmaintaining keys and modeling calendars, hierarchies, transactions,and data quality

Agile Data Warehouse Design

Collaborative Dimensional Modeling, from Whiteboard to Star Schema

Agile Data Warehouse Design

Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling ] brainstorming) with BI stakeholders. This book describes BEAM, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team. BEAM provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and entity relationship based tools and model interactively with their colleagues. The result is everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional modeling solutions. Business stakeholders feel ownership of the data warehouse they have created, and can already imagine how they will use it to answer their business questions. Within this book, you will learn: Agile dimensional modeling using Business Event Analysis & Modeling (BEAM ) Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun! Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how) Modeling by example not abstraction; using data story themes, not crow's feet, to describe detail Storyboarding the data warehouse to discover conformed dimensions and plan iterative development Visual modeling: sketching timelines, charts and grids to model complex process measurement - simply Agile design documentation: enhancing star schemas with BEAM dimensional shorthand notation Solving difficult DW/BI performance and usability problems with proven dimensional design patterns LawrenceCorr is a data warehouse designer and educator. As Principal of DecisionOne Consulting, he helps clients to review and simplify their data warehouse designs, and advises vendors on visual data modeling techniques. He regularly teaches agile dimensional modeling courses worldwide and has taught dimensional DW/BI skills to thousands of students. Jim Stagnitto is a data warehouse and master data management architect specializing in the healthcare, financial services, and information service industries. He is the founder of the data warehousing and data mining consulting firm Llumino.

The Microsoft Data Warehouse Toolkit

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

The Microsoft Data Warehouse Toolkit

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance. Features more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release Includes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.

Mastering the SAP Business Information Warehouse

Leveraging the Business Intelligence Capabilities of SAP NetWeaver

Mastering the SAP Business Information Warehouse

"This book is the definitive guide for SAP NetWeaver BI professionals. Based on their extraordinary expertise with the product, the authors provide deep insights about key innovations in the areas of user experience, query performance, integrated planning, and enterprise-wide data warehousing." —Stefan Sigg, Vice President, SAP NetWeaver Business Intelligence The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance. This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security. With more than 50 percent new or revised material, this second edition of Mastering the SAP Business Information Warehouse shows you how to: Extract data from online transaction processing systems Store transformed data in a way that best supports reporting and analysis Use the various Business Explorer tools such as BEx Report Designer, BEx Analyzer, BEx Broadcaster, and BEx Web Application Designer Schedule, monitor, troubleshoot, and archive data loads The companion Web site contains sample chapters in Wiki format and the authors' blog where readers may enter discussions about the book and SAP. Wiley Technology Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/mcdonald The companion Web site contains the sample code presented in the text of the book, plus implementation templates.

Mastering R for Quantitative Finance

Mastering R for Quantitative Finance

This book is intended for those who want to learn how to use R's capabilities to build models in quantitative finance at a more advanced level. If you wish to perfectly take up the rhythm of the chapters, you need to be at an intermediate level in quantitative finance and you also need to have a reasonable knowledge of R.

Decision Support in the Data Warehouse

Decision Support in the Data Warehouse

Most data warehousing books provide little information about the applications or tools that deliver the business value that the data warehouse provides. The title includes a comprehensive survey of tools and technologies available today. This book explores decision support in a data warehousing environment. Focus is on building front-end decision support systems.

Mastering Elasticsearch 5.x

Mastering Elasticsearch 5.x

Master the intricacies of Elasticsearch 5 and use it to create flexible and scalable search solutions About This Book Master the searching, indexing, and aggregation features in ElasticSearch Improve users' search experience with Elasticsearch's functionalities and develop your own Elasticsearch plugins A comprehensive, step-by-step guide to master the intricacies of ElasticSearch with ease Who This Book Is For If you have some prior working experience with Elasticsearch and want to take your knowledge to the next level, this book will be the perfect resource for you.If you are a developer who wants to implement scalable search solutions with Elasticsearch, this book will also help you. Some basic knowledge of the query DSL and data indexing is required to make the best use of this book. What You Will Learn Understand Apache Lucene and Elasticsearch 5's design and architecture Use and configure the new and improved default text scoring mechanism in Apache Lucene 6 Know how to overcome the pitfalls while handling relational data in Elasticsearch Learn about choosing the right queries according to the use cases and master the scripting module including new default scripting language, painlessly Explore the right way of scaling production clusters to improve the performance of Elasticsearch Master the searching, indexing, and aggregation features in Elasticsearch Develop your own Elasticsearch plugins to extend the functionalities of Elasticsearch In Detail Elasticsearch is a modern, fast, distributed, scalable, fault tolerant, and open source search and analytics engine. Elasticsearch leverages the capabilities of Apache Lucene, and provides a new level of control over how you can index and search even huge sets of data. This book will give you a brief recap of the basics and also introduce you to the new features of Elasticsearch 5. We will guide you through the intermediate and advanced functionalities of Elasticsearch, such as querying, indexing, searching, and modifying data. We'll also explore advanced concepts, including aggregation, index control, sharding, replication, and clustering. We'll show you the modules of monitoring and administration available in Elasticsearch, and will also cover backup and recovery. You will get an understanding of how you can scale your Elasticsearch cluster to contextualize it and improve its performance. We'll also show you how you can create your own analysis plugin in Elasticsearch. By the end of the book, you will have all the knowledge necessary to master Elasticsearch and put it to efficient use. Style and approach This comprehensive guide covers intermediate and advanced concepts in Elasticsearch as well as their implementation. An easy-to-follow approach means you'll be able to master even advanced querying, searching, and administration tasks with ease.