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. It.s 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? That.s 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. You.ll 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 you.re an analyst or developer working with SQL Server 2008 who is
charged with delivering results that drive business success, you can.t
afford to be without this book; you can.t afford to ignore the powerful
business intelligence suite that Microsoft has placed at your disposal.
* Provides the .big picture. of Microsoft.s BI tool suite
* Covers PowerPivot and other game-changing technologies introduced
alongside SQL Server 2008 Release 2
* Gives a practical analysis of features based on real-world practices
* What you.ll learn
* Apply dimensional- and fact-based modeling to create OLAP schemas
* Optimize data extraction and transformation with SQL Server Integration
Services
* Develop OLAP and data-mining solutions using SQL Server Analysis Services
* Create compelling reports using the new Report Builder 3.0 in
SQL Server Reporting Services
* Deliver self-service business-intelligence via Microsoft PowerPivot
* Manage and maintain control over your business intelligence environment
Who this book is for
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.
Download File Size:42.23 MB
|
