Clickstream Data Warehousing is a great read for the serious data warehouse designer grappling with the clickstream data source. With a clear, almost conversational style, the authors explain the intricacies of this fascinating and important source of customer behavior data. They combine engineering knowledge of the clickstream with state-of-the-art dimensional data warehouse design techniques to produce a very useful book.
Ralph Kimball, President, Ralph Kimball Associates
Mark Sweiger and his co-authors have created a foundation and architecture for profiting from all of the clickstream data produced in an e-business environment. The proliferation of clickstream data requires the ability to capture this data in a data warehouse to ensure that the needs of your customers are being satisfied. They begin by characterizing a typical e-business architecture and explain how it can be fortified by the creation of a clickstream data warehouse. This book is a must read for corporations that have a tremendous investment in their e-business infrastructure and are trying to increase their ROI.
Ron Powell, Publisher and Editorial Director, DM Review
This book is a model for how implementation guides should be written. Building on the proven foundation of Dr. Ralph Kimballs Toolkit books, Mark Sweiger and his co-authors drill down into the real-world complexities of Web data and e-business. What makes this book especially powerful is its combination of breadth and depth. The first part gives us a detailed understanding of the complexities of the Web and the massive amounts of data it generates. The second part offers up the full Clickstream Data Warehouse implementation lifecycle, from project setup and requirements gathering all the way through to analysis and reporting. The ETL chapter alone is worth the price of the book.
Mark Sweiger was wrestling with the Clickstream beast long before I met him in 1998. Mark and his co-authors have pulled all their experience, examples, tips and techniques into one place for our benefit. If you are responsible for implementing a Clickstream Data Warehouse, this book is the closest thing you can get to an insurance policy for success.
Warren Thornthwaite, Founding Partner, InfoDynamics, LLC
The clickstream data warehouse is among the most important assets of any modern, competitive business. But unfortunately, the lack of available, actionable information about planning, developing, deploying, and managing this still relatively exotic asset - to say nothing of the challenges involved in maximizing its business value - can raise uncertainties that will intimidate the most experienced data warehousing and application development teams. In their new book, Mark Sweiger, Mark Madsen, Jimmy Langston, and Howard Lombard pick up where Ralph Kimball and Richard Merzs groundbreaking work The Data Webhouse Toolkit left off. They provide detailed, hands-on advice about every aspect of the clickstream data warehousing continuum--from architecture, to data sources, to user-identity tracking, to project management, to infrastructure. Clickstream Data Warehousing could become the classic handbook on the subject.
Justin Kestelyn, Editor-in-Chief, Intelligent Enterprise
This book comprehensively covers the process required to ensure that companies receive the greatest possible benefit from their Web site clickstream data. The insight to be gained by properly capturing and analyzing clickstream data can easily spell competitive advantage for companies that implement a clickstream data warehouse. In addition to describing all architectural components required for a clickstream data warehouse, this book also provides advice for designing a Web site so that the most advantageous clickstream data will be available for analysis. As an aid for those beginning the process or as a reference for those already building a clickstream data warehouse, this book will be the only non-software tool they need.
Jean Schauer, Editor-in-Chief, DM Review
Clickstream Data Warehousing should be read by everyone working with E-commerce data. It provides in one place a welcome reference that not only illuminates the potential pitfalls of building data warehouses from web data, but also suggests some good solutions. It is sufficiently technical to be of help to an audience of practitioners, while clear and concise enough to be of use to their managers. It is a welcome addition to my bookshelf.
Herb Edelstein, President, Two Crows Corporation
If you are wondering how to avoid repeating the failure of many dot coms, you must read this book. Successful business management requires good business intelligence, and building a clickstream data warehouse is the only way to obtain actionable business intelligence in an e-business environment.
Elizabeth Schaedler, Enterprise Systems Business Development Manager, Sun Microsystems
If you are a practitioner who is considering or is currently engaged in a clickstream data warehouse project, the knowledge you need is in this book. The subject matter is presented in logical steps with each chapter building on the next, enabling the reader to mentally construct a picture of clickstream data warehouse architecture, its components, project best practices, and success factors. The direct and understandable treatment of Web architecture, Web transactions and what should happen behind the scenes to capture, organize, and use valuable clickstream data is extremely useful to those who are new to data warehousing as well as those who have more experience. And the numerous how-to examples and suggestions have the detail required to address many of the difficult technical problems encountered when implementing a clickstream data warehouse.
John Gensler, Senior Consultant, KPMG Consulting, Inc.
This book provides the reader with practical guidance on how to address specific challenges facing project teams who are working on clickstream data warehouses. It offers the overall context and, more importantly, the details that the project team needs to know. Web developers should read this book to understand what data the business really needs and why the data warehouse team keeps asking for more.
Laura L. Reeves, Principal, StarSoft Solutons, Inc.
Any data warehousing professional that needs to get a firm handle on how to deliver an effective clickstream data warehouse will find this book to be an excellent guide through the technical maze of the website clickstream. Rather than introducing their own data warehousing vernacular, the authors embrace the by now familiar knowledge base of dimensional data modeling and warehouse development practices to serve as the foundation for delivering an effective clickstream solution.
Bob Becker, Vice President, DecisionWorks Consulting, Inc.
Clickstream Data Warehousing builds on the data warehousing concepts introduced in the past few years, adding the critical data elements that today's marketers are so hungry for - the clicks. Some of us may fondly remember the days when we could take weekly data extracts from our transaction systems and provide all the decision support needed to run the business. Like it or not, those days are gone forever; business managers are demanding a view of data accumulating in web logs at a furious pace. The authors do a terrific job of introducing the new concepts, re-visiting the tried and true, and exploring solutions in great depth. Highly recommended.
Dave Stauffer, Director of Site Development
This book takes traditional data warehousing into a whole new dimension. If your business has a Web presence and your serious about success then this is a must read. It is designed for literally everyone involved in a data warehousing development project and provides you with the nuts and bolts from A to Z for a successful implementation. Im really looking forward in anticipation to putting my new found knowledge to work on our very next project!
Curtis McClendon, Oracle Team Manager, Qwest Cyber.Solutions Inc.
Clickstream Data Warehousing adds new web dimensions to traditional data warehousing, enabling analysts to track and forecast customer behavior in addition to product sales and promotions.
Gary Hallmark, Architect, Oracle Corporation
|