How to Export Primavera P6 Data into Power BI

Project planners and schedulers spend a lot of time doing repetitive work in Excel. Its not uncommon to spend 20% of your time updating Primavera P6 and 80% of your time creating the final report in Excel. The purpose of this tutorial is to show how the Primavera P6 report generating feature along with Power … Continued

Power Query – The Data Wrangling Tool of Your Dreams

What is Power Query? Power Query can be seen as a free ranging data wrangling tool. As a cowboy uses a lasso to round up cattle, you can use Power Query take the unruly data you have and convert it into a format that can be used for report building and data visualization. Power Query … Continued

Business Intelligence Tools for Project Controls

The Data Challenge for Project Controls In the last 15 years the amount of data produced by an average construction project has exploded. In an effort to improve project outputs, we have really embraced software systems across the design, procurement and construction across the construction process. All indications are that this will increase in the … Continued

Case Study: Sharing Primavera P6 Data with Power BI

Communicating a detailed project schedule is not easy. I have spent many hours creating a detailed project plan, carefully reviewing and resource loading the activities. Everyone agreed to the performance baseline as the project kicked off, the issue was that once the whirlwind of daily activities started they project team did not have the time … Continued

Retag Thousands of Rows of Data in Seconds with Power Query

Incorrectly formatted data is the bane of a project control professionals life.   The start of a project is often a chaotic time. Everyone has competing priorities and the data naming conventions are not always clearly communicated at the start of a project.   Take for instance an example where you are receiving time sheet … Continued

Aligning Time Sheet Dates with Power Query

Handling differently formatted dates in Excel can be a real pain. This example is based on a time sheet problem that I came across. I was trying to combine time sheet data from different time sheet systems. One system cut off the weekend on a Friday of every week and the other system cut the … Continued

How to use Power BI with Primavera P6 (and probably get a raise as well)

Project controls reporting sure can be a pain. Your boss might ask you for a report on project progress with actual hours versus earned hours. These types of understandable, concise reporting within short time periods is a big part of the project controls role. It’s important that you have the ability to create meaningful reports … Continued

Certification for Project Planners

P6 Users

Training Certification – What is the best Certification for Primavera P6 Users?   I have done training courses that focus on Primavera P6 software and courses that focus on the broader role of project planning. In my experience, courses that focus on the wider role of project planning give you the best bang for your … Continued

What Websites Will Help Me to Learn How to Use P6?

Learning Primavera P6 online

Websites to learn how to use Primavera P6 There are two important parts to learning to use Primavera P6.  You need to know the principles of project controls work and how they are applied in project planning and controlling. You then have to take those principles and techniques and implement them using Primavera P6. You need … Continued

How do I Download and Install Primavera P6?

Installing Primavera P6

P6 can be difficult to install. The software comes in two parts. There is a software interface that connects to a SQL database. There are a number of versions of the software that work on a number of versions of windows. There are also MS SQL, Oracle SQL database options. The easiest version for a … Continued