Portfolio and Project Controls Reporting System in Power BI
Control your project with data-driven decisions. The construction industry is adopting the analytical approach of handling project data faster than ever before. It is the time to grow your skills for controlling the project in unconventional ways, it is the time to transform data into words, convert digits into information and extract the hidden trends and visuals out of the numbers. This new method of analyzing data needs advanced skills in data handling and knowledge of programming languages such as M. Codes and DAX to develop statistical models.
We are providing the most dynamic project controls reporting system, integrated between Primavera P6 and Power BI using M. Codes and DAX. Our reports and dashboards are automated, highly interactive, and are based on Earn Value Management (EVM). With these templates, users can integrate their project data with our tailor-made project controls templates/models and start monitoring their KPIs and trends in a highly advanced and efficient manner than before.
These report models enable users to go back and forth in timescale, filter out the required data such as Area, Zone, BOQ Item, Floor No, Structure Type, Plot No, Material, etc., all with 1 click and analyze the trends in the past and forecast the for upcoming tasks and all-in trademark visuals of Power BI.
These statistical models are applicable in all construction projects, and it does not require hectic working for integration. Only basic knowledge of MS Excel, Primavera P6, and Power BI.
Users will get step by step guide for extracting data from Primavera P6 and integrating it with Power BI. Once the integration is done between your project data and Power BI, you will be able to transform data into information and enhance your earn value management skills and perform cost control, manage your resources in a more efficient way, keep an eye on every single KPI In your project and develop improved strategies for execution. The coding for all KPIs is already done in our models. We use M. Language and DAX codes to structure the raw data, automate the process, and confined the environment for project data to flow from its raw nature into predefined Visuals and KPIs. This process enables our users to have their own robust performance measurement system.
Package
Product 1- Project Performance Reports & Dashboards
- Project Control Reports and Dashboards
Product 2- Portfolio Performance Reports & Dashboards
- Portfolio Reports and Dashboards
Product 3- Portfolio Resource Management Reports & Dashboards
- Portfolio Reports and Dashboards
We are providing three solutions for the automation of project data analytics.
1. Project Earned Value Management Reports
Every project needs a performance measurement system to establish a comparison of current progress with the baseline to analyze the difference of current vs baseline data. The challenge to develop such PMS is the understanding of data, where the data is stored, and how the data is stored then structuring raw data and making an automated process. The biggest reality of project data is that the data is generated every day in the project, so we need to automate the system so that every time when the new data comes it will be converted into information quicker than our imaginations. Our Project PMS is an automated statistical model which enables user to convert their project data into information within few minutes. Our step by step guide will help user to integrate their project data with our statistical model and get all KPIs trends and visuals in one dashboard
Our Statistical model is made for project controls and provides all KPIs which are needed to make the right decisions in the right time. Our KPIs and trends are automatically developed once you connect Primavera with Power BI. These KPIs are descriptive and predictive in nature and enables users to make prescriptive analysis based on available information and trends. These templates will unlock hidden information of your project and user can drill down from a scalar value (KPI) until the root cause of the problem
We have already placed certain important visuals and matrices in the reports and dashboards. Our coding is extremely flexible and can accommodate project data of any industry as far as it is made on primavera P6.
These reports and dashboards will revolve around Earned Value Analysis in two main categories i.e. Earned Value Analysis (Cost) and Earned Value Analysis (Labor). The templates contain all EVM parameters (BAC, PV, EV, AC, SPI, CPI, SV, CV, ETC, EAC, VAC, TCPI) in both the categories, cost-wise and labor wise. The dynamic time scale allows users to go back and forth and investigate what was the situation back then and what could have been done to prevent the issues from rising in past.
These models are vital for lessons learned and can enhance decision-making for future projects. These built-in models will unlock all the hidden information of your past projects and provide trends so that you can learn lessons from your past projects and prevent the bottlenecks in future projects.
We have also placed Budget, Actual and Remaining units for the quantity of your project. As we know, P6 does not allow us to perform EVM in terms of quantity but we can monitor and control quantity as a resource management plan.
2. Portfolio Earned Value Management Reports
Like the project earned value model, the Portfolio EVM model enables users to display the data of all projects of your organization in one place, in one report and dashboard.
This model will provide all Earned Value KPIs at portfolio level, as well as project level. User can filter out the data for single project or multiple projects at a time. There are several KPI visuals already placed which shows PV, EV, AC, EAC, ETC, VAC, SPI, CPI, SV, CV TCPI.
With this dashboard, users can see which project is going ahead of schedule or which project is delayed, where the cost is overrunning, and which project has less expenses than earnings. With the dynamic feature of the time scale, users will be able to go back in time and analyze the situation and make judgments about what should have been done and what was done. The dashboards are highly flexible to use, they allow users to drill down from portfolio level to project level and further drill down to area, zone, floor, BOQ div, or even activity ID level. You only need to update the primavera P6 regularly and these models will automate your portfolio data and bring the unseen information in front of you via different charts visuals and metrics.
Portfolio Earned Value Model provides the insight of all the parameters of EVM as Cost and Labor separately. User can analyze descriptive trends that show which project has earned how much scope and spent how many hours and cost. With predictive KPIs and trends user can forecast what is most likely going to happen, and in which area, zone or Items prescription is needed to bring back the projects on track.
3. Portfolio Resource Management Reports
The Portfolio Resource management model is like a portfolio earned value model as it also deals with multiple projects at one place. In RMP user will be able to analyze data at resource level it can be material resource labor resource or non-labor resource. This model does not provide performance-based information, which is Earned value analysis, rather it generates reports from the resource management point of view. This model will enable users to see how many resources they have in their organization, in which project the resources are deployed and what type of trades are being used in each project, how many of the resources are used at any particular time period, how much quantity is remaining and most likely what are the peaks and lows of manpower or machinery or quantity in each project. These reports will help management to foresee that when they need the resources and when they can release them, or from which project the resources can be shifted to another project without affecting the other project
