#ProjectVConf session summary for #ProjectOnline #BI #PowerBI #Excel #SSRS #JavaScript #SSIS

It’s been a few weeks now since the Project Virtual Conference, for those of you that missed it, sign up here: http://projectvirtualconference.com/ and you can view the recordings. This post will give a summary of my session on Project Online BI Made Easy: http://event.projectvirtualconference.com/B002/ The aim of this session was to give an overview on... Continue Reading →

I am speaking – Project Virtual Conference #ProjectOnline #BI

Quick post to reference my session for the Project Virtual Conference on 22nd October 2015: http://projectvirtualconference.com/sessions/project-online-bi-made-easy/ See some of the great reporting options for Project Online. For the full schedule see: http://projectvirtualconference.com/schedule/ To register for this great free event (no travel expenses either!): http://projectvirtualconference.com/register/

#ProjectOnline data via #ODATA and #SSIS in #SQL database table delta sync example #BI #Office365

Microsoft recently released some great documentation and an example SSIS package on only pulling down the changes from Project Online to your custom SQL database – this will improve the efficiency of your Project Online SSIS packages. I recommend you take a look if you haven't already: http://msdn.microsoft.com/en-us/library/office/dn794163(v=office.15).aspx http://www.microsoft.com/en-us/download/details.aspx?id=43736 For a walkthrough of an example SSIS... Continue Reading →

#ProjectOnline data via #ODATA and #SSIS in #SQL database table on-premise #MSProject #SharePointOnline #BI #SSRS #Office365 #Cloud

Following on from my post earlier today regarding the SSIS component that enables you to extract data from ODATA feeds in Office 365, I have created a blog post that demonstrates this new functionality. See the steps below: Firstly I installed the SQL Server data tools and Integration Services feature on my Test Project Server... Continue Reading →

#Odata #SQL SSIS component now available for SQL Server 2012 #ProjectOnline #SSRS #SharePointOnline #SharePoint #BI

Quick post to let you know that the SSIS component to export data via ODATA that was mentioned here is now available for download, see the link below: http://www.microsoft.com/en-us/download/details.aspx?id=42280 This will enable you to copy data from Project Online into a custom SQL database, from there you can easily create SSRS reports, custom OLAP cubes,... Continue Reading →

Blog at WordPress.com.

Up ↑