Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence

by Guy Fouche, Lynn Langit

Paperback(2nd ed.)

$44.99 $49.99 Save 10% Current price is $44.99, Original price is $49.99. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Monday, January 28

Product Details

ISBN-13: 9781430233244
Publisher: Apress
Publication date: 04/01/2011
Edition description: 2nd ed.
Pages: 448
Product dimensions: 7.50(w) x 9.10(h) x 1.10(d)

About the Author

Guy Fouch is a business intelligence and decision support system consultant in the Dallas, Texas area. Guy spends his evenings playing one of his eight trumpets and expanding his composition skills using the current generation of music technologies. On the weekend, he puts as many miles as he can on his bright yellow Honda F4i sport motorcycle. Guy and Jodi enjoy taking nine-day trips in their Jeep 4x4, taking photographs and writing travelogs along the way. You can view their photography at http://photography.fouche.ws.

Table of Contents

  1. What Is Business Intelligence?
  2. OLAP Modeling Concepts
  3. Introducing OLAP Modeling with SSAS
  4. Intermediate OLAP Modeling with SSAS
  5. Advanced OLAP Modeling with SSAS
  6. Cube Storage and Aggregation
  7. Introducing SSIS
  8. Intermediate SSIS
  9. Advanced SSIS
  10. Reporting Tools
  11. Data Mining with Excel
  12. Introducing PowerPivot
  13. Introduction to MDX
  14. Introduction to Data Mining

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Foundations of SQL Server 2008 R2 Business Intelligence 4 out of 5 based on 0 ratings. 1 reviews.
MIRZA-BAIG More than 1 year ago
It is always a joy reading books from APRESS mostly because the authors are subject matter experts and offer hands-on expertise. The content is helpful and well laid out from ground up for anyone who needs to know about SQL Server 2008 R2 from a BI perspective. The first five chapters lay framework to an understanding of schemas, dimensions and modeling theory. The book offers thorough insight of star, snow flake schemas, Slow Changing (SCD) Dimensions, Rapid Changing (RCD) Dimensions, KPIs, Calculated and Derived Measures. The authors do a good job with listing examples using the AdventureWorks database which is accessible to everyone with ample screen shots to make it a step-by-step guide. The middle section of this book talks in detail about designing and deploying SSIS, SSAS packages to support enterprise ETL processes, types of data transformation techniques along with pros and cons of each storage model. SSIS has been covered in detail spanning three chapters with everything needed to implement it including industry's state of the art logging and security standards. Lastly, the book delves into data mining, reporting (SSRS) services concepts and using MDX/DMX to query cube information that's created based on the principles laid out in earlier chapters and illustrates use of traditional pivot tables and new "Power Pivot" feature within Microsoft Excel 2010 available as a free plug-in and offers tight integration with SQL Server 2008 R2 data mining capabilities. I will highly recommend it to anyone looking to get up and running quickly or exploring BI offering from Microsoft having read most of the "SQL Server Online Books" as it's one of the good "foundation" books available in market I have run into that blends field experience in an easy to digest format.