Construction Viz

Project Management Perfect

project management information system

The new Construction Viz Questionnaire component provides even more choice

Project Management Tools |

In construction, questionnaires are essential for gathering qualitative and quantitative information on a project. As a project manager, you want your field team to use questionnaires to report on various construction activities including, but not limited to, job site safety, project progress, quality control, identification of issues and defects, and adherence to specification and contractual requirements.

For those using Construction Viz, you may already be familiar with our standard Area of Work (AOW) component which allows you to create ad hoc questions in the Daily Report or Inspection forms. Field personnel respond to the AOW questions through set yes, no, and N/A response fields. While the functionality of the AOW component has worked great for documenting and reporting on field activities and project progress, we wanted to give our clients even more flexibility when creating unique questionnaires.

Area of Work (AOW) Component

Introducing the new customized “Questionnaire” component, for any Construction Viz form!

The new “Questionnaire” component expands on our standard AOW component in multiple ways:

  • Custom Deployment. Your customized “Questionnaire” component is deployed per your requirements. Name your component and choose from various response field types that will be available in questionnaires within your component, including:
    • Text fields. Capture open-ended responses.
    • Standardize responses and minimize data input.
    • Date fields. Capture key dates, such as start and/or completion dates, delivery dates.
    • Number fields. Restrict responses to numerical values to track various measurable data such as quantities, hours, cost, etc.
  • Dynamic Component Configuration. You can create multiple questionnaires within your custom component, and have full control over configuration:
    • Component Configuration. As the project progresses, you can create new, or hide old, questionnaires, and re-order the questionnaires within the component so the questions are responded to in a logical sequence of project activities, etc.
    • Questionnaire Configuration. For each questionnaire, restrict how field personnel respond to your questions by selecting from the available response field types, and configure the order of the active columns and individual questions in which they appear within the questionnaire.

New Questionnaire Component

More than one customized “Questionnaire” component can be deployed within any Construction Viz form, and each component can be uniquely customized and configured, giving you endless possibilities for gathering the information you need manage your project.

The customized “Questionnaire” component is just one of many dynamic components we have available for Construction Viz. Let us customize your construction management experience. Check out our Construction Viz features page to learn more about what’s possible. And you can schedule a consultation and demo to discover how Construction Viz can enhance your project management workflows.

No PMIS is an Island: Integrating Smartsheet and Construction Viz

Reporting |

It is not uncommon for organizations to use many disparate web-based project management tools on a construction project. From real estate transactions, environmental assessments, and contract awards to project scheduling, the mix of software systems used across construction organizations can span many different departments and stakeholders.  The challenge is integrating these various solutions into a single view of the project and ensuring the aggregated data is accurate, reliable, and timely.

Smartsheet is one such project management tool we often encounter. Smartsheet is used across many industries and can be a data source and reporting solution for construction information. So it made sense for our team to integrate Smartsheet with Construction Viz to allow our clients using this tool to have the best features of both applications.

While Smartsheet has an API for integrating data, our goal was to build flexible integrated solutions to solve our clients’ unique data challenges. Construction Viz can leverage SQL and SharePoint as the back-end database – with the specifics of how this works depending on the selected apps, client data restrictions, and client-specific customizations. Our Smartsheet integration solution thus needed to be flexible and scalable while offering real-time connectivity to Smartsheet for both SQL and SharePoint.

We deploy our SQL integration solution as an Azure WebJob within an Azure web app. Utilizing Azure web apps as the execution platform enables easy scheduling, automatic restarts, guaranteed stability and uptime, built-in logging, performance tracking, and nearly infinite scalability. Our SharePoint integration solution utilizes industry-standard connectivity via SharePoint’s REST Service.

Intergration Examples

SQL Integration highlights

  • A customer needed a Two-way integration with Smartsheet, so both systems are always up to date.
  • Users can use schedule data created in Smartsheet in our Construction Viz Project Tracker and a custom performance metrics application, so data needed to flow seamlessly between both systems.
  • ConstViz application extensions allow the Customer to add and remove Smartsheet Links as needed for a no-code expansion of the integration scope to new projects.
  • Integration can be scheduled daily with refresh rates that can be adjusted as needed.
  • For troubleshooting any potential integration issues, we implemented user-managed error logs.

