What is Power Pivot? Power Pivot is a powerful yet unappreciated data analysis and modeling tool available right in the Excel environment. It allows you to collect data from different sources and create a connected data model. In practice, this means you can pour all the data out of your existing database systems, connect it … Continued
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
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
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