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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Larson, Brian (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2017]
Edición:Fourth edition.
Temas:
SQL server.
Business intelligence.
Client/server computing.
Architecture client-serveur (Informatique)
COMPUTERS > Database Management > General.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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
  • 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
  • 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

Ejemplares similares