Business Continuity Disaster Recovery

Business Intelligence

Privacy

Project Hosts Security

Project Management Cloud Family

Single Sign-On and Active Directory Integration

SSRS Report Enabler for Project Online

CRM Custom Cloud

PPM Custom Cloud

BrightWork (PPM) Online

Hosting Services Options

SharePoint Custom Cloud

Tours-Trials-Demos

Azure Managed Services Pricing

PPM 2016 Upgrade

Project Server Admin Services

SharePoint Admin Services

Remote SP Admin Pricing

SharePoint 2016 Upgrade

SharePoint Azure Services

Administration Services

Person-2-Person™ Support

Microsoft Project Server 2013 Cloud Choices

Microsoft Project Online

CRM User Types

The Microsoft Project and Portfolio Management (PPM) solution, built on Project Server, SQL and SharePoint services, supports multiple tools and data sources for creating Business Intelligence (BI) reports. All of these tools and data sources are available on dedicated server deployments from Project Hosts, but there are restrictions for deployments that utilize shared servers.

This document describes four versions of the Project Hosts Business Intelligence Package for four different choices of shared vs. dedicated servers.

In addition to the BI tools described here, customers in any Project Hosts solution can create an unlimited number of custom fields and views. An advantage to these views over BI reports is that they are completely integrated with the PWA permissions model. For example, one can create a Project Center view that only allows users to see projects they are on. These kinds of granular permissions are much more difficult with the BI tools described below.

 

BI Tools

There are four main tools that can be used to create PPM BI reports. The four tools are:

 

Data Sources

There are three main types of data sources that can be used for PPM BI reports. Some of them can be used in shared solutions and some can be used in various levels of dedicated solutions. The three types are:

 

Project Hosts BI Package Options

   
Basic BI Package for shared server deployments

The Basic Business Intelligence package is for deployments that utilize both a shared application server and a shared database server. The allowed BI tools and data sources are:

 

Standard BI Package for dedicated app, shared DB server deployments

The Standard Business Intelligence package is for deployments that utilize a dedicated application server and a shared database server. The allowed BI tools and data sources are:

 

Real-Time BI Package for dedicated app and dedicated DB server deployments

The Real-Time Business Intelligence package is for deployments that utilize a dedicated app server and a dedicated database server or one dedicated server running both apps and databases. The allowed BI tools and data sources are:

 

Enterprise BI Package for dedicated app, dedicated DB servers with SQL Enterprise

The Enterprise Business Intelligence package is for deployments that utilize a dedicated app server and a dedicated database server, with the Enterprise version of SQL Server running on the app server. The allowed BI tools and data sources are:

 

 

Project Hosts PPM Business Intelligence Packages

  BASIC
BI
Package
STANDARD
BI
PACKAGE
REAL-TIME
BI
PACKAGE
ENTERPRISE
BI
PACKAGE
App Platform Shared App Server Dedicated App Server Dedicated App Server Dedicated App Server
DB Platform Shared DB Server Shared DB Server Dedicated DB Server Dedicated DB Server
(SQL Enterprise)
 
BI TOOLS
Excel Services
Dashboard Designer  
SQL Reporting Services*  
PowerPivot and PowerView      
 
Allowed Data Sources
Odata
OLAP  
Direct DB Access    

 

* SQL Reporting Services - native and integrated services supported

 


"…many organizations have needs for deep customization, white-glove services, or support for complex models like hybrid hosting. For these customers, Project Hosts' PPM Custom Cloud offers a great option."

Ludovic Hauduc, General Manager of the Microsoft Project Business Unit
Some of Our Clients
Microsoft Partner
Gold Cloud Platform certification
Gold Hosting
Gold Project and Portfolio Management
Silver Collaboration and Content
Silver Data Analytics
Project Hosts twitter    Project Hosts Linkedin    Project Hosts Google+    Project Hosts Blog