Скачать книгу - Warehouse

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.

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Kick up your training sessions a notch! If you want to make group learning more fun and effective, this is the resource for you. Training expert Elaine Biech, author of Training for Dummies, challenged some of the world’s best game designers to create never-before-seen games using popular training toys and tools from Trainer’s Warehouse, the nation’s leading supplier of learning resources. Whether you’re a full-time workplace learning professional or occasional trainer, this collection contains the most ingenious and inventive collections of learning games. The collection uses a host of common and readily available tools and toys, from throwables and tactiles, to white boards on a stick and noise-making boomwackers. This book will appeal to anyone who delivers training and education—and presenters, too—the games run the gamut from short energizers, icebreakers and closers, to more involved group and team-building activities.

Warehouses are often seen as a necessary evil: places that stop the flow of goods and thus increase costs without adding value. But the truth is that they have a critical part to play in supply chain management, and warehouse managers should be centrally involved in the strategic aspects of any business. Excellence in Warehouse Management covers everything you need to know to manage warehouse operations as part of a streamlined and holistic system, fine-tuned to serve the customer and drive the bottom-line. With thinking points, self-assessment exercises and case studies Stuart Emmett challenges you to consider your own operations in a new way, and plot a course into the future.

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