Data Warehouse module
By combining the Data Warehouse module with the PPM software application, your project decisions are given a data boost!
An ETL to synchronise your Data Warehouse with your PPM platform
Automatic extraction of project data
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.
Transformation into decision-making data
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.).
Datamart feeding and synchronisation
The relational databases associated with the datamarts are synchronised with the project data updates.
.
Do you want to have information to help you make your project decisions? In addition to the library of 50 dashboard templates integrated into Project Monitor?
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.
Why opt for the Data Warehouse module?
- Multidimensional analysis of your project portfolio
- Extension of the data model with other relational databases in your information system (financial IS, HR IS, etc.)
- Preparation of advanced indicators for your strategic decision-making
- Unlimited query capacity for your Data Scientists
- Grouping of heterogeneous data sources to prepare decision-making support dashboards
- Facilitated consolidation of large volumes of data
- Direct access to dashboards for the end users
“The analysis capacities are increased thanks to the Project Monitor Data Warehouse module. We have a comprehensive control centre for our project portfolio!”
CIO
Specific decision-making tools in addition to the Project Monitor reports centre. Autonomy in advanced queries.
PMO
A comprehensive database that can be extended to other data in the information system to meet the specific needs of the portfolio project stakeholders.
Technical Administrator
An ETL which automates the extraction and conversion of the data from your project platform to feed and update the decision-making databases.
From the Project Monitor Timesheet to a Department’s Resource Dashboard
- Timesheet entry in Project Monitor by the project teams
- Validation of the timesheet entries by the project managers and the PMO
- Automatic synchronisation process of the Data Warehouse with the data
- Injection of the data and calculation of the resources dashboards
- Organisation and running of the management meeting… and decision-making to optimise resources management
They use Project Monitor Data Warehouse
✔ Time saved in the production of the Project and Project Portfolio Dashboards
- For report updates, crossed analyses and advanced analyses: no more need to extract raw data and compile data in the same dashboards each time.
- For changes of financial year/year: no more need to create the reports again. You can continue/improve/adapt the existing ones.
✔ Reliability of the architecture
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.
FAQ – Data Warehouse
How often is the data updated?
Data updates are planned once a day by default. Updates on requests can also be triggered from the Project Monitor administration panel.
Can the datamart be used in SaaS mode?
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.
What can I do if my decision-making data is deleted?
As the data is supplied and stored by Project Monitor, it will be restored and updated during the next synchronisation.
What Business Intelligence tool can I use?
The Data Warehouse module is compatible with all the decision-making solutions using relational databases: Power BI, Tableau, QlikView, Business Objects, etc.