TELECOM SERVICES PROVIDER
The Problem
Atlantech Online, a Washington, DC-area business telecommunications company - primarily serving clients in need of fiber, phone services, and data center services - first ran for years without any form of data authority. They recently migrated their billings to a cloud based system (Rev.io) and a new opportunity to tailor visualization of Rev.io’s billing data for executive-level monitoring presented itself when Ed Fineran, CEO, came across Microsoft Power BI, a respected business analytics solution. “Adding in Power BI has taken (Atlantech’s data visualization) to another level,” Fineran said.
The Solution
Before integrating Microsoft Power BI with Rev.io, Fineran said Atlantech Online interviewed a handful of consultants to assist with the development process. From this search, Atlantech identified Aver Analytics, who understood the importance of data visualization for modern businesses. “I think his knowledge of accounting, along with Power BI’s (platform), really made this a successful project for us. His ability to focus on the core drivers and think about how they impact our finances was also valuable.”
Fineran’s internal team handled none of the heavy lifting required to complete this integrated dashboard build thanks to the combination of Aver Analytics’ expertise and Microsoft Power BI’s technology
The Value
DIGITAL DASHBOARD INSIGHTS
Fineran said he identified many important customer payment metrics eligible for dashboard visualization. Key data elements, updated throughout the day within Rev.io’s instance, sync directly to Fineran’s assembled Microsoft Power BI dashboard and cover everything from payments to cash flow, A/R, product & data usage, and more.
Specific examples of Rev.io billing data points that Fineran regularly views through his interactive dashboard include:
Projected billing
Trailing 12 months billing
A/R aging
Tasks
Orders
Disconnected services
Using this executive dashboard - accessible from both a desktop and mobile app - multiple times per day, Fineran added that visualizing Rev.io’s data and customer intelligence through Microsoft Power BI now helps his company better monitor another critical metric - churn.
“I never knew before what our churn was and could only guess. Now I know what our churn looks like.” This visual analysis even revealed a positive key finding.