SharePoint Integration highlights

  • A customer needed a simple One-way integration with Construction Viz, which allows Smartsheet to access document libraries.
  • Ability to handle large daily data loads as Construction Viz program sites may include up to 6,000 projects.
  • An integration approach that overcomes Smartsheet API limitations:
    • The Smartsheet API limits automated file attachment uploads to 30MB
    • The SharePoint online attachment limitation is 250MB
    • We built a solution to log oversized files into Smartsheet in the appropriate locations and hyperlinks back to the original SharePoint files for retrieval via other methods

Smartsheet is one of many integrations into Construction Viz (SQL and SharePoint) that we have built. From Oracle P6 to Arc GIS, we understand the client’s need to centralize data to manage large-scale construction projects. You can find out more by requesting a consultation here.

Training Made Easy with Construction Viz and Microsoft Stream

Collaboration |

If you are unfamiliar with Microsoft Stream, in a nutshell, it’s a video management service included with your Microsoft 365 subscription. To find out more, you can check out a prior post, “Microsoft 365 Stream for your Construction Videos.”

Stream home page
Stream home page

Stream isn’t just another file drop-off application. It is designed to manage videos specifically. The real value of Stream is the ability to aggregate and share all of your videos into a central location accessible from your Microsoft 365 login.

How can I use Construction Viz and Microsoft Stream to help with training project teams?

Construction Viz is an enterprise construction PMIS that can be deployed into a Microsoft 365 tenant. It allows you to leverage all Microsoft 365 services using your same Microsoft 365 credentials.

On-demand training videos can be made available as part of a Construction Viz deployment. With Stream, Construction Viz training videos can be easily uploaded and shared across Microsoft 365 Groups and Users, including guest users. Further, these videos can be accessed from within any Construction Viz Hub.

Construction Viz Links App with link to a Stream training session
Construction Viz Links App with link to a Stream training session

Want to create training videos and add them to Microsoft Stream, but you are not a videographer? Not a problem.

Microsoft has recently provided the ability to publish PowerPoint presentations directly to Stream. So, if you are a PowerPoint guru, you can easily make robust training videos from your existing presentations.

PowerPoint Publish to Stream menu
PowerPoint Publish to Stream menu

Sounds promising, but we like to use surveys and quizzes to test learning objectives.

You can add surveys and quizzes to Stream videos using Microsoft Forms. Survey results are automatically tabulated and made available within the Forms app in Microsoft 365.

Microsoft Forms quiz added to Stream training
Microsoft Forms quiz added to Stream training

What if we like to schedule and provide both in-person and virtual live training sessions?

You can live stream events in Stream! These events can be added to user calendars, and the recordings can be available for future on-demand training.

So, if you want to do video training, check out Microsoft Stream.

If you are looking for a project management information system (PMIS) that uses Microsoft 365, request a Construction Viz demo.

Capture Construction Project Reviews and Approvals on Just About Everything!

Dashboards |

Construction projects involve owners and contractors submitting, reviewing, and approving information throughout the project’s life cycle. It’s a complex web of information transfer, often time-sensitive, and requires a well-documented e-paper trail to avoid legal issues.

For some projects, the review and approval process needs to be more granular than just the form, set of documents, or a drawing set level; it needs to be down to a single document page or an individual drawing sheet.

That level of detailed review tracking is why we created the Construction Viz Review Comments Matrix and the Contractor Response Matrix components. These components work in tandem to ensure detailed comments and approvals are captured at the right level of detail to improve communication, avoid delays, and prevent future claims.

For example, you might want to capture internal owner/CM team comments on each page of a contractor’s project management plan attached to their submittal. Also, you might want to keep some comments internal, while others you might want to share with the contractor.

Review Comments Matrix component

With the Review Comments Matrix component, your team can add comments for each individual page of the attached project management plan. The component automatically logs all saved comments into an interactive grid not visible to contractors.

Suppose you need to share comments with the contractors. In that case, you can select the comment(s) and click Finalize Selected, making those comments available to the contractor in the Contractor Response Matrix component and denoting that comment as a final comment.

Contractor Response Matrix component

