0
17 years of experience17 years of Excellence
SUBJECTS
ADV. SEARCH
Indian Books on Discounts
  Applied Microsoft Business Intelligence
 

Applied Microsoft Business Intelligence

by Patric Leblanc, Jessica M. Moss, Dejan Sarka

  Price : Rs 699.00
  Your Price : Rs 594.15
Discount
15
Out of Stock
  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
Credit Cards
Payment accepted by All Major Credit and Debit Cards, Net Banking, Cash Cards, Paytm, UPI, Paypal. Our payment gateways are 100% secure.
Check Delivery
Books of Similar Interest
12%
Object-Oriented Analysis and Design, Development  of Static & Dynamic Model
by Rashmi Mehta
22%
Paperback Dreams
by Rahul Saini
10%
Weekend Baker
by Abigail Johnson Dodge
18%
The History Of Napoleon Buonaparte (New)
by John Gibson Lockhart
15%
Handbook of Postharvest Technology: Cereals, Fruits, Vegetables, Tea, and Spices
by Gorur G. Raju , Amalendu Chakraverty , Arun S. Mujumdar
Best Book Mart
Support

Call Us Phone : +91-9266663909
Email Us Email : support [at] bestbookmart.com
Working Hours Timing : 10:00 AM to 6:00 PM (Mon-Fri)
Powered By
CCAvenue
SSL Protection