Geotab Data Connector

Product Overview:

Vehicle KPI, Predictive Safety, and Maintenance Insights Data Sets

DE-DE, ES-ES, ES-LATAM, FR-CA, FR-FR, IT-IT

January 2024

​

Table of Contents/Chapters

Your one stop shop for product, support information and guides

1) Product Overview

• Geotab Data Connector at a Glance
• Available Table Assets
• Vehicle
• Predictive Safety/Benchmarks
• Maintenance Insights
• Product Summary

​

3) Support Materials /Technical Guides

• GDC User Guide
• Template Guide and Library
• Data Schema and Dictionary
• GDC Predictive Safety Analytics and Peer Benchmark User Guide
• GDC Maintenance Insights User Guide

2) Templates and Use Cases

• New Predictive Safety and Benchmarks
• New Maintenance Insights
• Distance & Time
• Fuel Economy
• Idling
• Utilization
• Daily Analysis
• Hourly Analysis

​

2 | © 2022 Geotab Inc. All Rights Reserved

01

Product Overview

Your Data, Your Way

We acknowledge that:

• Every company/organization has their own unique fleet data analytics needs - no one fit for all solution
• Fleet data is only a part of the larger picture
• There is a strong need to share information and data stories internally in the organizations

What is a solution that can give you the analytics flexibility that you need without the complexities of data management?

​

© 2022 Geotab Inc. All Rights Reserved | 4

Bring your data to life with the tools you know

​

Geotab leverages our expertise preparing data for reporting and visualization, and makes these curated data tables available in the most popular Business Intelligence tools via an easy to use connection.

​

​

5 | © 2022 Geotab Inc. All Rights Reserved

GDC Safety & Operational Use Case & Data Sets

​

6 | © 2022 Geotab Inc. All Rights Reserved

BI and BI Tools Importance Continues to Grow

From a recent study from Deloitte Insights only a minority of companies have become insight-driven organizations:

• Three-quarters of survey respondents report that their organization’s analytical maturity has increased over the past year, and nearly as many— 70% expect business analytics to be more important in the next three years than it is now.
• Report finds that most large companies are not mature when it comes to business analytics; 62% still rely on spreadsheets
• Organizations with the strongest cultural orientation to data-driven insights and decision-making were twice as likely to have significantly exceeded business goals.

7 | © 2022 Geotab Inc. All Rights Reserved

Uncovering Insights through Big Data

Business Challenges

• Want to analyze what is happening with the fleet in different period of time
• Want to combine fleet data with other data sources
• Need performance insights to better manage the fleet
• Want to make informed decisions
• Want to create reports and analyze data in their BI tool of choice
• Don't want to be buried in a huge amount of data

Technical Challenges

• Reporting performance for large databases
• Don’t have the resources to build a customer data lake where large amounts raw data can be stored for analysis
• Don’t have the coding skills to work with and prepare data for analysis

​

8 | © 2022 Geotab Inc. All Rights Reserved

Customer POV: Geotab Data Connector

Analyze data

Analyze what is happening with the fleet in different period of time.

Combine Fleet Data

Combine fleet data with other data sources

Get Insights

Get performance insight to better manage the fleet

Create Reports

Create reports or use our pre-built templates

Enable Information Sharing

Easily share relevant information to your peers and management

Make Decisions

Make informed decisions

9 | © 2022 Geotab Inc. All Rights Reserved

Vehicle Focused Table Assets

​

Vehicle Groups

• Mapping of device to the MyGeotab groups
• Data refreshed hourly
• Device identifiers, MyGeotab Group ID, etc.

Vehicle Metadata

• Data available daily
• Device identifiers, VIN, Make, Model, Year, Device Health, Vocation, latest odometer, etc.

Vehicle KPI

• Data aggregated at the vehicle level
• Aggregated hourly, �daily and monthly
• Utilization, total fuel, fuel economy, fault counts, last location, odometer, device health

1

2

3

Mileage

Fuel Economy

Utilization

Device Health

Fault Counts

Odometer

VIN Decode

Last Lat&Long

Now Offers a Complete View: New Predictive Safety and Maintenance Insights included

​

Vehicle Groups

• Mapping of device to the MyGeotab groups

​

Vehicle Metadata

• Device identifiers, VIN, Make, Model, Year, Device Health, Vocation, latest odometer, etc.

Vehicle KPI

• Utilization, total fuel, fuel economy, fault counts, last location, odometer, device health

1

2

3

3

Predictive Safety and Benchmarking

• Proactive safety assessment and collision prevention
• Safety performance benchmark against peers

​

​

Maintenance Insights

• Maintenance-related fault codes such as Electrical System Ratings, Water in Fuel, Anti-lock Brake Systems, Engine Coolant and more.
• Daily operational application and Historical trends

​

5

4

