Accelo makes use of Amazon QuickSight to speed up time to worth in delivering embedded analytics to skilled providers companies


This can be a visitor publish by Accelo. In their very own phrases, “Accelo is the main cloud-based platform for managing consumer work, from prospect to cost, for skilled providers corporations. Every month, tens of hundreds of Accelo customers throughout 43 international locations create greater than 3 million actions, log 1.2 million hours of labor, and generate over $140 million in invoices.”

Think about driving a automotive with a blacked-out windshield. It sounds terrifying, but it surely’s the best way issues are for many small companies. Whereas they give the impression of being into the rear-view mirror to see the place they’ve been, they lack visibility into what’s forward of them. The dearth of real-time information and dependable forecasts leaves essential choices like funding, hiring, and resourcing to “intestine really feel.” An trade survey carried out by Accelo exhibits 67% of senior leaders don’t have visibility into group utilization, and 54% of them can’t monitor consumer venture budgets, a lot much less profitability.

Skilled providers companies generate most of their income straight from billable work they do for purchasers every single day. As a result of no two purchasers, initiatives, or group members are the identical, real-time and actionable perception is paramount to make sure completely happy purchasers and a profitable, worthwhile enterprise. A giant a part of the issue is that many companies try to handle their consumer work with a cocktail of various, disconnected techniques. No surprise KPMG discovered that 56% of CEOs have little confidence within the integrity of the information they’re utilizing for decision-making.

Accelo’s mission is to unravel this downside by giving companies an built-in system to handle all their consumer work, from prospect to cost. By combining what have traditionally been disparate components of the enterprise—CRM, gross sales, venture administration, time monitoring, consumer assist, and billing—Accelo turns into the only supply of fact for your corporation’s most vital information.

Even with a reliable, automated and built-in system, determination makers nonetheless have to harness the information in order that they see what’s in entrance of them and may anticipate for the longer term. Accelo devoted all our sources and experience to constructing a whole consumer work administration platform, made up of important merchandise to realize the best profitability. We acknowledged that in an effort to make the platform handiest, customers wanted to be empowered with the strongest analytics and actionable insights for strategic determination making. This drove us to hunt out a number one BI resolution that would seamlessly combine with our platform and create the best person expertise. Our goal was to make sure that Accelo customers had entry to one of the best BI software with out requiring them to spend extra of their worthwhile time studying yet one more software – to not point out one other login. We would have liked a robust embedded analytics resolution.

We evaluated dozens of main BI and embedded reporting options, and Amazon QuickSight was the clear winner. On this publish, we talk about why, and the way QuickSight accelerated our time to worth in delivering embedded analytics to our customers.

Information drives insights

Even immediately, many organizations monitor their work manually. They extract information from totally different techniques that don’t discuss to one another, and manually manipulate it in spreadsheets, which wastes time and introduces the varieties of knowledge integrity issues that trigger CEOs to lose their confidence. As corporations develop, these handbook and error-prone approaches don’t scale with them, and the sheer stage of effort required to maintain information updated can simply lead to leaders simply giving up.

With this in thoughts, Accelo’s embedded analytics resolution was constructed from the bottom as much as develop with us and with our customers. As part of the AWS household, QuickSight eradicated one of many largest hurdles for embedded analytics by its SPICE storage system. SPICE permits us to create limitless, purpose-built datasets which are hosted in Amazon’s dynamic storage infrastructure. These smaller datasets load extra shortly than your typical monolithic database, and will be up to date as typically as we’d like, all at an inexpensive per-gigabyte charge. This enables us to supply real-time analytics to our customers swiftly, precisely, and economically.

“Having the ability to depend on Accelo to inform us every little thing about our initiatives saves us a variety of time, as a substitute of getting to go in and obtain a variety of info to create a spreadsheet to do any sort of evaluation,” says Katherine Jonelis, Director of Operations, MHA Consulting. “My boss loves the dashboards. He loves simply having the ability to take a look at that and immediately know, ‘Right here’s the place we’re.’”

Along with powering analytics for our customers, QuickSight additionally helps our inner groups establish and monitor important KPIs, which traditionally has been executed by way of third-party apps. These metrics can cowl something, from calculating the efficient billable charge throughout lots of of initiatives and hundreds of time entries, to figuring out how a lot time is left for the group to complete their duties profitably and on price range. As a result of the reviews are embedded straight in Accelo, which already homes all the information, it was straightforward for our group to adapt to the brand new reviews and require minimal coaching.

