Business Intelligence

Business Intelligence

by Michael Luckevich, Elizabeth Vitt



Product Details

ISBN-13: 9780735616271
Publisher: Microsoft Press
Publication date: 04/24/2002
Series: CPG Series
Pages: 224
Product dimensions: 6.60(w) x 9.50(h) x 0.91(d)

About the Author

Elizabeth Vitt, a manager at Aspirity, has six years of business development, project management, consulting, and training experience in business intelligence. Her industry experience includes implementations in retail, manufacturing, and healthcare. She has specialized expertise as an educator in data-warehousing design and implementation and is an author of the Microsoft® Official Curricula (MOC) for Microsoft's business intelligence product offerings. Elizabeth is also a frequent speaker at SQL Server™ conferences worldwide. She earned a B.S. in environmental engineering from Northwestern University in Evanston, IL.

Michael Luckevich, the CEO of Aspirity, has 18 years of information technology and business intelligence experience. He has extensive experience in the architecture, design, development, and implementation of complex business intelligence solutions. He frequently teaches classes and offers seminars on various topics relating to business intelligence, data warehousing, and OLAP technologies. Michael is a graduate of the University of Waterloo Faculty of Mathematics.

Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server®, including Microsoft SQL Server 2005 Reporting Services Step by Step. She is also the coauthor of Microsoft® SQL Server 2005 Administrator's Companion.

Table of Contents

About the Authorsvii
Our Assumptions About Youxiii
Organization of the Bookxiv
Part IBusiness Intelligence Foundations1
Prologue: The Mystery on Lovesick Lake3
1Understanding Business Intelligence13
Describing Business Intelligence13
Defining the BI Cycle17
Enabling Business Intelligence23
2Bridging the Analysis Gap29
Multidimensional Analysis29
Operational Systems31
Business Intelligence Systems34
3Defining BI Technologies49
The High-Level View49
Reporting and Analysis53
The Data Warehouse60
Part IIBusiness Intelligence Case Studies65
4Improving Operational Efficiency--Audi AG67
Company Background67
Business Requirements68
The Solution70
Solution Benefits71
Future Plans72
5Maximizing Profitability--The Frank Russell Company75
Company Background75
Business Requirements76
The Picasso Solution78
The Einstein Solution: Building on Success81
6Impacting the Bottom Line--CompUSA Inc85
Company Background85
Business Requirements86
The Solution88
Solution Benefits90
Project Challenges92
Lessons Learned93
Future Plans93
7Keeping Customers Loyal--Disco S.A.95
Company Background95
Business Requirements96
The Solution97
Solution Benefits100
Project Challenges101
8Managing Seasonal Variability--Cascade Designs103
Company Background104
Business Requirements105
The Solution107
Solution Benefits108
Lessons Learned109
Future Plans110
Part IIIA Business Intelligence Roadmap111
9Identifying BI Opportunities113
Doing Your Homework113
Sharing and Collecting Ideas122
Evaluating Alternatives128
10Implementing a BI Solution145
An Implementation Strategy145
The Fundamental Decisions151
Appendix AMicrosoft Data Warehousing Framework177
SQL Server177
Data Analyzer181
Microsoft Business Intelligence Accelerator182
Data Warehousing Alliance184

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews