Delivering Business Intelligence with Microsoft SQL Server 2008: Edition 2

Brian Larson

Dec 2008 · McGraw Hill Professional

About this ebook

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

Ratings and reviews

This is an excellent book. From the start, you will find yourself in awe over the volume of information you are absorbing and skills you are acquiring. Regardless of your perspetive, you will be pleased with your investment of time and effort toward the ambitious goals set by the author. And Brian Larson has an comfortable, easy-flowing style that keeps you involved through the detail and complexity. Unfortunately, this book is also seriously flawed. Let me attempt to explain. . First, understand that the book targets a wide audience. Depending on your objectives, you may find the book complete or completely lacking. BI covers a broad range. This book offers an introduction and takes you to the next level. Experienced BI pros will probably find the level too light. Brian covers BI from beginning to end, with narritave and exercises titled "Learn by Doing" The hands on exercises comprise about 1/3 of the book and there lie the book flaws. . I'm incredibly curious to know how many of this book's 5-star reviewers actually completed all the exercises. For me, much of the satisfaction from the book came from realizing the fruits of my efforts working through the exercises. And this book requires a focused effort to work through all the "learn by doing" exercises. For the novice like me, it's an effort richly rewarded--if you can get there. . I took on the challenge and, like any good analyst, figured out the problems with the data and Brian's instructions. It can be done, but I'm left with a sense of letdown from the author and publisher. At the very least, these problems could be noted in the errata. There are quite a few problems and unless you figure them out, your hands on efforts will be rewarded with a Visual Studio result of: #value! . If your goal is to "learn by doing" you might be terribly disappointed. The book's errors present a significant hurdle to a successful learning experience. Note that most of the exercises work just fine. Its just that one exercise failure and the end result, a working cube, might very well elude you. More on this later... . With that said, this book has a tremendous amount to offer. Regardless of your perspective, the numerous examples offer a wonderful insight into cube creation, data mining and business intellligence. The examples are understandably simple and straightforward and will appeal to a broad audience. Still, they provide a tangible insight to the software's capabilities. The book does not pretend to serve as a comprehensive list of functions and syntax. For someone experienced with Visual Studio, the first half of the book may be review. The later chapters dig deeply into data mining, reporting and working with Excel... . The data mining section of the book delivers on a grand scale. It does use one of the cubes developed earlier in the book. However, a backup, completed cube can be downloaded and installed. If your objective centers on mining (~1/3 of the book) you can (with some effort) build and install a ready-made cube to work with throught the final exercises. Installing the ready-made cube isn't bullet-proof either, however. For content and style; 5 stars. For problem riddled exercises, 2-stars. Hope this helps, good luck. . FYI I am an alalyst by trade. Good with Excel, ok with Access. I've never seen Visual Studio before starting this project. To learn BI, I bought this book, SQL Server 2008 Developer, downloaded a Demo version of Windows Server 2008 ~$100. I borrowed an old IT server, formatted the drive, installed software and got to work. I am comfortable that I know enough to build cubes, begin mining the data and delivering reports. The project has taken 10 days (and a couple of late nights :-)

AAA

About the author

Brian Larson (Arden Hills, MN) served as a contract member of the Reporting Services development team and contributed to the code base. He has contributed to SQL Server Magazine and is the Chief of Technology for Superior Consulting Services. With over 18 years of experience in the computer industry, and 14 years as a software development consultant, Brian is an MCSD as well as an MCDBA, and has authored and delivered training curriculum for SQL Server 2000 and C#.NET as well as numerous custom applications.