Read more
Informationen zum Autor Brian Larson (Arden Hills, MN) served as a contract member of the Reporting Services development team and contributed to the code base. He has contributed to SQL Server Magazine and is the Chief of Technology for Superior Consulting Services. With over 18 years of experience in the computer industry, and 14 years as a software development consultant, Brian is an MCSD as well as an MCDBA, and has authored and delivered training curriculum for SQL Server 2000 and C#.NET as well as numerous custom applications. Klappentext Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Maximize the Business Intelligence Tools in Microsoft SQL Server 2008 Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization. Understand the goals and benefits of business intelligence Design and create relational data marts and OLAP cubesManage Analysis Services databases using BI Development StudioCleanse data and populate data marts with SQL Server Integration ServicesTake advantage of the flexibility of the Unified Dimensional Model Manipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clusteringDevelop and distribute interactive reports with SQL Server 2008 Reporting ServicesIntegrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control Zusammenfassung A practical guide to maximizing the Business Intelligence tools in the new SQL Server release Inhaltsverzeichnis Part I: Business Intelligence Chapter 1. Equipping the Organization for Effective Decision Making Chapter 2. Making the Most of What You've Got--Using Business Intelligence Chapter 3. Seeking the Source--The Source of Business Intelligence Chapter 4. One-Stop Shopping--The Unified Dimensional Model Chapter 5. First Steps--Beginning the Development of Business Intelligence Part II: Defining Business Intelligence Structures Chapter 6. Building Foundations--Creating Data Marts Chapter 7. Transformers--Integration Services Structure and Components Chapter 8. Fill'er Up - Using Integration Services for Populating Data Marts Part III: Analyzing Cube Content Chapter 9. Cubism--Measures and Dimensions Chapter 10. Bells and Whistles--Special Features of OLAP Cubes Chapter 11. Writing a New Script--MDX Scripting Chapter 12. Pulling It Out and Building It Up--MDX Queries Part IV: Mining Chapter 13. Panning for Gold--Introduction to Data Mining Chapter 14. Building the Mine--Working with the Data Mining Model Chapter 15. Spelunking--Exploration Using Data Mining Part V: Delivering Chapter 16. On Report--Delivering Business Intelligence with Reporting Systems Chapter 17. Falling into Place--Managing Reporting Systems Reports Chapter 18. Let's Get Together--Excel Pivot Tables and Pivot Charts Index...
