Delivering business intelligence with Microsoft SQL server 2016
"Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custo...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
New York
McGraw-Hill Education
2017
|
| Edition: | Fourth edition |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Creating a Data Mart Using SQL Server Data Tools
- Table Compression
- Types of Table Compression
- The Benefits of Integration
- Chapter 7 Transformers: Integration Services Structure and Components
- Integration Services
- Package Structure
- Package Items
- Control Flow
- Data Flow
- Getting Under the Sink
- Chapter 8 Fill 'er Up: Using Integration Services for Populating Data Marts
- Package Development Features
- Give It a Try
- Programming in Integration Services Packages
- Package Development Tools
- Change Data Capture
- Change Data Capture Architecture
- SQL Server Data Tools
- Visual Studio
- Installing SQL Server Data Tools
- Navigating SQL Server Data Tools
- SQL Server Data Tools Options
- SQL Server Management Studio
- Installing SQL Server Management Studio
- The SQL Server Management Studio User Interface
- Don Your Hardhat
- Part II Defining Business Intelligence Structures
- Chapter 6 Building Foundations: Creating Data Marts
- Data Mart
- Who Needs a Data Mart Anyway?
- Designing a Data Mart
- Decision Makers' Needs
- Available Data
- Data Mart Structures
- Creating a Data Mart Using the SQL Server Management Studio
- Cover
- About the Author
- Title Page
- Copyright Page
- Dedication
- Contents at a Glance
- Contents
- Acknowledgments
- 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 2016
- Chapter 2 Making the Most of What You've Got: Using Business Intelligence
- What Business Intelligence Can Do for You
- Types of Data Exploration
- Business Intelligence at Many Levels
- The Top of the Pyramid
- Mid-Level
- The Broad Base
- Maximum Miniatures, Inc.
- Business Needs
- Current Systems
- Building the Foundation
- Chapter 3 Seeking the Source: The Source of Business Intelligence
- Seeking the Source
- Transactional Data
- The Data Mart
- Features of a Data Mart
- Data Mart Structure
- Why 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
- Architecture of a Multidimensional Model Implementation
- The Parts of a Multidimensional Model Implementation
- Building OLAP Out of Tables: The Tabular Model
- Features of a Tabular Model
- Architecture of a Tabular Model
- Choosing an Implementation Method
- Tools of the Trade
- Chapter 5 First Steps: Beginning the Development of Business Intelligence