Microsoft® SQL Server® 2008 Analysis Services Step by Step
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence-one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you&#...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step Microsoft SQL server 2008 analysis services step by step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627647406719 |
Tabla de Contenidos:
- Cover; Copyright page; Contents at a Glance; Table of Contents; Acknowledgments; Introduction; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Conventions; Hardware and Software Requirements; Practice Files and SQL Server 2008 Configuration; Installing the Practice Files; Configuring SQL Server 2008; Uninstalling the Practice files; Find Additional Content Online; Support for This Book; Questions and Comments; Chapter 1: Business Intelligence: A Data Analysis Foundation; Introducing Business Intelligence; Multidimensional Data Analysis
- Attributes in Data AnalysisHierarchies in Data Analysis; Dimensions in Data Analysis; Understanding a Dimensional Data Warehouse; A Fact Table; Dimension Tables; Surrogate Keys and Slowly Changing Dimensions; Alternative Table Structures; Multidimensional OLAP; Chapter 2: Understanding OLAP and Analysis Services; Understanding OLAP; Consistently Fast Response; Metadata-Based Queries; Spreadsheet-Style Formulas; Understanding Analysis Services; Analysis Services and Speed; Analysis Services and Metadata; Analysis Services and the Microsoft Business Intelligence Platform
- Analysis Services ToolsChapter 3: Accessing Source Data; Creating a Business Intelligence Solution; Creating a Data Source; Creating a Data Source View; Modifying a Data Source View; Chapter 4: Creating Dimensions; Previewing Dimension Data; Creating a Standard Dimension; Deploying an Analysis Services Database; Modifying a Dimension; Creating a Time Dimension; Creating a Parent-Child Dimension; Chapter 5: Creating a Cube; Previewing Cube Data; Using the Wizard to Create a Cube; Role-Playing Dimensions; Deploying and Browsing a Cube; Using the Cube Designer to Modify a Cube
- Adding User-Friendly Names to a CubeFormatting Measures; Modifying the Interaction of Dimensions and Measure Groups; Adding Measures and Measure Groups to a Cube; Creating a Calculated Member; Redeploying and Browsing a Cube; Chapter 6: Creating Advanced Measures and Calculations; Using Aggregate Functions; Using MDX to Retrieve Values from a Cube; Creating Calculated Members; Applying Conditional Formatting; Calculating Contribution; Creating Calculated Members Outside of the Measures Dimension; Calculation Scripting; Creating KPIs; Chapter 7: Advanced Dimension Design; Dimension Usage
- Creating Reference DimensionsCreating a Fact Dimension; Creating a Many-to-Many Dimension; Chapter 8: Working with Account Intelligence; Designing a Financial Analysis Cube; Working with Account Intelligence; Creating an Account Dimension; Working with Non-Additive Financial Measures; Creating a Non-Additive Calculated Member; Working with a Scenario Dimension; Chapter 9: Currency Conversion and Multiple Languages; Supporting Foreign Currency Conversion; Supporting Foreign Language Translation; Chapter 10: Interacting with a Cube; Implementing Actions; Creating Standard Actions
- Creating Drillthrough Actions
