The Data Warehouse Lifecycle Toolkit

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.

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.

Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

An evidence-based organizational framework for exceptional analytics team results The Analytics Lifecycle Toolkit provides managers with a practical manual for integrating data management and analytic technologies into their organization. Author Gregory Nelson has encountered hundreds of unique perspectives on analytics optimization from across industries; over the years, successful strategies have proven to share certain practices, skillsets, expertise, and structural traits. In this book, he details the concepts, people and processes that contribute to exemplary results, and shares an organizational framework for analytics team functions and roles. By merging analytic culture with data and technology strategies, this framework creates understanding for analytics leaders and a toolbox for practitioners. Focused on team effectiveness and the design thinking surrounding product creation, the framework is illustrated by real-world case studies to show how effective analytics team leadership works on the ground. Tools and templates include best practices for process improvement, workforce enablement, and leadership support, while guidance includes both conceptual discussion of the analytics life cycle and detailed process descriptions. Readers will be equipped to: Master fundamental concepts and practices of the analytics life cycle Understand the knowledge domains and best practices for each stage Delve into the details of analytical team processes and process optimization Utilize a robust toolkit designed to support analytic team effectiveness The analytics life cycle includes a diverse set of considerations involving the people, processes, culture, data, and technology, and managers needing stellar analytics performance must understand their unique role in the process of winnowing the big picture down to meaningful action. The Analytics Lifecycle Toolkit provides expert perspective and much-needed insight to managers, while providing practitioners with a new set of tools for optimizing results.

The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects Covers advanced topics, including data monitoring and testing Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

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

Step by step, Facilitating the Project Lifecycle guides the project manager/facilitator in making smart choices about when and how to pull key talent together to spell success for the project and ultimately the organization. The authors will help you understand the benefits of using facilitated group work sessions to get real work done during a project and get it done better and more efficiently than more traditional individual work approaches. In addition, the book includes: Recommendations for capitalizing on group knowledge to accelerate the building of key project deliverables and ensure their quality as they are built A work session structure for planning, delivering, and following up facilitated work sessions Guides for building key project deliverables Sample agendas Proven techniques for managing the group dynamics

A high-level, informal look at the different stages of the predictive analytics cycle Understanding the Predictive Analytics Lifecycle covers each phase of the development of a predictive analytics initiative. Through the use of illuminating case studies across a range of industries that include banking, megaresorts, mobile operators, healthcare, manufacturing, and retail, the book successfully illustrates each phase of the predictive analytics cycle to create a playbook for future projects. Predictive business analytics involves a wide variety of inputs that include individuals' skills, technologies, tools, and processes. To create a successful analytics program or project to gain forward-looking insight into making business decisions and actions, all of these factors must properly align. The book focuses on developing new insights and understanding business performance based on extensive use of data, statistical and quantitative analysis, explanatory and predictive modeling, and fact-based management as input for human decisions. The book includes: An overview of all relevant phases: design, prepare, explore, model, communicate, and measure Coverage of the stages of the predictive analytics cycle across different industries and countries A chapter dedicated to each of the phases of the development of a predictive initiative A comprehensive overview of the entire analytic process lifecycle If you're an executive looking to understand the predictive analytics lifecycle, this is a must-read resource and reference guide.

This publication focuses on the critical methods that can be used to dramatically improve the fiscal closing process. The Record to Report (R2R) or Fiscal Closing Process is at the core of the controllership function. The process includes transaction processing, internal and external reporting, and the internal controls—the people, processes, and technology—that constitute the corporate organizational hierarchy. CFOs, controllers, and corporate finance departments require timely, accurate, and consistent data to make appropriate operational and strategic decisions and fulfill statutory, regulatory, and compliance requirements with accurate and timely data. The Fast Close Toolkit offers both strategic and tactical suggestions that can significantly improve the fiscal closing process and provides guidance on new legislation requirements, systems and best practice processes. Checklists, templates, process narratives, and sample policies are provided for every component of the fiscal close. Investors and shareholders expect fast and easy access to the data created by current business activities in the information-driven digital age. The Fast Close Toolkit provides the necessary tools and expert advice to improve the fiscal closing process. Authoritative and up to date, this book: Identifies the bottlenecks that can impact the and improvethe fiscal close process and provides best practices to help alleviate these challenges Defines the Record to Report (R2R) and recommends the roles and responsibilities for fiscal close processes flow Offers the internal controls to use for the end-to-end fiscal close process Describes approaches for risk management, R2R, and fiscal close benchmarking Identifies KPIs for all aspects of the R2R process Provides the mechanism for developing a financial close scorecard Recommends leading practices for both external and internal reporting Provides guidance on how strategic planning, the budget and forecast processes can be streamlined to enhance the fiscal close and internal reporting results Written by a respected expert on internal controls and the fiscal closing process, The Fast Close Toolkit is a valuable source of information for professionals involved in controllership and have responsibility for the fiscal close.

Discover the 10 best Coaching practices for solving problems and implementing change with clients–right away Coaching works, there's no doubt about that. But the coaching industry is going through tremendous change that all professional coaches need to address. Equipping coaching professionals to stay on the cutting-edge of their craft, The Business Coaching Toolkit: Top 10 Strategies for Solving the Toughest Dilemmas Facing Organizations expertly provides a collection of application-based, proven tools that present creative solutions to common situations encountered in today's workplace. This hands-on guide creatively empowers professionals to: * Achieve greater performance by identifying and maximizing strengths and managing weaknesses * Lead their team or client through setting specific, measurable, and reasonable goals * Discover the deeper meaning of vision and tie goals into the client's core values * Guide clients through a comprehensive analysis of their current situation–the good, the bad, and the ugly Whether it's increasing a client's time management skills, giving feedback to an employee, or building a leadership team, The Business Coaching Toolkit presents a valuable supply of straightforward exercises designed to bring a new dimension to every coaching professional's work with clients.