Bi Guy 2

✍ Scribed by Mason Lee

• Year: 2013
• Tongue: English
• Weight: 25 KB
• Category: Fiction
• ASIN: B00EHK9BYU

✦ Synopsis

Annotation. Foundations of SQL Server 2008 R2 Business Intelligenceintroduces 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. AuthorsGuy FouchéandLynn Langitshow 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 Microsoftbusiness intelligencetoolkit. 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 powerfulbusiness intelligencesuite that Microsoft has placed at your disposal. Provides the big picture of Microsofts BI tool suiteCovers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2Gives a practical analysis of features based on real-world practicesWhat youll learnApply dimensional- and fact-based modeling to create OLAP schemasOptimize data extraction and transformation with SQL Server Integration ServicesDevelop OLAP and data-mining solutions using SQL Server Analysis ServicesCreate compelling reports using the new Report Builder 3.0 in SQL Server Reporting ServicesDeliver self-service business-intelligence via Microsoft PowerPivotManage and maintain control over your business intelligence environmentWho this book is forFoundations of SQL Server 2008 R2 Business Intelligenceis 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. Table of ContentsWhat Is Business Intelligence?OLAP Modeling ConceptsIntroducing OLAP Modeling with SSASIntermediate OLAP Modeling with SSASAdvanced OLAP Modeling with SSASCube Storage and AggregationIntroducing SSISIntermediate SSISAdvanced SSISReporting ToolsData Mining with ExcelIntroducing PowerPivotIntroduction to MDXIntroduction to Data Mining.