When Equips decided to transition away from being a coverage-oriented business to a technology company, it wasn’t a decision that was based on emotions. Our CEO, Adam, didn’t just wake up with a hunch that we should do a complete 180-degree switch. Rather, we collected data from the market that our leadership team used to make the difficult decision. Businesses of all kinds rely on data, and there really is no way around it. Every department relies on different information to perform their set of functions. And for smaller businesses, each person within the organization might rely on different information to do their jobs effectively. But what if you wear multiple hats? Equips has revolutionized the way businesses view equipment data using customizable database views that can be easily saved and accessed.

Creating Database Views in Equips

A database view is a subset of data within a database that provides specific information about a query. These are used to answer questions about the performance of your equipment. For example, say you work for a credit union and you have been put in charge of purchasing new ATMs for your branch. You already have a variety of different ATM models, and you want to know which of these have been the most expensive to maintain so you can consider other models that might require less maintenance. To determine which models have had the most faults, you will have to create a new database view. Here is how you create it.

Getting Started

First, login to your Equips account. Or, if you don’t have an account, you can create a new one for free. Next, under Service, select View Requests.

After that, select the columns icon. On the left, you will see a list of all the different data you can now put into this table. How cool is that? Go ahead and select the following columns: Created, Manufacturer, and Model.

From there, I will click the filter icon. Under Category, I will select ATM so I am only shown data for ATMs and no other equipment. Under filter, I can also change the date range for the data. For this exercise, I am not going to adjust this so I can see all service requests.

Finishing the View

To save this database view, all I must do is click the saved view icon, click Add New, and enter a name and description for the view. Pretty simple, right? Now you can view this data and understand which ATM models have required the most maintenance given by the number of service requests. But what if you want to send this information to a colleague who, heaven forbid, is not an Equips user? You can export this data into an Excel sheet and add your own formatting. Your boss is going to think you’re a genius by how easily you figured out which ATMs to buy and which to avoid. I would expect a raise if I were you.

Two More Awesome Database Views

Right now, so many businesses are short-staffed due to labor shortages. We created customizable database views with these businesses in mind. We understand that many employees must wear multiple hats for the business to run smoothly, and we believe that being able to quickly view data unique to different aspects of one’s job makes the process of wearing multiple hats much easier. Here are a few of our favorites that might just help you today.

#1 Service Requests Today

When managing equipment across different locations, it would be useful for you to know what service requests were placed today, and for which equipment. Knowing this will help you stay updated on the status of your equipment across all locations. It will also alert you of possible bottlenecks and other problems at different locations. For example, say the new ATM you purchased for your drive-up experiences a fault and requires maintenance. From this, you can infer that more customers will be going into your branch instead of using the ATM. For that reason, you might want to have another teller in the branch to keep up with the extra demand.

But what if every ATM across all locations goes down at once? Those managing the individual branches might just see that their ATM is down and place a service request. By using this database view, you will be able to see that all ATMs went down and diagnose the problem as a network issue.

To create this view:

Filter the Scheduled Date to Today. Next, select the following columns.

  • Created
  • Category
  • Model
  • Location

#2 Service Request Status

It can be difficult to keep track of all the different service requests your business places. In this database view, you can see the exact status of each request—everything from the initial dispatch to the billing process. It is all there. From a bookkeeper’s perspective, this is very valuable because you can filter to see which invoices are still being processed so that you can remain updated on your accounts payable.

To create this view, select the following columns.

  • Created
  • Category
  • Model
  • Status

You can also filter by status to see equipment in each process of the billing and dispatch cycles. But what if you notice a few service requests that appear to not be updated correctly? You can take this view one step further by selecting the Modified column. This will show you the last time the status was updated. Say, for example, that you have a service request that was last modified over a year ago but still is not marked as Closed. This would be a good indication that you should reach out to whoever handles your invoices to check the status of the invoice. Hopefully, your service provider has been paid, and if so, you can change the status to Complete.

Moving Forward

In this article, we have covered three different database views that you can create in a matter of seconds. However, this is just the tip of the iceberg. There are still a multitude of different ways this tool can be used to help you better understand your equipment, and help you manage it more effectively. If there is a specific view that you would like to learn how to create and use, be sure to reach out to your Account Manager. We are eager to help you use this amazing tool to fit the needs of your business.

Thanks for reading!

Schedule a Demo to Learn More