Free FluentPro PMO solution for Microsoft Project Online and Microsoft Project Server 2013

FluentPro PMO Free Edition

FluentPro Software Corporation announced today at the PMI Global Congress the official launch of a FluentPro PMO Free Edition, a ready-to-use, pre-configured PMO (Project Management Office) solution for Microsoft Project Online / Project Server 2013 platform. This free edition is a great addition to FluentPro PMO family and helps customer get better experience from Microsoft Project Online.

What is FluentPro PMO

FluentPro PMO includes:
  • set of custom fields
  • multiple project types
  • project site templates
  • generic resources
  • project lifecycle workflows 

How to get FluentPro PMO Free Edition

Configuration deployed to PWA automatically by FluentPro's state-of-the art provisioning system based on FluentPro FluentBooks technologies and comes with 3 month unlimited subscription of EPM Pulse, our data visualization platform for Microsoft Project Online.

Visit our website and contact us.

About FluentPro Software

FluentPro Software Corporation is a leading software development and Project Server / Project Online implementation company. We focus on optimizing the way how companies work with Project Online / Project Server by bringing best available technologies to the companies. We enable you to manage configuration, migrate data and configuration as well get all the best from Project Server including resource management, portfolio management, IT portfolio management, business intelligence.

Microsoft Project Online Reporting Options

I've spent couple month without paying too much attention to my blogs - was busy implementing some organizational changes, products portfolio changes and preparing new product launches here at FluentPro Software. From now, I promise that will create couple blog posts every month.

In this post, I will provide high-level overview of existing reporting options for Project Online with some comparison. We will include our products but will try to be objective as much as I can :-) and will provide overview of the existing technologies / platforms.

Technologies are:
- Excel Services
- PowerView
- Power BI
- FluentPro EPM Pulse

If there is another technology - we would be more than happy to include into this comparison.

Comparison chart

Excel Services
Standard reporting feature. You use Excel to get OData Feed and then using Pivot Tables you can transform the data. Great for 90% of tasks, but remaining 10% when you need to present data in some specific way require a lot of work, using hidden sheet, referencing cells etc.
You can buy pre-built reporting packages from several PPM Partners.
Learn more:

Great and quite easy tool to create interactive dashboards. Great for 90% of tasks, but for remaining 10% it is impossible to present data in some specific format. For example - value of 1 field with some formatting.
Learn more:

Using SSIS users can get ODATA feed and get it to SQL database. This bring ability to create datawarehouse and sync data from Project Online to it. Then you cna use full stack of reporting tools (for example SSRS). Unfortunately, reporting DB structure is not 100% matching OData feeds, so it requires re-working, mapping and other development activities to make Project Server SSRS reports working with this data. At minimum, your are required to create/buy VM with SQL Server, configure SSIS; SSRS in native mode, create DB, deploy and change SSIS packages, and schedule them to run. Then you need to move / change your SSRS reports.
SSRS reports can be embedded into PWA pages but there is still a challenge of double authentication - one for Project Online and one for VM + you need to manage security since VM is internet-facing.
Learn more:

FluentPro EPM Pulse
Disclaimer: We are subjective here since it is our product and we believe it is a great product.
With EPM Pulse users can build portfolio and project level dashboards using a "drag-and-drop" approach. EPM Pulse is based on "widgets", every widget is a chart that can be added to dashboard to show pre-defined information. IF needed, users can extend system by creating new custom widgets / modifying existing ones and this requires basic SQL knowledge; All widgets are re-usable; being created once can be used on multiple dashboards and moved to other PWAs. EPM Pulse supports rendering of SSRS reports and since we use data schema that is very close to Project Server Reporting DB, it is possible to use same reports from on-premises with only one minor change - adjusting naming of parameters.
Learn more:

Power BI
Latest and greatest powerful data visualization platform from Microsoft that can pull data from multiple sources. Supports big volumes of data. Great for creating high-level "picture". Requires additional subscription.
Learn more:

SSRS for Project Online

On Microsoft Project Conference, Microsoft announced that SSISwill support ODATA - that brings ability to dump data from Project Online into SQL Server database and use SSRS.

While it is great it is not a complete solution:

1. You need to create a mapping to data
2. You need to change  / adjust your reports
3. Data is not real-time - it comes on the schedule and your reports will not show the latest information.
4. You need your own or rented infrastructure (Azure or hosting)

FluentPro has an alternative solution and it is available now at the Office Store - FluentPro Online Reporting Services app for the Project Online -

There are 3 advantages of FluentPro Online Reporting Services :

1. We do render your existing reports that you have right now. You don't need to change your reports. We do your reports verification before we add it to your account.
3. We do not store your data outside
4. We do real-time data rendering - we always show you latest information from the Project Online immediately.

The App is distributed on a freemium model - it come with free execution points (5,000 points) and comes with several free reports that you can use any time until balance is used (one report uses anywhere from 20 to 300 points depending on complexity).  You can buy additional execution points any time.

Give it a try, it costs nothing but you can run timesheet reports, status reports and project charter.

Download App

Solution Starters for Microsoft Project Server 2013

Our team migrated Solution Starters for Project Server 2010 to the Microsoft Project Server 2013 platform. We are distributing Solution Starters for Project Server 2013, free of charge, available for download with source code and with wps, ready for deployment. Please note - solution starters are available as-is, free of charge and FluentPro Software Inc, FluentPro Software Corporation are not responsible for any direct and indirect damage. Please try / install solution starters at your own risk.

Available Solution Starters for Project Server 2013:

  • Bulk Edit Tool
  • Excel Project Cost Capture
  • Programs
  • Project Workspace List Viewer
  • Report Builder Tool
  • Workspace Project Custom Field Web Part

We are happy to provide commercial support for Solution Starters. We can help you with all your needs in regards to the Solution Starters:

  • Deployment of Solution Starters to your servers
  • Troubleshooting of Solution Starters deployment
  • Customization of Solution Starters
  • Adding new features to the Solution Starters functionality

You can download solution starters from our website - .