- Shopping Bag ( 0 items )
Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. Its a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, ...
Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. Its a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages.
SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? Thats what this book is all about. Authors Guy Fouché and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft business intelligence toolkit. Youll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server.
If youre an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you cant afford to be without this book; you cant afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal.
Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts.
Posted April 19, 2011
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.
1 out of 1 people found this review helpful.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.