11 | © 2022 Geotab Inc. All Rights Reserved

New Maintenance Data, New Maintenance Focused Template

​

• Weekly and Yearly count of Issues
• What have been the top issues
• Which Groups to Focus On
• By Manufacturer
• Also Provides Issue Log and Gantt Chart View

12 | © 2022 Geotab Inc. All Rights Reserved

Vehicle Issue Log - List vs Gantt Chart View

13 | © 2022 Geotab Inc. All Rights Reserved

A Better Way of Looking at and Improving Safety

• Predictive Safety Analytics, an innovative approach that leverages machine learning to translate driving behavior into a predicted collision rate
• Fleet level and Vehicle Level
• Predicted collision rate per million units of distance (M/KM)

​

​

• Safety Benchmarking, offering an objective comparison of fleet safety performance against industry standards.
• Fleet level and Vehicle level
• Rank and percentile against peers with similar characteristics (above, below top performer)

​

​

14 | © 2022 Geotab Inc. All Rights Reserved

AI based Predictions is the future of Safety Analytics

• Making predictions about the future events based on past behaviour to proactively Identify real safety issues.

​

• By leveraging data-driven insights, potential collisions can be anticipated and prevented, making the roadways safer for everyone.

• Moving away from arbitrary and inaccurate scoring systems means better prediction and prevention of actual collisions

15 | © 2022 Geotab Inc. All Rights Reserved

How are these new predictive safety analytics calculated?

​

• Established empirical based relationship between collisions (which we can measure) and unsafe behaviour such as harsh acceleration, speeding, harsh braking and cornering (which we can also measure).

​

16 | © 2022 Geotab Inc. All Rights Reserved

What is Safety Benchmarking?

​

The question is how do you objectively know if your level of risk is higher or lower than the industry standard for your type of fleet?

New Safety Data, New Safety Focused Template

​

• A high-level overview of the fleet’s overall safety performance and comparison to benchmark and peer group leader.
• Interactive visuals to show the areas where vehicles are performing better or worse than the benchmarks.
• The quadrant chart is designed to help you identify the individuals that need the most attention. For example:
• the top-right quadrant includes the cases that have a higher collision rate than the predicted benchmark.
• The top-left quadrant includes cases that have a lower collision rate than the predicted benchmark.

​

• Relative comparison of the different groups based on their average predicted collision rate, as well as a detailed overview of the performance at the vehicle level.

​

18 | © 2022 Geotab Inc. All Rights Reserved

Product Summary

Data Connector makes it easy to get meaningful, aggregated data into common Business Intelligence tools like Power BI and Tableau.

19 | © 2022 Geotab Inc. All Rights Reserved

02

Templates and use cases examples

Data Connector BI Templates

Out of the box templates to provide quick, long-term insights

• Distance & Time
• Fuel Economy
• Utilization

Easily customizable to include your business systems data

Recently Added:

• Predictive Safety and Benchmarking
• Maintenance Insights
• Vehicle KPI Month over Month
• Metric and Imperial Versions

​

• Idling
• Daily Analysis

21 | © 2022 Geotab Inc. All Rights Reserved

New Safety Data, New Safety Focused Template

​

• A high-level overview of the fleet’s overall safety performance and comparison to benchmark and peer group leader.
• Interactive visuals to show the areas where vehicles are performing better or worse than the benchmarks.
• The quadrant chart is designed to help you identify the individuals that need the most attention. For example:
• the top-right quadrant includes the cases that have a higher collision rate than the predicted benchmark.
• The top-left quadrant includes cases that have a lower collision rate than the predicted benchmark.

​

• Relative comparison of the different groups based on their average predicted collision rate, as well as a detailed overview of the performance at the vehicle level.

​

22 | © 2022 Geotab Inc. All Rights Reserved

New Maintenance Data, New Maintenance Focused Template

​

• Weekly and Yearly count of Issues
• What have been the top issues
• Which Groups to Focus On
• By Manufacturer
• Also Provides Issue Log and Gantt Chart View

23 | © 2022 Geotab Inc. All Rights Reserved

Vehicle Issue Log - List vs Gantt Chart View

24 | © 2022 Geotab Inc. All Rights Reserved

New Vehicle:GDC Vehicle KPI Idling/Fuel/Driving Metrics Template (Month Over Month)

Overview/Benefits:

• This template facilitates a comprehensive, month-over-month analysis of these key performance indicators, providing a long-term perspective of your fleet's efficiency.
• Its intuitive design helps you swiftly pinpoint any anomalies or deteriorating trends at a high level. Additionally, it features drill-down capabilities, allowing for a more granular examination of the groups and vehicles that may be predominantly contributing to any identified issues.
• By providing both a broad overview and the capacity for in-depth analysis, this GDC template becomes an invaluable tool for continuously optimizing your fleet's performance.

