Delivering business intelligence with Microsoft SQL server 2012, third edition
Implement a Robust BI Solution with Microsoft SQL Server 2012 Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively deve...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill
c2012
|
| Edición: | 3rd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629408906719 |
Tabla de Contenidos:
- Intro
- Delivering Business Intelligence
- About the Author
- About the Technical Editors
- Contents at a Glance
- Contents
- Acknowledgments
- The Maximum Miniatures Databases and Other Supporting Materials
- Part I: Business Intelligence
- Chapter 1: Equipping the Organization for Effective Decision Making
- Effective Decision Making
- Who Is a Decision Maker?
- What Is an Effective Decision?
- Keys to Effective Decision Making
- Are We Going Hither or Yon?
- Is Your Map Upside-Down?
- Panicked Gossip, the Crow's Nest, or the Wireless
- Business Intelligence
- Business Intelligence and Microsoft SQL Server 2012
- Chapter 2: Making the Most of What You've Got-Using Business Intelligence
- What Business Intelligence Can Do for You
- When We Know What We Are Looking For
- Layout-led Discovery
- Data-led Discovery
- Discovering New Questions and Their Answers
- Business Intelligence at Many Levels
- The Top of the Pyramid
- Highly Summarized Measures
- Higher Latency
- Mid-Level
- Summarized Measures with Drilldown
- Some Latency Acceptable
- The Broad Base
- Measures at the Detail Level
- Low Latency
- Maximum Miniatures, Inc.
- Business Needs
- Current Systems
- Manufacturing Automation
- Order Processing
- Point of Sale
- MaxMin.com
- Accounting
- Building the Foundation
- Chapter 3: Seeking the Source-The Source of Business Intelligence
- Seeking the Source
- Transactional Data
- Difficulties Using Transactional Data for Business Intelligence
- The Data Mart
- Features of a Data Mart
- Not Real-Time Data
- Consolidation and Cleansing
- Data Mart Structure
- Measures
- Dimensions
- The Star Schema
- Attributes
- Hierarchies
- The Snowflake Schema
- Snowflakes, Stars, and Analysis Services
- Chapter 4: Two, Two, Two Models in One-The BI Semantic Model
- Online Analytical Processing.
- The BI Semantic Model
- Building OLAP Out of Cubes-The Multidimensional Model
- Features of a Multidimensional Model Implementation
- Multidimensional Database
- Preprocessed Aggregates
- Easily Understood
- Architecture of a Multidimensional Model Implementation
- Relational OLAP
- Multidimensional OLAP
- Hybrid OLAP
- The Parts of a Multidimensional Model Implementation
- Data Sources
- Data Source Views
- Proactive Caching
- XML Definitions
- Building OLAP Out of Tables-The Tabular Model
- Features of a Tabular Model
- Tabular Structure
- Quick to Implement
- Architecture of a Tabular Model
- Cached Mode
- Direct Query Mode
- Choosing an Implementation Method
- Tools of the Trade
- Chapter 5: First Steps-Beginning the Development of Business Intelligence
- SQL Server Data Tools
- Visual Studio
- Project Organization
- Editing and Debugging Tools
- Source Code Management Integration
- Navigating SQL Server Data Tools
- Creating a Solution and an Analysis Services Project
- SQL Server Data Tools Windows
- Window Management
- SQL Server Data Tools Options
- Fonts and Colors
- Default File Locations
- The SQL Server Management Studio
- The SQL Server Management Studio User Interface
- The SQL Server Management Studio Windows
- The SQL Server Management Studio Projects
- Don Your Hardhat
- Part II: Defining Business Intelligence Structures
- Chapter 6: Building Foundations-Creating Data Marts
- Data Mart
- Who Needs a Data Mart Anyway?
- Legacy Databases
- Data from Nondatabase Sources
- No Physical Connection
- Dirty Data
- Designing a Data Mart
- Decision Makers' Needs
- Available Data
- Data Mart Structures
- Measures
- Dimensions and Hierarchies
- Attributes
- Stars and Snowflakes
- Learn By Doing-Designing the Maximum Miniatures Manufacturing Data Mart.
- Creating a Data Mart Using the SQL Server Management Studio
- Learn By Doing-Creating the Maximum Miniatures Manufacturing Data Mart Using the SQL Server Management Studio
- Creating a Data Mart Using SQL Server Data Tools
- Learn By Doing-Creating the Maximum Miniatures Sales Data Mart Using SQL Server Data Tools
- The Sales Data Mart
- Table Compression
- Types of Table Compression
- Row Compression
- Page Compression
- Learn By Doing-Enabling Table Compression
- The Benefits of Integration
- Chapter 7: Transformers-Integration Services Structure and Components
- Integration Services
- Package Structure
- Drag-and-Drop Programming
- Control Flow Tasks
- Connection Managers
- Precedence Arrows
- Data Flow
- Package Items
- Control Flow
- Control Flow SSIS Toolbox Organization
- Containers
- Control Flow Items
- Maintenance Plan Tasks
- Data Flow
- Data Flow SSIS Toolbox Organization
- Data Flow Sources
- Source Assistant
- Data Flow Transformations
- Data Flow Destinations
- Destination Assistant
- Getting Under the Sink
- Chapter 8: Fill 'er Up-Using Integration Services for Populating Data Marts
- Package Development Features
- Give It a Try
- Learn By Doing-Using Integration Services to Populate the Maximum Miniatures Manufacturing Data Mart Dimensions
- Programming in Integration Services Packages
- Variables
- Expressions
- Event Handlers
- Package Development Tools
- Import/Export Wizard
- Logging
- Transactions
- Checkpoints
- Package Debugging
- Change Data Capture
- Change Data Capture Architecture
- Enabling Change Data Capture
- All Changes versus Net Changes
- The Change Table
- The Validity Interval
- Loading a Data Mart Table from a Change Data Capture Change Table
- The CDC Initial Load Package
- The CDC Incremental Load Package
- Loading a Fact Table.
- Learn By Doing-Adding a Second Fact Table to the Manufacturing Data Mart
- Learn By Doing-Populating the Fact Tables in the Manufacturing Data Mart
- Putting Integration Services Packages into Production
- Parameters
- Associating Properties with Parameters
- The Integration Services Catalog
- Deploying SSIS Projects from SQL Server Data Tools
- Importing Packages into the SSIS Catalog
- Learn By Doing-Deploying the Packages to a Server
- Managing Packages in the Integration Services Catalog
- Utilizing Environments
- Setting Permissions
- Executing Packages from the SSIS Catalog
- Execution Dashboard Reports
- Meanwhile, Back at the BI Semantic Model
- Part III: Working with a Multidimensional BI Semantic Model
- Chapter 9: Cubism-Measures and Dimensions
- Building a Multidimensional BI Semantic Model
- Creating a Cube
- Learn By Doing-Building a Multidimensional BI Semantic Model for the Manufacturing Data Mart
- Measures
- Measure Groups
- Measure Groups and Dimensions
- Granularity
- Made-up Facts-Calculated Measures
- Creating Calculated Measures
- It Doesn't Add Up-Measure Aggregates Other Than Sum
- Semiadditive Measures
- Aggregate Functions
- Learn By Doing-Working with Measures and Measure Groups
- Dimensions
- Managing Dimensions
- Learn By Doing-Cleaning Up the Dimensions in the Max Min Manufacturing DM Cube
- Relating Dimensions to Measure Groups
- Learn By Doing-Relating Dimensions in the Max Min Manufacturing DM Cube
- Types of Dimensions
- Fact Dimensions
- Parent-Child Dimensions
- Role Playing Dimensions
- Reference Dimensions
- Data Mining Dimensions
- Many-to-Many Dimensions
- Slowly Changing Dimensions
- Type 1 Slowly Changing Dimensions
- Type 2 Slowly Changing Dimensions
- Type 3 Slowly Changing Dimensions
- Loading the Max Min Sales DM Data Mart
- You Are Special.
- Chapter 10: Bells and Whistles-Special Features of OLAP Cubes
- Where No Cube Has Gone Before
- Deploying and Processing
- Deploying
- Processing
- Deploying from SQL Server Data Tools
- Learn By Doing-Deploying the MaxMinManufacturingDM Project Using SQL Server Data Tools
- Deploying from the Analysis Services Deployment Wizard
- Learn By Doing-Deploying the MaxMinSalesDM Project Using the Analysis Services Deployment Wizard
- Additional Cube Features
- Linked Objects
- Creating a Linked Measure
- The Business Intelligence Wizard
- Key Performance Indicators
- Creating a Key Performance Indicator
- Key Performance Indicators and Client Software
- Learn By Doing-Adding a KPI to the Max Min Manufacturing DM Cube
- Actions
- Types of Actions
- Creating an Action
- Creating Drillthrough Actions
- Creating Reporting Actions
- Actions and Client Software
- Partitions
- Measure Groups and Partitions
- Multiple Partitions for a Measure Group
- Learn By Doing-Creating Multiple Partitions from a Single Table
- Partitions and Storage Options
- Learn By Doing-Setting Storage Options for a Cube Partition
- Writeback
- Aggregation Design
- Manual Aggregation Design
- Perspectives
- Creating Perspectives
- Translations
- Creating Translations
- More Sophisticated Scripting
- Chapter 11: Writing a New Script-MDX Scripting
- Terms and Concepts
- Where Are We?
- Cells
- Tuples
- Levels
- Shortcuts
- Expression Errors
- Default Members
- Sets
- Range Operator
- Name Attributes
- Learn By Doing-Default Members, Level Names, and the NameColumn Property
- Getting There from Here
- The Starting Point-The CurrentMember Function
- Relative Position Within a Hierarchy Level-The Lag, Lead, NextMember, and PrevMember Functions.
- Immediate Relative Position Between Hierarchy Levels-The Children, FirstChild, FirstSibling, LastChild, LastSibling, Parent, and Siblings Functions.
