Delivering Business Intelligence With Microsoft SQL Server 2012 3/E by Larson, Brian -- Read -- Imperial Library of Trantor

Index

Cover Contents at a Glance Contents The Maximum Miniatures Databases and Other Supporting Materials 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 2012

Chapter 2. Making the Most of What You’ve Got—Using Business Intelligence

What Business Intelligence Can Do for You When We Know What We Are Looking For Discovering New Questions and Their Answers 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 Snowflakes, Stars, and 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 Navigating SQL Server Data Tools SQL Server Data Tools Options The 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 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

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 12. 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 Tabling the Matter

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?

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

Data Mining Structure Data Columns Data Mining Model Training Data Set Mining Model Viewer Microsoft Decision Trees Microsoft Naive Bayes Microsoft Clustering Microsoft Neural Network Microsoft Association Rules Microsoft Sequence Clustering Microsoft Time Series Reading the Tea Leaves

Chapter 17. Spelunking—Exploration Using Data Mining

Mining Accuracy Chart Column Mapping Lift Chart Profit Chart Classification Matrix Cross Validation Mining Model Prediction A Singleton Query A Prediction Join Query Data Mining Extensions Prediction Query Syntax Types of Prediction Queries Special Delivery

Part VI: Delivering

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

ADOMD.NET ADOMD.NET Structure ADOMD.NET Example Integrating a Reporting Services Report with an Application Report Server Folders The Report Manager Deploying Reports Using SQL Server Data Tools Web Service Access Great Capabilities, Great Opportunities

Index