​

25 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

Distance & Time

Monthly aggregated metrics focusing on GPS distance and driving time for the last 6 completed months.

• How has my fleet’s driving distance and driving time trended over the last 6 completed months?
• What is my fleet’s average monthly driving distance?
• What is my fleet’s average monthly driving time?
• Which vehicle drove the longest distance or time last month?
• Which vehicle drove the smallest distance or time last month?
• How did last month’s driving time and distance compare to the previous month?

Use Case/Next Level Insight

• Add revenue data to make the template even more insightful

​

​

26 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

Fuel Economy

Monthly aggregated metrics focusing on fuel economy for the last 6 completed months. Note the fuel distance may be different from GPS distance because fuel distance is only recorded when the device has also recorded fuel consumption. This ensures that fuel economy calculations are accurate in the case where fuel usage is not reported for certain vehicles or trip segments, and is reasonable to assume is representative of total performance in the vast majority of cases.

• How has my fleet’s fuel economy trended over the last 6 completed months?
• How has my fleet’s fuel usage and fuel distance trended over the last 6 completed months?
• What is my fleet’s average fuel economy?
• What is my fleet’s average fuel economy by fuel type?
• How did last month’s fuel economy compare to the previous month?
• How did last month’s fuel usage compare to the previous month?

Use Case/Next Level Insight

• Add revenue data to make the template even more insightful

​

27 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

Idling

Monthly aggregated metrics focusing on idling time and idling fuel usage for the last 6 completed months.

• How has my fleet’s idling fuel usage and idling time trended over the last 6 completed months?
• What is my fleet’s average monthly idling fuel usage?
• What is my fleet’s average monthly idling time?
• Which vehicle had the largest idling fuel usage or idling time last month?
• Which vehicle had the smallest idling fuel usage or idling time last month?
• How did last month’s idling fuel usage and idling time compare to the previous month?

Use Case/Next Level Insight

• Compare with margins to make template even more insightful

​

​

​

28 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

Utilization

Monthly aggregated metrics focusing on utilization for the last 6 completed months. Two methods of calculating utilization (at the vehicle level and fleet level) are demonstrated on this tab.

• How has my vehicle utilization trended over the last 6 completed months?
• How has my fleet utilization trended over the last 6 completed months?
• How did last month’s vehicle utilization compare to the previous month?
• How did last month’s fleet utilization compare to the previous month?

Use Case/Next Level Insight

• How much of an 8 hour day is this specific vehicle being used/i.e. generating revenues or vice versa costing your business money.
• What % of my total fleet is used on a daily basis (i.e. making money). Is my fleet right sized?

​

29 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

​

Daily/Monthly Analysis

Daily aggregated metrics displaying the main metrics from the first four monthly aggregated tabs as a daily trend for the last 30 days. Includes a map visual plotting each vehicle’s last known location coordinates for each day.

• How have my fleet’s key metrics trended by day over the last 30 days?
• Where is the last recorded daily location of each of my vehicles?

​

30 | © 2022 Geotab Inc. All Rights Reserved

Data Connector BI Templates:

Hourly Analysis

Hourly aggregated metrics displaying the main metrics from the first four monthly aggregated tabs as a daily trend for the last 14 days. Includes a map visual plotting each vehicle’s last known location coordinates for each day.

• How have my fleet’s key metrics trended by hour over the last 14 days?
• Where is the last recorded hourly location of each of my vehicles?

​

31 | © 2022 Geotab Inc. All Rights Reserved

03

Technical Resources

Guides and Data Dictionary

Data Schema and Dictionary

This guide provides a detailed definitions of the columns available�in each of the data assets.

• General Definitions
• Data Availability
• Detailed Schemas

Link

Template Guide and Library

Overview of the BI tool templates and instructions on how to use each for

• All the latest templates
• Power BI, Tableau, and Excel
• Metric and Imperial

​

Link

GDC User guide

This guide provides an overview and instructions for getting started with�the Geotab Data Connector offerings.

• Data Assets
• Data Assumptions
• Troubleshooting

Link

33 | © 2022 Geotab Inc. All Rights Reserved

Recently Released Data Sets & Templates: Predictive Safety and Maintenance Insights

Maintenance Insights GDC User guide

This guide provides an overview and instructions specific to the Maintenance Insights Data Sets and Templates

​

​

Link

Predictive Safety GDC User guide

This guide provides an overview and instructions specific to the Predictive Safety and Peer Benchmark Data Sets and Templates

​

Link

34 | © 2022 Geotab Inc. All Rights Reserved

Corporate headquarters

Geotab Inc.

2440 Winston Park Drive

Oakville, Ontario

L6H 7V2, Canada

Tel: +1.416.434.4309

geotab.com

36

Let’s stay connected

@geotab