M.R. on 05 May 2016 00:12:11
Create a connector to integrate PowerBI dashboard with Primavera P6
- Comments (32)
RE: Integrate PowerBI into Primavera P6
Hi,
I found a link about this Integration of PowerBI into https://goo.gl/rcng7d Primavera P6, hope you will get the answer : https://datamonkeysite.com/2017/04/18/integrated-project-control-system-using-powerbi/
RE: Integrate PowerBI into Primavera P6
Hello, M.R
One of the most popular discussions in planning forum is how to have an integrated project control system, every practitioner has a different opinion how it must be done, and of course you get a lot of marketing from people trying to sells their systems
In this blog, we share high-level description of a data warehouse built using PowerBI desktop.
Data warehouse are not widespread in the construction industry, because the reporting specifications are different from project to project, and every client has a different systems and tools, and trying to have a standard system works only if you are the main contractor but if you are a subcontractor you have to adopt the client system.
For read more click here : https://goo.gl/1FNkjB
RE: Integrate PowerBI into Primavera P6
This would massively increase the uptake of power BI across the $9T construction industry.
RE: Integrate PowerBI into Primavera P6
vote up, need this tool for P6 Dashboard update
RE: Integrate PowerBI into Primavera P6
We are having a good start off on tying our data models together. Currently we keep the cost in our JDE sql database, oure EVM data in a sql database and P6 in its own sql database.
we can easily, make relationships ad nauseam....
our success is based on using the right tool for the right job.
P6 is kept in its place - we only use it for identification of critical path and competing critical paths, and resource requirements.
I have over 300 P6 licenses and this is working well.
however, a quick link to the data would be super helpful. we currently run flat reports to excel, apply query steps and push to model.
direct hooks would save 1000's of man-hours per year.
RE: Integrate PowerBI into Primavera P6
Niels do you use sql server or oracle as a backend ?
RE: Integrate PowerBI into Primavera P6
If anyone can supply a multi-purpose data model? That would be great! Connecting the right tables and fields for further analysis like resources, cost, EVM... Keep us posted please
RE: Integrate PowerBI into Primavera P6
it will be nice to have a native connector, but i guess it is up to oracle to do that, which i doubt they will ever do.
i had build a small tool to read an xer file, you may find it useful
https://datamonkeysite.com/2017/03/11/using-powerquery-to-read-an-xer-file/
RE: Integrate PowerBI into Primavera P6
Hi, Any updates ??
That will be so useful !
RE: Integrate PowerBI into Primavera P6
Any update on this connector and if it is becoming available