By combining the Data Warehouse module with the PPM software application, your project decisions are given a data boost!
The data entered by your project teams (schedule, timesheet, flash reports) are extracted and enriched with context elements (project metadata, times, time-stamping, user). Extraction is planned or on request.
The data is recompiled in an optimised format for the decision-making template. The data transformation automatically propagates the configuration changes (area for analysis, new project metadata, etc.).
The relational databases associated with the datamarts are synchronised with the project data updates.
If so, the Data Warehouse module is made for you. It makes all the information on your Project Monitor platform available in a database optimised for your business intelligence tools (Power BI, QlikView, Business Objects, etc.).
With the Data Warehouse module, exploit 100% of the Project Monitor data. Give your managers and PMO a decision-making tool in which nothing escapes.
Specific decision-making tools in addition to the Project Monitor reports centre. Autonomy in advanced queries.
A comprehensive database that can be extended to other data in the information system to meet the specific needs of the portfolio project stakeholders.
An ETL which automates the extraction and conversion of the data from your project platform to feed and update the decision-making databases.
Once the technical architecture and the module are configured, everything is automated and secure. The relational databases are updated without any risk of a break in the system and data corruption.
The key data of your project portfolio is no longer stored in exports in Office format but secured in your decision-making infrastructure.
The decision-making tools enable the easy handling of large volumes of data for configurations with large databases and/or long data histories.
Data updates are planned once a day by default. Updates on requests can also be triggered from the Project Monitor administration panel.
The Data Warehouse module is available for SaaS and On-Premises configurations. ETL feeds the data from a database stored in the Virage Group private cloud.
As the data is supplied and stored by Project Monitor, it will be restored and updated during the next synchronisation.
The Data Warehouse module is compatible with all the decision-making solutions using relational databases: Power BI, Tableau, QlikView, Business Objects, etc.