
Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- 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
- Loading a Data Mart Table from a Change Data Capture Change Table
- Loading a Fact Table
- Putting Integration Services Packages into Production
- Parameters
- The Integration Services Catalog
- Managing Packages in the Integration Services Catalog
- Executing Packages from the SSIS Catalog
- Meanwhile, Back at the BI Semantic Model
- Part III Working with a Tabular BI Semantic Model
- Chapter 9 Setting the Table: Creating a Tabular BI Semantic Model
- Preparation for Creating Tabular Models
- SQL Server Analysis Services Tabular Instance
- Managing the Workspace Database
- Creating a Tabular Model
- Data Sources for Our Tabular Models
- Measures in a Tabular Model
- Manually Creating a Time Table
- Relationships and Hierarchies
- Validating the Model Using the Analyze in Excel Feature
- A Second Tabular Model
- Data Persistence
- Calculated Columns
- Hierarchies Spanning Multiple Tables
- Putting More on the Table
- Chapter 10 A Fancy Table: Tabular BI Semantic Model Advanced Features
- Enhancing Our Tabular Model
- Table and Column Properties
- Adding Images to a Tabular Model
- Advanced Relationships and Filtering
- Parent/Child Relationships
- Multiple Relationships Between the Same Tables
- Partitions
- Perspectives
- DAX Expressions
- DAX Operators
- The Context for Measures and Calculated Columns
- Filtering Aggregates
- Table-Valued Functions
- Aggregate Functions
- DAX Functions for Time Analytics
- Additional DAX Functions
- Putting DAX Functions to Use
- Variables in the Tabular Model
- Declaring DAX Variables and Assigning a Value
- Using a DAX Variable
- Using Return in a Measure
- Deploying a Tabular Model
- Deploying from SQL Server Data Tools
- Completing the Deployment
- Deploying from the Analysis Services Deployment Wizard
- Another Model Awaits
- Part IV Working with a Multidimensional BI Semantic Model
- Chapter 11 Cubism: Measures and Dimensions
- Building a Multidimensional BI Semantic Model
- Creating a Cube
- Measures
- Measure Groups
- Made-Up Facts: Calculated Measures
- It Doesn't Add Up: Measure Aggregates Other Than Sum
- Dimensions
- Managing Dimensions
- Relating Dimensions to Measure Groups
- Types of Dimensions
- Slowly Changing Dimensions
- You Are Special
- Chapter 12 Bells and Whistles: Special Features of OLAP Cubes
- Where No Cube Has Gone Before
- Deploying and Processing
- Deploying from SQL Server Data Tools
- Deploying from the Analysis Services Deployment Wizard
- Additional Cube Features
- Linked Objects
- The Business Intelligence Wizard
- Key Performance Indicators
- Actions
- Partitions
- Aggregation Design
- Perspectives
- Translations
- Creating Translations
- More Sophisticated Scripting
- Chapter 13 Writing a New Script: MDX Scripting
- Terms and Concepts
- Where Are We?
- Getting There from Here
- Putting MDX Scripting to Work
- Cube Security
- This Year-to-Last Year Comparisons and Year-to-Date Rollups
- Extracting Data from Cubes
- Chapter 14 Pulling It Out and Building It Up: MDX Queries
- The MDX SELECT Statement
- The Basic MDX SELECT Statement
- Additional Tools for Querying
- Additional Dimensions
- Additional MDX Syntax
- Operators
- Functions
- Feel the Power
- Part V Modeling and Visualizing with Power BI
- Chapter 15 Power to the People: Loading Data with Power BI
- The Power BI Architecture
- Many Manifestations
- Power BI Desktop
- PowerBI.com
- Power BI Content on Premises
- Power BI Mobile
- Constant Improvement
- Obtaining the Power BI Desktop Software
- The Power BI Data Engine
- Getting Started with Power BI: Gathering Data
- The Start Dialog Box
- Get Data
- Creating Your First Power BI Content
- Using Live Connection
- Connection Types and Direct Query
- Transforming Data During the Data Import
- The Power BI Query Editor
- A New Sample: World Population
- Transformations
- Advanced Editor and Power Query Formula Language
- Parameters
- Putting Parameters to Use
- Delivering the Power
- Chapter 16 I Can See Clearly Now: Data Visualization with Power BI Reporting
- Enhancing Power BI Data Models
- Relationships and Intermediate Tables
- Formatting and Categories
- Hierarchies
- Power BI Data Visualizations
- Basic Visualization
- High Interactivity
- Mapping
- Additional Visualization Elements
- DAX Calculations
- Calculated Column: Order Weight
- Time Analytics
- Context Override: Percent of Total
- Additional Power BI Features
- Roles
- Synonyms
- Import and Export
- PowerBI.com
- Signing In to PowerBI.com
- Publishing
- Refreshing Data Online
- On-premises Power BI Publishing
- Special Delivery
- Part VI Delivering
- Chapter 17 Special Delivery: Microsoft Business Intelligence Client Tools
- Front-End BI Tools from Microsoft
- Selecting a Front-End BI Tool
- A Bit of Knowledge Is a Big Help
- Reporting Services
- Reporting Services Paginated Reports
- Paginated Report Structure
- Paginated Report Delivery
- Data Regions
- Creating a Reporting Services Paginated Report
- Reporting Services Mobile Reports
- Creating a Reporting Services Mobile Report
- Reporting Services Key Performance Indicators
- Creating a Reporting Services Key Performance Indicator
- Excel
- Creating Pivot Tables and Pivot Charts
- Pivot Chart
- PerformancePoint Services in SharePoint
- Creating a Site Collection Using the Business Intelligence Center Template
- Creating a Dashboard Using PerformancePoint Services
- Putting It All Together
- Chapter 18 Let's Get Together: Integrating Business Intelligence with Your Applications
- ADOMD.NET
- ADOMD.NET
- ADOMD.NET Example
- Integrating a Reporting Services Report with an Application
- Report Server
- Folders
- The Web Portal
- Deploying Reports Using SQL Server Data Tools
- Web Service Access
- Great Capabilities, Great Opportunities
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.