Smart business intelligence solutions with Microsoft SQL Server 2008

Smart business intelligence solutions with Microsoft SQL Server 2008

Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, y...

Full description

Bibliographic Details
Other Authors: Kevin S. Goff Lynn Langit Davide Mauri, Sahil, author (author), Langit, Lynn (-)
Format: eBook
Language:Inglés
Published: Redmond, Wash. : Microsoft Press c2009.
Edition:1st edition
Subjects:
SQL server.
Relational databases.
Client/server computing.
Business intelligence.
OLAP technology.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628230306719
Table of Contents:
  • Cover
  • Copyright page
  • Dedication
  • Contents at a Glance
  • Table of Contents
  • Foreword
  • Acknowledgments
  • Lynn Langit
  • Davide Mauri
  • Sahil Malik
  • Introduction
  • Who This Book Is For
  • What This Book Is About
  • Part I, "Business Intelligence for Business Decision Makers and Architects"
  • Part II, "Microsoft SQL Server 2008 Analysis Services for Developers"
  • Part III, "Microsoft SQL Server 2008 Integration Services for Developers"
  • Part IV, "Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence"
  • Prerelease Software
  • Hardware and Software Requirements
  • Find Additional Content Online
  • Support for This Book
  • Questions and Comments
  • Part I: Business Intelligence for Business Decision Makers and Architects
  • Chapter 1: Business Intelligence Basics
  • Business Intelligence and Data Modeling
  • OLTP and OLAP
  • Online Transactional Processing
  • Online Analytical Processing
  • Common BI Terminology
  • Data Warehouses
  • Data Marts
  • Cubes
  • Decision Support Systems
  • Data Mining Systems
  • Extract, Transform, and Load Systems
  • Report Processing Systems
  • Key Performance Indicators
  • Core Components of a Microsoft BI Solution
  • SQL Server 2008 Analysis Services
  • SQL Server 2008 Reporting Services
  • SQL Server 2008
  • SQL Server 2008 Integration Services
  • Optional Components of a Microsoft BI Solution
  • Query Languages used in BI Solutions
  • MDX
  • DMX
  • XMLA
  • RDL
  • Summary
  • Chapter 2: Visualizing Business Intelligence Results
  • Matching Business Cases to BI Solutions
  • Top 10 BI Scoping Questions
  • Components of BI Solutions
  • Understanding Business Intelligence from a User's Perspective
  • Demonstrating the Power of BI Using Excel 2007
  • Understanding Data Mining via the Excel Add-ins
  • Viewing Data Mining Structures Using Excel 2007.
  • Elements of a Complete BI Solution
  • Reporting-Deciding Who Will Use the Solution
  • ETL-Getting the Solution Implemented
  • Data Mining-Don't Leave It Out
  • Common Business Challenges and BI Solutions
  • Measuring the ROI of BI Solutions
  • Summary
  • Chapter 3: Building Effective Business Intelligence Processes
  • Software Development Life Cycle for BI Projects
  • Microsoft Solutions Framework
  • Microsoft Solutions Framework for Agile Software Development
  • Applying MSF to BI Projects
  • Phases and Deliverables in the Microsoft Solutions Framework
  • Skills Necessary for BI Projects
  • Required Skills
  • Optional Skills
  • Forming Your Team
  • Roles and Responsibilities Needed When Working with MSF
  • Summary
  • Chapter 4: Physical Architecture in Business Intelligence Solutions
  • Planning for Physical Infrastructure Change
  • Creating Accurate Baseline Surveys
  • Assessing Current Service Level Agreements
  • Determining the Optimal Number and Placement of Servers
  • Considerations for Physical Servers
  • Considerations for Logical Servers and Services
  • Understanding Security Requirements
  • Security Requirements for BI Solutions
  • Backup and Restore
  • Backing Up SSAS
  • Backing Up SSIS
  • Backing Up SSRS
  • Auditing and Compliance
  • Auditing Features in SQL Server 2008
  • Source Control
  • Summary
  • Chapter 5: Logical OLAP Design Concepts for Architects
  • Designing Basic OLAP Cubes
  • Star Schemas
  • Denormalization
  • Back to the Star
  • Other Design Tips
  • Modeling Snowflake Dimensions
  • More About Dimensional Modeling
  • Understanding Fact (Measure) Modeling
  • Other Considerations in BI Modeling
  • Summary
  • Part II: Microsoft SQL Server 2008 Analysis Services for Developers
  • Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler
  • Core Tools in SQL Server Analysis Services
  • Baseline Service Configuration.
  • SSAS in SSMS
  • How Do You Query SSAS Objects?
  • Using MDX Templates
  • Using DMX Templates
  • Using XMLA Templates
  • Closing Thoughts on SSMS
  • Summary
  • Chapter 7: Designing OLAP Cubes Using BIDS
  • Using BIDS
  • Offline and Online Modes
  • Working in Solution Explorer
  • Data Sources in Analysis Services
  • Data Source Views
  • Roles in Analysis Services
  • Using Compiled Assemblies with Analysis Services Objects
  • Building OLAP Cubes in BIDS
  • Examining the Sample Cube in Adventure Works
  • Understanding Dimensions
  • Attribute Hierarchies
  • Attribute Relationships
  • Translations
  • Using Dimensions
  • Measure Groups
  • Beyond Star Dimensions
  • Building Your First OLAP Cube
  • Selecting Measure Groups
  • Adding Dimensions
  • Summary
  • Chapter 8: Refining Cubes and Dimensions
  • Refining Your First OLAP Cube
  • Translations and Perspectives
  • Key Performance Indicators
  • Actions
  • Calculations (MDX Scripts or Calculated Members)
  • Using Cube and Dimension Properties
  • Time Intelligence
  • SCOPE Keyword
  • Account Intelligence and Unary Operator Definitions
  • Other Wizard Options
  • Currency Conversions
  • Advanced Cube and Dimension Properties
  • Summary
  • Chapter 9: Processing Cubes and Dimensions
  • Building, Processing, and Deploying OLAP Cubes
  • Differentiating Data and Metadata
  • Working in a Disconnected Environment
  • Working in a Connected Environment
  • Understanding Aggregations
  • Partitioning
  • Choosing Storage Modes: MOLAP, HOLAP, and ROLAP
  • OLTP Table Partitioning
  • Other OLAP Partition Configurations
  • Implementing Aggregations
  • Aggregation Design Wizard
  • Usage-Based Optimization Wizard
  • SQL Server Profiler
  • Aggregation Designer: Advanced View
  • Implementing Advanced Storage with MOLAP, HOLAP, or ROLAP
  • Proactive Caching
  • Notification Settings for Proactive Caching.
  • Fine-Tuning Proactive Caching
  • ROLAP Dimensions
  • Linking
  • Writeback
  • Cube and Dimension Processing Options
  • Summary
  • Chapter 10: Introduction to MDX
  • The Importance of MDX
  • Writing Your First MDX Queries
  • MDX Object Names
  • Other Elements of MDX Syntax
  • MDX Core Functions
  • Filtering MDX Result Sets
  • Calculated Members and Named Sets
  • Creating Objects by Using Scripts
  • The TopCount Function
  • Rank Function and Combinations
  • Head and Tail Functions
  • Hierarchical Functions in MDX
  • Date Functions
  • Using Aggregation with Date Functions
  • About Query Optimization
  • Summary
  • Chapter 11: Advanced MDX
  • Querying Dimension Properties
  • Looking at Date Dimensions and MDX Seasonality
  • Creating Permanent Calculated Members
  • Creating Permanent Calculated Members in BIDS
  • Creating Calculated Members Using MDX Scripts
  • Using IIf
  • About Named Sets
  • About Scripts
  • Understanding SOLVE_ORDER
  • Creating Key Performance Indicators
  • Creating KPIs Programmatically
  • Additional Tips on KPIs
  • Using MDX with SSrS and PerformancePoint Server
  • Using MDX with SSRS 2008
  • Using MDX with PerformancePoint Server 2007
  • Summary
  • Chapter 12: Understanding Data Mining Structures
  • Reviewing Business Scenarios
  • Categories of Data Mining Algorithms
  • Working in the BiDS Data Mining Interface
  • Understanding Data Types and Content Types
  • Setting Advanced Data Properties
  • Choosing a Data Mining Model
  • Picking the Best Mining Model Viewer
  • Mining Accuracy Charts and Prediction
  • Data Mining Algorithms
  • Microsoft Naïve Bayes
  • Microsoft Decision Trees Algorithm
  • Microsoft Linear Regression Algorithm
  • Microsoft Time Series Algorithm
  • Microsoft Clustering Algorithm
  • Microsoft Sequence Clustering
  • Microsoft Association Algorithm
  • Microsoft Neural Network Algorithm
  • Microsoft Logistic Regression.
  • The Art of Data Mining
  • Summary
  • Chapter 13: Implementing Data Mining Structures
  • Implementing the CRISP-DM Life Cycle Model
  • Building Data Mining Structures Using BIDS
  • Adding Data Mining Models Using BIDS
  • Processing Mining Models
  • Validating Mining Models
  • Lift Charts
  • Profit Charts
  • Classification Matrix
  • Cross Validation
  • Data Mining Prediction Queries
  • DMX Prediction Queries
  • DMX Prediction Functions
  • Data Mining and Integration Services
  • Data Mining Object Processing
  • Data Mining Clients
  • Summary
  • Part III: Microsoft SQL Server 2008 Integration Services for Developers
  • Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services
  • Overview of Integration Services Architecture
  • Integration Services Packages
  • Tools and Utilities for Developing, Deploying, and Executing Integration Services Packages
  • The Integration Services Object Model and Components
  • Control Flow
  • Data Flow
  • Variables
  • Expressions
  • Connection Managers
  • Event Handlers and Error Handling
  • The Integration Services Runtime
  • The Integration Services Data Flow Engine
  • Data Flow Buffers
  • Synchronous Data Flow Outputs
  • Asynchronous Data Flow Outputs
  • Log Providers
  • Deploying Integration Services Packages
  • Package Configurations
  • Package Deployment Options
  • Summary
  • Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
  • Integration Services in Visual Studio 2008
  • Creating New SSIS Projects with the Integration Services Project Template
  • Viewing an SSIS Project in Solution Explorer
  • Using the SSIS Package Designers
  • Working with the SSIS Toolbox
  • Choosing from the SSIS Menu
  • Connection Managers
  • Standard Database Connection Managers
  • Other Types of Connection Managers
  • Control Flow.
  • Control Flow Tasks.

Similar Items