How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Ralph Kimball, Margy Ross
Ralph Kimball invented a data warehousing technique called ?dimensional modelling? and popularised it in his first Wiley bestseller The Data Warehouse Toolkit. Since then dimensional modelling has become the most widely accepted technique for data warehouse design. Since the first edition, Kimball has improved on his earlier techniques and created many new ones. In this second edition, he provides a comprehensive collection of all of them, from basic to advanced, and strategies for optimising data warehouse design for common business applications. He includes examples for retail sales, inventory management, procurement, orders and invoices, customer relationship management, accounting, financial services, telecommunication and utilities, health care, insurance and more. He also presents unique modelling techniques for e-commerce and shows strategies for optimising performance. A companion Web site provides updates on dimensional modelling techniques, links to related sites and source code where appropriate.
". . . one of the definitive books of our industry. If you take the time to read only one professional book, make it this book." -W. H. Inmon One of the most dramatic new developments in database design, the dimensional data warehouse is a powerful database model that.significantly enhances managers' ability to quickly analyze large, multidimensional data sets. Written by the leading proponent of this revolutionary new approach, this valuable book/CD toolkit outfits you with all the nuts-and-bolts information you need to design, build, manage, and use dimensional data warehouses for virtually any type of business application, as well as software for querying dimensional data warehouses. Employing many real-life case studies of data warehouses, Ralph Kimball provides clear-cut guidelines on how to model data and design data warehouses to support advanced multidimensional decision support systems. Beginning with the relatively simple example of a data warehouse for a grocery store, he progresses, step-by-step, through an increasingly complex array of business applications in retail, manufacturing, banking, insurance, subscriptions, and airline reservations. By the end of the book, you will have mastered the full range of powerful techniques for creating, controlling, and navigating dimensional business databases that are easy to understand and navigate. On the CD-ROM you'll find: * Software for querying dimensional data warehouses. * Working models of all the databases described in the book.
Joy Mundy, Warren Thornthwaite, Ralph Kimball
The authors provide comprehensive coverage of the complete suite of Microsoft's data warehousing tools. Offering examples implemented in Microsoft's Business Intelligence toolset, this book is structured around the major phases of a data warehouse project plan: design, development, deployment, and maintainence.
Ralph Kimball, Joe Caserta
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
Ralph Kimball, Margy Ross
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the foundation on which the data warehousing industry has been built - and now, these books are considered the most authoritative guides on dimensional modeling. This new third edition is a complete library of dimensional modeling techniques, the most comprehensive collection ever. Revised and updated, it covers design techniques that support big data analytics, adds a new chapter on ETL techniques, provides new and enhanced modeling patterns, and much more. Authored by Ralph Kimball, known worldwide as an innovator, consultant, and influential thought leader in the field of data warehousing Begins with fundamental design recommendations and progresses step by step through increasingly complex scenarios Presents unique modeling techniques for e-commerce and common business applications such as inventory management, procurement, invoicing, accounting, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, health care, and insurance Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 3rd Edition .
The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.
Jamie MacLennan, ZhaoHui Tang, Bogdan Crivat
Understand how to use the new features of Microsoft SQL Server 2008 for data mining by using the tools in Data Mining with Microsoft SQL Server 2008, which will show you how to use the SQL Server Data Mining Toolset with Office 2007 to mine and analyze data. Explore each of the major data mining algorithms, including naive bayes, decision trees, time series, clustering, association rules, and neural networks. Learn more about topics like mining OLAP databases, data mining with SQL Server Integration Services 2008, and using Microsoft data mining to solve business analysis problems.
Scott Cameron, Hitachi Consulting
Provides information on the fundamentals of Microsoft SQL Server 2008 Analysis Services, covering such topics as using MDX, desiging OLAP cubes, retreiving data and creating reports, and managing databases.
Sivakumar Harinath, Robert Zare, Matt Carroll, Sethu Meenakshisundaram, Denny Guang-Yeu Lee
Describes how to build data warehouses and multidimensional databases using Microsoft Analysis Services.
John Christian Hancock, Roger Toren
Describes how to use SQL Server 2005 to solve a variety of business intelligence problems.
Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008--whether you're new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you'll master the concepts, tools, and techniques for building solutions that deliver intelligence--and business value--exactly where users want it. Discover how to: Manage the development life cycle and build a BI team Dig into SQL Server Analysis Services, Integration Services, and Reporting Services Navigate the Business Intelligence Development Studio (BIDS) Write queries that rank, sort, and drill down on sales data Develop extract, transform, and load (ETL) solutions Add a source code control system Help secure packages for deployment via encryption and credentials Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models Create and implement custom objects using .NET code View reports in Microsoft Office Excel and Office SharePoint Serverook
Maximize the Business Intelligence Tools in Microsoft SQL Server 2008 Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization. Understand the goals and benefits of business intelligence Design and create relational data marts and OLAP cubes Manage Analysis Services databases using BI Development Studio Cleanse data and populate data marts with SQL Server Integration Services Take advantage of the flexibility of the Unified Dimensional Model Manipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clustering Develop and distribute interactive reports with SQL Server 2008 Reporting Services Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services.