Foundations of SQL Server 2008 R2 business intelligence
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 i...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress
2011.
|
| Edición: | 2nd ed |
| Colección: | The expert's voice in SQL server Foundations of SQL Server 2008 R2 business intelligence
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628015606719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: What Is Business Intelligence?; Just What Is Business Intelligence?; Defining BI Using Microsoft's Tools; What Microsoft Products Are Involved?; BI Languages; Understanding BI from an End User's Perspective; Building the First Sample-Using AdventureWorks; Deploying the Standard Edition Version of the Sample Cube; How to Connect to the Sample Cube Using Excel; Understanding BI Through the Sample; Understanding the Business Problems That BI Addresses
- Reasons to Switch to Microsoft's BI ToolsSummary; Chapter 2: OLAP Modeling Concepts; Modeling OLAP Source Schemas-Stars; Understanding the Star Schema; Understanding a Dimension Table; Attributes; Why Create Star Schemas?; Effectively Creating Star Schema Models Using Grain Statements; Tools for Creating Your OLAP Model; Modeling Source Schemas-Snowflakes and Other Variations; Understanding the Snowflake Schema; Knowing When to Use Snowflakes; Considering Other Possible Variations; Choosing Whether to Use Views Against the Relational Data Sources; Understanding Unified Dimensional Modeling
- Using the UDMThe Slowly Changing Dimension (SCD); Type 1, 2, 3 SCD Solutions; The Rapidly Changing Dimension (RCD); Writeback Dimension; Understanding Fact (Measure) Modeling; An Example; Calculated Measure vs. Derived Measure; Other Types of Modeling; Data Mining; Key Performance Indicators; Actions, Perspectives, Translations; Source Control and Other Documentation Standards; Summary; Chapter 3: Introducing OLAP Modeling with SSAS; Using BIDS to Build a Cube; Defining Your First Cube; Adding Dimension Attributes; Defining Hierarchies; Building Your First Cube; Refining Your Cube
- Reviewing MeasuresReviewing Dimensions: Attributes; Reviewing Dimensions: Hierarchies; Creating Attribute Relationships; Other Parts of the Dimension Structure Tab; Dimension Properties; Offline vs. Online Mode in BIDS; Other Types of Modeling; Summary; Chapter 4: Intermediate OLAP Modeling with SSAS; Adding Key Performance Indicators (KPls); Implementing KPls in SSAS; Implementing KPls in SSMS; Using Perspectives and Translations; Perspectives; Translations; Localizing Measure Values; Using Actions; Creating Actions in SSAS; Creating Actions in SSMS; Summary
- Chapter 5: Advanced OLAP Modeling with SSASMultiple Fact Tables in a Single Cube; Nulls; Nonstar Dimensions; Snowflake Dimensions; Degenerate Dimensions; Parent-Child Dimensions; Many-to-Many Dimensions; Role-Playing Dimensions; Writeback Dimensions; Dimensions That Change; Error Handling for Dimension Attribute Loads; Using the Business Intelligence Wizard; Summary; Chapter 6: Cube Storage and Aggregation; Using the Default Storage: MOLAP; XML for Analysis; Aggregations; MOLAP as Default in SSAS; Adding Aggregations; The Aggregation Design Wizard; The Usage-Based Optimization Wizard
- The SQl Server Profiler asan Aggregation Design Aid