Built-in vs. embedded

One of the vital vital components in our analysis of BI platforms was the time to worth. We requested ourselves two questions: How lengthy would it not take to have the answer up and working, and the way lengthy would it not take for our customers to see worth from it?

Whereas there are many highly effective third-party, built-in BI merchandise on the market, they typically require a whole integration, including authentication and configuration on high of primary information extraction and transformations. This makes them an unattractive possibility, particularly in an more and more security-focused panorama. In the meantime, many of the embedded merchandise we evaluated required a time to launch that numbered within the months—spending time on infrastructure, information sources, and extra. And that’s with out contemplating the infrastructure and engineering prices of ongoing upkeep. One key profit that propels QuickSight above different merchandise is that it allowed us to cut back that setup time from months to weeks, and fully eradicated any configuration work for the end-user. That is attainable due to built-in instruments like native connections for AWS information sources, row-level safety for datasets, and a easy person provisioning course of.

Developer hours will be costly, and are all the time in excessive demand. Even in a responsive and agile improvement setting like Accelo’s, improvement work nonetheless requires lead time earlier than it may be scheduled and accomplished. Engineering sources are additionally finite—in the event that they’re engaged on one factor immediately, one thing else might be going into the backlog. QuickSight permits us to remove this bottleneck by shifting the duty of managing these analytics from builders to information analysts. We used QuickSight to simply create datasets and reviews, and positioned a easy API name to embed them for our purchasers to allow them to begin utilizing them immediately. Now we’re capable of shortly reply to our customers’ ever-changing wants with out requiring builders. That additional improves the velocity and high quality of our information through the use of each the analysts’ common experience with information visualization and their distinctive information of Accelo’s schema. Right now, all of Accelo’s reviews are created and deployed by QuickSight. We’re capable of accommodate dozens of customized requests every month for enhancements—main and minor—with out ever needing to contain a developer.

Implementation and coaching had been additionally key issues throughout our analysis. Our prospects are busy working their companies. The very last thing they need is to get skilled on a brand new software, to not point out the usually excessive price related to implementation. As a turnkey resolution that requires no configuration and minimal schooling, QuickSight was the clear winner.

Delivering worth in an agile setting

It’s no secret that workers dislike timesheets and would moderately spend time working with their purchasers. For a lot of providers corporations, logged time is how they invoice their purchasers and receives a commission. Subsequently, it’s important that workers log all their hours. To make that course of as painless as attainable, Accelo gives a number of instruments that decrease the quantity of labor it takes an worker to log their time. For instance, the Auto Scheduling software routinely builds out workers’ schedules primarily based on the work they’re assigned, and logs their time with a single click on. Inevitably, nevertheless, somebody all the time forgets to log their time, resulting in misplaced income.

To handle this subject, Accelo constructed the Lacking Time report, which pulls lots of of hundreds of time entries, complicated work schedules, and even vacation and PTO time collectively to supply solutions to those questions: Who hasn’t logged their time? How a lot time is lacking? And from what time interval?

Each enterprise must know whether or not they’re worthwhile. Skilled providers companies are distinctive in that profitability is tied on to their particular person purchasers and the relationships with them. Some purchasers might generate excessive revenues however require a lot additional upkeep that they turn out to be unprofitable. Then again, low-profile purchasers that don’t require a variety of consideration can considerably contribute to the enterprise’s backside line. By having all of the consumer information below one roof, these centralized and embedded reviews can present visibility into your budgets, time entries, work standing, and group utilization. This makes it attainable to make real-time, data-driven actions with out having to spend all day to get the information.


Clear and holistic information fosters deep insights that may result in increased margins and earnings. We’re excited to accomplice with AWS and QuickSight to supply skilled providers companies with real-time insights into their operations to allow them to turn out to be really information pushed, effortlessly. Study extra about Accelo, and Amazon QuickSight Embedded Analytics!

In regards to the Authors

Mahlon Duke, Accelo Product Supervisor of BI and Information.

Geoff McQueen, Accelo Founder and CEO.