Leveraging Business Intelligence & Data Analytics in CRE and FM - - PowerPoint PPT Presentation

Cresa Consulting Group

Leveraging Business Intelligence & Data Analytics in CRE and FM to empower Real Estate decisions

Rick Ybarra, Managing Principal Cresa Consulting Group October 4, 2017

2 | Cresa

What do we do all day?

3 | Cresa

Data focused companies in 2012

4 | Cresa

Data focused companies in 2014

5 | Cresa

Data focused companies in 2017

6 | Cresa

Information Management Lifecycle

The Information Management Framework focuses on how information and knowledge is created, captured, retrieved and leveraged across an enterprise. Retrieve - Accessing of knowledge from all available sources, people, and systems Leverage – Utilization of knowledge from people, resources and repositories to grow value Create - Development

• f new knowledge

Capture - Documentation and storage of knowledge

• bjects

Leverage

Collect Collect Project Project

Information Creation

Analyze Analyze Portfolio Portfolio Prioritize Prioritize

Information Retrieval Information Capture

Enabling Technology and Analysis

People, Process and Technology

7 | Cresa

What is the commercial real estate industry doing relative to technology?

Real Estate Industry Technology

Red/PAT Colliers360 NGKF Vision Business Analytics Cresa Vālo BI NSITE

8 | Cresa

CRE Point Solutions: Lease Administration Systems

9 | Cresa

CRE Point Solutions: Space Mgmt. / Occupancy Systems

10 | Cresa

• Easy Projects
• Liquid Planner
• SmartSheet
• Clarizen
• Celoxis
• Teamwork
• Workfront
• Procore
• Wrike
• Projectmates
• Mavenlink

CRE Point Solutions: Project Management Systems

11 | Cresa

Integrated Workplace Mgmt. System (IWMS)

12 | Cresa

Technologies, applications and practices for the collection, integration, analysis, and presentation of business data, providing views that are:

• Historical:

What happened?

• Current:

What’s happening?

• Predictive:

What might happen?

• Prescriptive: What to do to make something happen?

The purpose is to support better business decision making. What is Business Intelligence & Data Analytics?

13 | Cresa

Business Intelligence & Data Analytics Technology Platform

Focused on integrating multiple data sources and information to enable informed decisions that optimize operations and meet key performance targets.

14 | Cresa

Market Overview: Gartner’s Magic Quadrant for BI & Analytics Platforms

The BI and analytics platform market is in the middle of an accelerated transformation from BI systems used primarily for measurement and reporting to those that also support analysis, prediction, forecasting and optimization.

Key Categories

• Information Delivery

‒ Reporting and Metrics ‒ Dashboards and Performance Management ‒ Microsoft integration ‒ Mobile Business Intelligence

• Analysis

‒ Interactive visualization ‒ Search-based data discovery ‒ Geospatial and location intelligence ‒ Online analytical processing “slice and dice data”

• Integration

‒ Collaboration ‒ Embeddable analytics ‒ Development tools ‒ Data Management

15 | Cresa

BI & DA Platform Capabilities

Reporting, Subscriptions, Document Links, Google View, Role-Based Configurations, Sharing, Maps, Etc.

16 | Cresa

Portfolio Summary

17 | Cresa

Portfolio Dashboard: Example #1

Fully customizable dashboard with a variety of charts, trends, scorecards, and other visualizations Fully interactive dashboard allows real‐time filtering and drill downs to explore and visualize RE portfolio data in new ways Understand how and when we will address the locations and associated square feet based on expirations

18 | Cresa

Portfolio Dashboard: Example #1

Aggregate view of lease expirations to proactively anticipate future opportunities Location details to take action on Identify opportunities for efficiency gains based on average cost per sq. ft. and space utilization per employee

19 | Cresa

Gap Analysis: Identify Variance vs. Prevailing Market Rates

20 | Cresa

Critical Date Tracking

21 | Cresa

Headcount Vs. Capacity Breakdown By Location Daily Employee Badge-In Data Breakdown For Location Geographical View With Location Specific Key Metrics

Location Profile: Analysis across multiple data sources

22 | Cresa

Location Drilldown: Street View & Floor Plans

Interactive floorplan with ability to see seat assignments by department, vacant areas, and visualize shared space (e.g., conference room capacity) Selecting any site in the portfolio instantly brings up Google Street View within the dashboard to see the building and explore the surrounding area

Portfolio Summary for OPEX Specific Location Summary for OPEX Portfolio vs Specific Location Performance

OpEx Analysis: Portfolio vs. Location Comparison

24 | Cresa

Portfolio Occupancy: Compare Seat Demand by Location

Building Occupancy By Location Vs. Capacity & Desired Utilization Occupancy Comparison By Cost Center

25 | Cresa

Location Occupancy: Seat Demand Projections by Dept.

Occupancy Projections For A Location Over Time Occupancy Projection Breakdown By Cost Center

26 | Cresa

Capital Projects: Real-Time Project Tracking

View status of active projects to ensure on‐ time delivery Track project expense versus budget to minimize variance

27 | Cresa

Employee Relocation: Drive Time & Attrition Risk Analysis

The upper-right focuses on the changes to employee commute time and distance. The map and histogram colors provide a visual connection between “good” and “bad” changes employees will experience as a result of the relocation. The middle section is focused on the estimated attrition likelihood, based on the drive time matrix for the employee’s staffing level. The bottom section provides more granular detail of the selected scenario. Click any

• ther visual above, and see

the detail here. The upper-left portion of the dashboard provides high level toggles to select a specific scenario.

Cresa Consulting Group Introduction