| |
This book provides best practices for building complete BI solutions using the full Microsoft toolset. You will learn how to effectively use SQL Server Analysis and Reporting Services, along with Excel, SharePoint and other tools to provide effective and cohesive solutions for the enterprise. Coverage includes BI architecture, data queries, semantic models, multidimensional modeling, data analysis and visualization, performance monitoring, data mining and more, to help you learn to perform practical business analysis and reporting.
Table of Contents:
Introduction
Part I: Overview of the Microsoft Business Intelligence Toolset
Chapter 1 - Which Analysis and Reporting Tools Do You Need?
Selecting a SQL Server Database Engine
Building a Data Warehouse
Selecting an RDBMS
Selecting SQL Server Analysis Services
Working with SQL Server Reporting Services
Understanding Operational Reports
Understanding AD HOC Reporting
Working with SharePoint
Working with Performance Point
Using Excel for Business Intelligence
What is Power Query?
What is Power Pivot?
What is Power View?
Power Map
Which Development Tools Do You Need?
Using SQL Server Data Tools
Using SQL Management Studio
Using Dashboard Designer
Using Report Builder
Chapter 2 - Designing an Effective Business Intelligence Architecture
Identifying the Audience and Goal of the Business Intelligence Solution
Who`s the Audience?
What is the Goal(s)?
What are the Data Sources?
Using Internal Data Sources
Using External Data Sources
Using a Data Warehouse (or Not)
Implementing and Enforcing Data Governance
Planning an Analytical Model
Planning the Business Intelligence Delivery Solution
Considering Performance
Considering Availability
Chapter 3: Selecting the Data Architecture that Fits Your Organization
Why is Data Architecture Selection Important?
Challenges
Benefits
How Do You Pick the Right Data Architecture?
Understanding Architecture Options
Understanding Research Selection Factors
Interviewing Key Stakeholders
Completing the Selection Form
Finalizing and Approving the Architecture
Part II: Business Intelligence for Analysis
Chapter 4 - Searching and Combining Data with Power Query
Downloading and Installing Power Query
Importing Data
Importing from a Database
Importing from the Web
Importing from a File
Transforming Data
Combining Data from Multiple Sources
Splitting Data
Aggregating Data
Introducing M Programming
A Glance at the M Language
Adding and Removing Columns using M
Chapter 5 - Choosing the Right Business Intelligence Semantic Model
Understanding the Business Intelligence Semantic Model Architecture
Understanding the Data Access Layer
Using Power Pivot
Using the Multidimensional Model
Using the Tabular Model
Implementing Query Languages and the Business Logic Layer
Data Analytics Expressions (DAX)
Multidimensional Expressions (MDX)
Direct Query and ROLAP
Data Model Layer
Comparing the Different Types of Models
Which Model Fits Your Organization?
Departmental
Team
Organizational
Chapter 6 - Discovering and Analyzing Data with Power Pivot
Understanding Hardware and Software Requirements
Enabling Power Pivot
Designing an Optimal Power Pivot Model
Importing Only What You Need
Understanding Why Data Types Matter
Working with Columns or DAX Calculated Measures
Optimizing the Power Pivot Model for Reporting
Understanding Power Pivot Model Basics
Adding All Necessary Relationships
Adding Calculated Columns and DAX Measures
Creating Hierarchies and Key Performance Indicators (KPIs)
Sorting Your Data to Meet End-User Needs
Implementing Role-Playing Dimensions
Chapter 7 - Developing a Flexible and Scalable Tabular Model
Why Use a Tabular Model?
Understanding the Tabular Model
Using the Tabular Model
Comparing the Tabular and Multidimensional Models
Understanding the Tabular Development Process
How Do You Design the Model?
Importing Data
Designing Relationships
Calculated Columns and Measures
How Do You Enhance the Model?
Adding Hierarchies
Designing Perspectives
Adding Partitions
How Do You Tune the Model?
Optimizing Processing
Optimizing Querying
Chapter 8 - Developing a Flexible and Scalable Multidimensional Model
Why Use a Multidimensional Model?
Understanding the Multidimensional Model
Understanding the Multidimensional Model Process
How Do You Design the Model?
Creating Data Sources and the Data Source View
Using the Cube Creation Wizard
Adjusting Measures
Completing Dimensions
How Do You Enhance the Model?
Adding Navigation with Hierarchies
Using the Business Intelligence Wizard for Calculations
Using Partitions and Aggregations
How Do You Tune the Model?
Resolving Processing Issues
Querying
Chapter 9 - Discovering Knowledge with Data Mining
Understanding the Business Value of Data Mining
Understanding Data Mining Techniques
Common Business Use Cases
Driving Decisions, Strategies and Processes Through Data Mining
Getting the Basics Right
Understanding the Data
Training and Test Datasets
Defining the Data Mining Structure
The Data Mining Model
Applying the Microsoft Data Mining Techniques with Best Practices
Using Microsoft Association Rules
Grouping Data with Microsoft Clustering
Building Mining Models with Microsoft Naïve Bayes
Using the Microsoft Decision Trees
Using Microsoft Neural Network and Microsoft Logistic Regression
Using Microsoft Linear Regression and Microsoft Regression Trees
Microsoft Sequence Clustering
Forecasting with Microsoft Time Series
Developing and Deploying a Scalable and Extensible Data Mining Solution
Choosing Between a Relational or a Cube Source for Your Data Mining Structure
Deploying Data Mining Models
Using DMX to Query Data Mining Models
Maintaining Data Mining Models
Fine-Tuning the Data Mining Structure
Keeping the Data Model Relevant
Continuous Learning Cycle
Integrating Data Mining with Your BI Solution
Integrating Data Mining in Your DW and ETL Processes
Integrating Data Mining with Reporting Services
Data Mining in Excel
Part III: Business Intelligence for Reporting
Chapter 10 - Choosing the Right Business Intelligence Visualization Tool
Why Do You Need to Choose?
Identifying Users
Selecting Tools
What are the Selection Criteria?
Business Capabilities
Technical Capabilities
How Do You Gather the Necessary Information?
What are the Business Intelligence Visualization Options?
Using SQL Server Reporting Services
Using Power View
Using Power Map
How Do You Create and Complete the Evaluation Matrix?
How Do You Verify and Complete the Process?
Evaluation Matrix #1
Evaluation Matrix #2
Chapter 11 - Designing Operational Reports with Reporting Services
What are Operational Reports and Reporting Services?
Understanding Analytical versus Operational Reports
Using Reporting Services
What are Development Best Practices?
Using Source and Version Control
Using Shared Data Sources and Datasets
Creating Templates
What are Performance Best Practices?
Investigating Performance
Performance Tuning
What are Functionality Best Practices?
Using Visualizations
Using Filters and Parameters
Providing Drilldown and Drillthrough
Chapter 12 - Visualizing Your Data Interactively with Power View
Where Does Power View Fit with Your Reporting Solution?
Power View System Requirements
Creating Power View Data Source Connections
Creating Data Sources Inside Excel
Creating Data Sources Inside SharePoint
Creating Power View Reports
Using SharePoint to Create Power View Reports
Using Multiple Views in Power View
Creating Power View Visualizations
Creating Tables
Converting Visualizations
Creating Matrices
Creating Charts
Creating Multiples
Creating Cards
Creating Maps
Using Excel to Create Power View Reports
Filtering Data with Power View
Adding Filters
Using Advanced Filters
Adding Slicers
Invoking Cross-Filters
Adding Tiles
Adding Filters to a Report URL
Exporting Power View Reports
Chapter 13 - Exploring Geographic and Temporal Data with Power Map
How Power Map Fits into Reporting Solutions
Understanding Power Map Features and Advantages
Comparing Power Map to Other SQL Server Geospatial Reporting Tools
Understanding Power Map Requirements
Optimizing Your Data Model for Power Map
Using Tours, Scenes and Layers in Power Map
Defining Geography Fields in Your Data Model
Defining Date and Time Fields in Your Data Model
Working with Geospatial and Temporal Data
Visualizing Data Aggregation
Creating a Power Map Tour
Visualizing Data Over Time with Rich Animations
Deploying and Sharing Power Map Visualizations
Sharing Power Map Tours
Enhancing Power Map Deployment and Configurations in Office 365
Chapter 14 - Monitoring Your Business with PerformancePoint Services
Where Does PerformancePoint Services Fit with Your Reporting Solution?
Understanding PPS Features
When is PPS the Right Choice?
Implementing PPS Requirements for SharePoint
Extending PPS Dashboards
Adding PerformancePoint Time Intelligence
Using Interactivity Features
Adding Reporting Services Reports to PerformancePoint
Extending Filters and KPIs
Deployment Best Practices
Following Best Practices for PerformancePoint Data Connections and Content Libraries
Deploying Dashboards Across Dev, Test and Production Environments
Customizing PerformancePoint SharePoint Web Parts
Security and Configuration Best Practices
Configuring the Unattended Service Account in SharePoint
Optimizing PerformancePoint Services Application Settings
Part IV: Deploying and Managing the Business Intelligence Solution
Chapter 15 - Implementing a Self-Service Delivery Framework
Planning a Self-Service Delivery Framework
Creating a Data Governance Plan for Enterprise, Team and Personal BI
Identifying Stakeholders, Subject Matter Experts and Data Stewards
Understanding Industry Compliance Considerations
Managing Data Quality and Master Data
Identifying Target Audience and Roles
Developing a Training Plan
Inventorying Tools and Skillset
Understanding Data Quality Services
Understanding Master Data Services
Managing Data Quality and Master Data in Excel
Business Intelligence Features Across the Microsoft Data Platform Versions and Editions
Defining Success Criteria
Chapter 16 - Designing and Implementing a Deployment Plan
What is a Deployment Plan?
How Do You Deploy Business Intelligence Code?
Using Analysis Services (Multidimensional or Tabular)
Using Reporting Services
How Do You Implement the Deployment Plan?
Planning the Deployment
Designing Scripts
Documenting Steps
Testing the Plan
Training Your Staff
Chapter 17 - Managing and Maintaining the Business Intelligence Environment
Using SQL Server Reporting Services
Configuring Memory
Caching Data and Pre-Rendering Reports
Using Execution Log Views
Working with SQL Server Analysis Services
Using Multidimensional Models
Using Tabular Models
Using SharePoint to Improve Performance
Chapter 18 - Scaling the Business Intelligence Environment
Why Would You Scale the Business Intelligence Environment?
How Do You Scale Each Tool?
Using Analysis Services (Multidimensional or Tabular)
Reporting Services
Using Power Pivot and Power View
Summary
Index ISBN - 9788126556656
|
| |
Pages : 432
|