The Contractor Response Matrix component displays only those comments needing a response from the contractor.

The component captures the ongoing back and forth exchange between the owner/CM and the contractor in an interactive grid complete with comment-specific statuses. The contractor just needs to click edit next to each comment and add their response.

What happens to the comments if the contractor needs to revise and resubmit the form? In the case of a revision, the component automatically includes all previous comments in the form revision, ensuring the complete history is always available for reporting.

These two components combine to provide that extra level of review capability that can help improve turnaround times and minimize communication issues. As with any Construction Viz components, they can be added to any form, turned on or off, or modified as needed. This functionality is excellent for Submittals and RFIs to ensure contractor responses are tracked and given a formal status before the overall form submission is accepted.

Get a demo of Construction Viz

Construction Viz is the only enterprise-scale construction management solution available for Microsoft 365. You can learn more about what makes Construction Viz different from its competitors and the available apps on the Features and Apps pages. To set up a demo, click here.

Visualize Your Project Data in a Calendar View with Microsoft Lists and Construction Viz

Project Management |

We recently shared how you can generate a Power BI dashboard from Microsoft Lists in three clicks with Construction Viz. Here is another handy tip for using the two applications together. 

To recap, the Microsoft Lists app allows users to view and create interactive lists for managing items such as tasks, issues, and even assets for a construction project. If you have used Microsoft SharePoint Online, Lists will seem familiar since it uses the same list technology. 

Using Microsoft Lists calendar view in Construction Viz 

Microsoft recently released a new Calendar view for Microsoft Lists. It's a nice feature that allows you to visualize your list data in a familiar calendar UI. 

Because Construction Viz and Microsoft Lists both utilize Microsoft SharePoint lists and libraries under the hood, this new feature can provide a nice calendar view of project data, such as all of your RFIs by the submitted date and the target due dates. Check out a preview in the animated graphic below.  

CV_Lists_Calendar-View

You can find out more about Microsoft Lists here.  

Want to manage your construction projects in Microsoft 365? 

Using the Microsoft Lists calendar view is just one of many integrations with Microsoft 365 services that Construction Viz can leverage. Construction Viz empowers you to manage construction projects in Microsoft 365. Better yet, Construction Viz is available as standalone apps, allowing you to combine the specific features you want into a project management tool that is perfect for you and your workflow.  

You can request a demo of Construction Viz here to learn how to get the most out of your Microsoft 365 investment to manage your construction projects. 

Stay Legally Compliant with Microsoft 365 and the New Construction Viz Records Management Feature

Forms |

The new Construction Viz records management feature of our construction form apps builds on Microsoft 365 and SharePoint to add capabilities optimized for construction project management. Read on to learn more.

Construction organizations generate a significant amount of information on projects. Everything from documents to construction forms is collected, organized, reviewed, and stored day-to-day. Once final, all these various materials need to turn into records.

Microsoft defines a record as follows:

“A record is a document or other electronic or physical entity in an organization that serves as evidence of an activity or transaction performed by the organization and requires retention for some time period.”

Organizations typically preserve records for legal reasons. Having effective records management functionality built into your construction project management solution is critical to meeting compliance and regulatory requirements and avoiding offline workarounds.

Microsoft 365 and SharePoint Online includes robust records management functionality by default, allowing the ability to manage the entire lifecycle of files. You can set up information management policy workflows to convert files into non-editable records based on retention codes. The same workflows can determine when files have met the retention schedules and dispose of those records. You can find out more about SharePoint Online records management here.

Legally-Compliant_1

How the Construction Viz records management feature streamlines compliance

Since Construction Viz deploys into Microsoft 365 SharePoint Online, you can already leverage SharePoint's default records retention for any documents generated in our platform. The new records management feature that we've added to our Construction Viz form apps complements SharePoint by enhancing its record retention functionality for construction projects. Creating a record is simple with our tool's “Create a Record” option which makes a form read-only and restricts edits to only system admins. Construction Viz captures when a user converts a form to a record to meet compliance requirements and provide additional reporting.

Legally-Compliant_2

Microsoft 365 SharePoint Online records management can help you manage your construction records. Find out how Construction Viz extends the capability of Microsoft 365 to manage all of your construction project records here.