Book description
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 develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive resource.
- Understand the goals and components of successful BI
- Design, deploy, and manage data marts and OLAP cubes
- Load and cleanse data with SQL Server Integration Services
- Manipulate and analyze data using MDX and DAX scripts and queries
- Work with SQL Server Analysis Services and the BI Semantic Model
- Author interactive reports using SQL Server Data Tools
- Create KPIs and digital dashboards
- Use data mining to identify patterns, correlations, and clusters
- Implement time-based analytics
- Embed BI reports in custom applications using ADOMD.NET
Table of contents
- Cover
- Half Title
- About the Author
- Title
- Copyright
- Dedication
- 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
- Chapter 2. Making the Most of What You’ve Got—Using Business Intelligence
- Chapter 3. Seeking the Source—The Source of Business Intelligence
-
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
-
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
-
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
-
Chapter 6. Building Foundations—Creating Data Marts
-
Part III Working with a Multidimensional BI Semantic Model
-
Chapter 9. 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 10. 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
- More Sophisticated Scripting
- Chapter 11. Writing a New Script—MDX Scripting
- Chapter 12. Pulling It Out and Building It Up—MDX Queries
-
Chapter 9. Cubism—Measures and Dimensions
-
Part IV Working with a Tabular BI Semantic Model
-
Chapter 13. 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 14. A Fancy Table—Tabular BI Semantic Model Advanced Features
- Enhancing Our Tabular Model
- Table and Column Properties
- Adding Images to a Tabular Model
- Parent/Child Relationships
- Multiple Relationships Between the Same Tables
- Partitions
- Perspectives
- DAX Functions
- The Context for Measures and Calculated Columns
- Filtering Aggregates
- Table-Valued Functions
- Aggregate Functions
- DAX Functions for Time Analytics
- Putting DAX Functions to Use
- Deploying a Tabular Model
- Deployment Configuration
- Completing the Deployment
- Can You Dig It?
-
Chapter 13. Setting the Table—Creating a Tabular BI Semantic Model
-
Part V Mining
-
Chapter 15. Panning for Gold—Introduction to Data Mining
- What Is Data Mining?
- Order from Chaos
- Tasks Accomplished by Data Mining
- Steps for Data Mining
- Data Mining Algorithms
- Microsoft Decision Trees
- Microsoft Linear Regression
- Microsoft Naive Bayes
- Microsoft Clustering
- Microsoft Association Rules
- Microsoft Sequence Clustering
- Microsoft Time Series
- Microsoft Neural Network
- Microsoft Logistic Regression
- Grab a Pick Axe
- Chapter 16. Building the Mine—Working with the Data Mining Model
- Chapter 17. Spelunking—Exploration Using Data Mining
-
Chapter 15. Panning for Gold—Introduction to Data Mining
-
Part VI Delivering
-
Chapter 18. 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
- Report Structure
- Report Delivery
- Data Regions
- Creating a Reporting Services Report
- 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
- Power View
- Setting Up Power View in SharePoint
- Creating a Connection to a Tabular BI Semantic Model
- Creating a Power View Report
- Putting It All Together
- Chapter 19. Let’s Get Together—Integrating Business Intelligence with Your Applications
-
Chapter 18. Special Delivery—Microsoft Business Intelligence Client Tools
- Index
Product information
- Title: Delivering Business Intelligence with Microsoft SQL Server 2012 3/E, 3rd Edition
- Author(s):
- Release date: November 2011
- Publisher(s): McGraw-Hill
- ISBN: 9780071759397
You might also like
book
Business Intelligence with SQL Server Reporting Services
Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the …
book
Microsoft SQL Server 2012 Reporting Services 4/E, 4th Edition
The Definitive Guide to Microsoft SQL Server 2012 Reporting Services Create, deploy, and manage business intelligence …
book
The Microsoft® Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft® Business Intelligence Toolset, Second Edition
Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …