Foundations of SQL Server 2008 R2 business intelligence
Annotation
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
[New York]
Apress
2011
|
| Edition: | 2nd edition |
| Series: | The expert's voice in SQL server
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 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
- 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
- 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
- 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