TraffiTech Boosts Reporting Speed and Reduces Internal Licensing Costs with TARGIT InMemory
TraffiTech Boosts Reporting Speed and Reduces Internal Licensing Costs with TARGIT InMemory
Managing Truckloads of Customer Data
Harnessing the power of the Internet of Things (IoT) doesn’t do much good for companies unless they find a way to integrate, analyze, and learn from the massive amount of data coming into their systems every day.
That’s why when TraffiTech began its search for a business intelligence (BI) and analytics solution in 2011, executives had one requirement that stood out from the list: they wanted a partner with the back-end horsepower to process millions of rows of data in just a few seconds.
"Everything we do in mobility is about big data and what we call rich data,” says Nicolai Ingemann-Paulsen, CEO of TraffiTech. “Every day, we get millions of data points from our cars. TARGIT helps us turn big data into rich data. We have clients within many different industries with unique data needs. TARGIT is one of the best solutions because it’s flexible and still able to handle that big amount of data. Furthermore, you don’t need a technical background to use TARGIT, and you can learn it quite quickly. That’s a strength compared to other BI tools out there.”
Before TARGIT, TraffiTech spent hours processing data and manually sending out thousands of reports to customers across the globe. Now, they rely on TARGIT to speed up data processing and deliver the right reports to customers on their preferred schedules.
TraffiTech’s Founder Karsten Hjorth explains why the data TraffiTech surfaces is critical for customers: “I like to see that we can make a difference, that we can use the data we collect from the vehicles to change driver behaviors. We’re committed to helping our customers save money by reducing fuel, avoiding accidents, and improving vehicle maintenance. All of this ties back to safety because when you are driving more economically, you also drive safer.”
TraffiTech sends reports to roughly 40,000 people in mainland Europe and 20,000 more in the UK every month. Each organization they work with has its own reporting requirements and a unique company identity that the reports need to reflect. TARGIT allows TraffiTech to customize reports to customers' needs and then use scheduled reporting tools to deliver reports and updated dashboards automatically.
“We mainly use BI for scheduled reports, and in this aspect, TARGIT is simply the best,” says Karsten. “We have tested and tried other options over the years, and TARGIT still proves to be the best.”
Most importantly, TARGIT's dynamic dashboards and customizable KPI Objects ensure data is delivered in a visually appealing, digestible format that everyone from drivers to managers to executives can easily understand.
“TARGIT is very important for us because data is not worth anything when it's in the database on a server,” Karsten explains, “It allows us to share the data graphically, so people without a university degree can easily understand it. Users can see when a trend is going up or down, or how their performance compares to other colleagues, all without reading through complex strings of numbers.”
Modernizing the Reporting Process: From Hours to Minutes
As TraffiTech continues to grow, so does the volume of data they're presenting to customers on a daily basis. To support its data processing needs, the company recently moved to TARGIT's InMemory database, which allows data scientists to process data very quickly while improving latency – data imports that used to take hours are now completed in five or six minutes.
TraffiTech began considering TARGIT InMemory when they moved from SQL to Timescale. Business leaders knew they needed a more modern database to support the data coming into TARGIT and subsequently going out to customers. After learning that TARGIT's standard InMemory solution wasn't compatible with Timescale, the TARGIT team immediately set to work developing a custom solution.
Karsten recalls, "When we approached TARGIT about the move to Timescale, they told us, 'We've never tried that one before, but of course it can be done.' TARGIT assisted us in completely rebuilding the data warehouse and completing the new data modeling. Six months later, we had a working solution."
Karsten shares that switching to InMemory has also significantly reduced TraffiTech’s software costs: “Well, changing to the new InMemory solution has saved us between €20,000 and €25,000 every single month in hosting costs and software licenses.”
TraffiTech’s end-users are also enjoying the benefits of TARGIT’s InMemory technology. While they haven’t seen any outward changes in the interface or content of their reports, they now experience virtually no load time when viewing BI dashboards. Icons and KPIs are loaded instantly, giving them a seamless, lightning-fast experience.