In this post, we are showing you the first steps, and the necessary tools to connect Primavera P6 to Power BI.Ĭhaos is over. Project 2080 has joined the bandwagon of content personalization related to planning and project controls. Content personalization is no longer just a Netflix thing. In addition, we will now be able, on a single platform, to create and publish content packages for specific teams, clients, or entire organizations. Natural language has reached the planning and project controls industry. We can ask you questions like “what are the activities with a Soft Constraint?” and get an impressive, interactive visualization in return. Our analysis function, based on the data that feeds us every day, and our help and support in making decisions within our projects, we are now able to do it in real-time, with reports in the cloud, on our mobiles.Īnd what about the artificial intelligence of Power BI. Planning and Project Controls have never experienced this evolution and improvement before.
#PRIMAVERA P3 DATABASE HOW TO#
In this way, we can even prepare reports about how to do the project schedule quality assessment in our portfolio. Dashboards based on the data analysis that feed our activity schedules, such as durations, dates, milestones, resources, costs, etc. Power BI is important for the planning and project controls industry as it helps us provide a better service when it comes to preparing reports and dashboards for our clients. Why is Power BI so important for Planning and Project Controls? With that said, and before we show you how to connect Primavera P6 to Power Bi, let’s see why Power BI is so important for planning and project controls. All this, located in the cloud and capable of keeping us informed in real-time, through a holistic view of the key metrics of your project or portfolio. Powered through data sources such as Excel spreadsheets, cloud services, streaming data, and local databases. Power Bi helps us create dynamic and interactive dashboards. For one, not all projects are managed separately-because data is stored in a central database, rather than on the user’s PC, P6 enables managers to access project data anywhere, at any time.Power BI, according to Microsoft’s official website, “ is a cloud-based business analytics service that provides you with a single view of the most crucial data in your business“. This type of relational database management system offers many advantages over the file structure system used in P3. Project data is stored in a central project database that resides on a server running Microsoft SQL Server, SQL Express, or Oracle. P6 is built using the platform of the future. Due to technological limitations and other factors, development of P3 has been discontinued. This single database design increases efficiency, consistency and repeatability, saving organizations time and money.Īdditionally, while P3 has used the extremely reliable Btrieve database engine since 1985, its 16-bit technology is quickly becoming outdated. While P3 maintains each project as a separate group of files–each existing completely independently of the others–P6 stores all projects in a single database, allowing greater flexibility to view, manage, and analyze projects singularly, as part of a master project, program, or enterprise. However, P6 includes the addition of a number of new features requested by our user-base including the ability to track and unravel multiple float paths, enhanced graphical reporting with features like multiple, formatable curtains, and the long awaited option to UNDO! New features and enhancements will continue to be added to this product with each successive release. Both P3 and P6 are project management tools that allow users to plan and control projects with a high degree of accuracy, keeping them on time and under budget.