Pro SQL Server 2008 Analysis Services (Paperback)

Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008 Analysis Services will show you how to pull that data together and present it for reporting and analysis in a way that makes the data accessible to business users, instead of needing to rely on the IT department every time someone needs a different report.

• Accessible–With a single author's voice, this book conducts a guided tour through the technology that makes it easy to dive into.
• Solution–oriented–While technically deep, the goal is to focus on practical application of the technologies instead of acting as a technical manual.
• ComprehensiveThis book covers every aspect of Analysis Services and ancillary technologies to enable you to make the most of SQL Server.

What you'll learn

• Understand the importance of OLAP and Analysis Services technologies.
• Build cubes and dimensions that let you get business value out of large volumes of data.
• Learn the fundamentals of MDX–the query language for advanced analysis.
• Apply ancillary aspects of SSAS: KPIs, perspectives, and calculated members.
• Apply basic data mining concepts–identify answers to questions you weren't even aware you should ask.
• Learn the various ways to consume Analysis Services data (Reporting Services, Excel, and ProClarity).

Who is this book for?

Pro SQL Server 2008 Analysis Services is aimed at developers who want to take advantage of SQL Server's built-in business intelligence functionality to mine their data and produce reports that can drive business forward in right and profitable directions. The book is secondarily aimed at database administrators charged with supporting Analysis Services solutions.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

每個企業都有大量的業務數據存儲在數據庫、業務系統和電子表格中。儘管您可能能夠通過整合這些存儲庫中的一些數據來生成一些報告，但實際上對運行您的業務的數據進行任何形式的分析可能從有問題到不可能。《Pro SQL Server 2008 Analysis Services》將向您展示如何將這些數據整合在一起，以報告和分析的方式呈現，使業務用戶能夠輕鬆訪問數據，而不需要每次有人需要不同的報告時都依賴IT部門。

• 易於訪問- 本書以單一作者的聲音，通過引導式導覽介紹了使您能夠輕鬆深入其中的技術。


• 解決方案導向- 雖然技術深入，但目標是專注於技術應用的實際性，而不是作為技術手冊。


• 全面性- 本書涵蓋了Analysis Services和相關技術的每個方面，使您能夠充分利用SQL Server。

您將學到什麼

• 了解OLAP和Analysis Services技術的重要性。


• 構建立方體和維度，讓您從大量數據中獲得業務價值。


• 學習MDX的基礎知識- 進階分析的查詢語言。


• 應用SSAS的附屬方面：KPI、透視圖和計算成員。


• 應用基本的數據挖掘概念- 找到您甚至沒有意識到應該提出的問題的答案。


• 學習使用Analysis Services數據的各種方式（報告服務、Excel和ProClarity）。

本書適合對象

《Pro SQL Server 2008 Analysis Services》面向希望利用SQL Server內置的商業智能功能來挖掘數據並生成能夠推動業務向前發展的報告的開發人員。本書次要面向負責支持Analysis Services解決方案的數據庫管理員。

關於Apress Pro系列

Apress Pro系列書籍是實用的專業教程，可幫助您在職業生涯中保持並提升您的技能。

您已經得到了工作，現在您需要在這個競爭激烈的時代中磨練自己的技能。Apress Pro系列擴展了您在所需領域的技能和專業知識。掌握Pro系列書籍的內容，您將始終能夠在專業開發項目中完成工作。Apress Pro系列書籍由各自領域的專家撰寫，為您提供在職業編程生涯中將面臨的問題的寶貴解決方案。