Omnicore Achieves 40X Faster Reporting and Improves Customer Satisfaction by Switching to a Modern Data Stack

Samvel Khachatryan, Head of Business Intelligence at Omnicore uses Hevo, BigQuery, Power BI, and Google Data Studio to streamline its data integration and reporting process and empowers its business users and customers with accurate and timely data.

Get a Demo

2 Weeks

Using Hevo, Omnicore upgraded to a Modern Data Stack in just 2 weeks and saved almost $10K in initial setup cost.

40X Faster Reporting

Client reports that used to refresh only once per week now get refreshed 8 times a day with almost real-time data.

5M Events/Month

Omnicore uses Hevo to securely integrate ~5M events per month without any latency or inaccuracies.

Omnicore is a digital commerce company that operates as an outsourced online sales department for fashion distributors covering everything from webshop development to product listing to online sales and order fulfillment. Data plays a critical role for their internal teams as well as for their clients to seamlessly operate their e-commerce business and measure the performance of their key metrics on a daily basis. Any delays or errors in data availability can have a negative impact on delivery time and consequently, customer satisfaction.

Meet Samvel Khachatryan, the head of Business Intelligence at Omnicore. He’s responsible for building the backend architecture of the accounting and analytical system. Additionally, he’s also responsible for creating and maintaining tools that consolidate and facilitate information exchange between different departments via visual reports and KPI scorecards developed on Microsoft Power BI.

Samvel Khachatryan
Samvel Khachatryan

Head of Business Intelligence

Data Challenges

Omnicore’s unique business proposition is providing its clients with an end-to-end e-commerce solution. Naturally, all the different business aspects - website, marketing, and logistics, require data and reports for accurate operations and performance measurement. Any delay or errors in data availability can lead to longer delivery times which is a deal-breaker for Omnicore’s clients. Samvel is responsible for orchestrating these data flows and ensuring that the right data is available to the right people at the right time.

Before I joined Omnicore, there were 52 different reports created on spreadsheets using Jasper Studio and were sent to a list of employees and partners via email. Analytics processes were largely ad-hoc so it was difficult to establish and measure the KPI of different processes. To make things worse, the website’s database was full of data recursion, overwritten statuses, and non-typed history transaction log errors.

- Samvel Khachatryan, Head of Business Intelligence, Omnicore

When establishing a data & analytics foundation at Omnicore, Samvel started using Power BI’s inbuilt, open-source, and commercially available data connectors to load data. But, these connectors weren’t always reliable and Samvel frequently faced data accuracy issues causing reporting errors.

Loading data using Power BI’s connectors was not at all reliable or stable and we couldn’t afford that. For example, one of the most important reports, which was being used by our logistics team to detect new deliveries from partners, couldn't be unreliable as it would lead to longer delivery times and consequently, harm customer experience.

- Samvel Khachatryan, Head of Business Intelligence, Omnicore

To resolve these issues, Samvel realized the importance of having an OLAP system in place and decided to build a data warehouse that will act as a single source of truth for all their reporting and analytics needs. He also realized the need for a data pipeline tool that will connect all the sources with this data warehouse and automate the data flows.

The Solution

After settling on BigQuery as a data warehouse, Samvel started looking for ways to feed data into this warehouse. He came across Hevo as a potential solution and decided to activate the free trial to test the platform before coming on board as a user.

Hevo is extremely user friendly. I can build integrations with a lot of tools without time-consuming procedures like installing & configuring databases, writing scripts, researching ETL solutions, etc. Additionally, for a non-python developer like myself, the drag and drop interface is a great way to apply advanced data transformations. The best part about Hevo is that it is continuously improving, with each release they expand the list of connectors, add new features, and improve existing connectors and features.

- Samvel Khachatryan, Head of Business Intelligence, Omnicore

Using Hevo, Omnicore has built pipelines from their databases - MySQL & PostgreSQL and SaaS sources - Google Sheets, OKI TOKI, Jira, Google analytics to their Google BigQuery Data Warehouse and Google Cloud Storage. Business users then use Power BI and Google Data Studio to create dashboards and reports.

Hevo Omnicore Data Stack

Key Results

Switching to a modern data stack helped Omnicore achieve reliable data ingestion and resolve data availability issues. Hevo’s pre-load transformation feature helped Samvel easily clean the data coming from their source systems and load the analytics-ready data in the data warehouse. On top of BigQuery, Samvel is now able to use the DirectQuery option in Power BI to fast-track its reporting and analytics.

Thanks to Hevo, all our ad-hoc Power BI reports are now streamlined and the number of reports came down to just 3 from 52 and they get refreshed 8 times a day instead of a weekly basis. As a result, we can now provide our business teams and customers with more meaningful insights in real-time!

- Samvel Khachatryan, Head of Business Intelligence, Omnicore

Using Hevo's free historical data load Omnicore loaded 37 million events during their initial setup and now, they losslessly aggregate over 5 million events per month in real-time with 100% accuracy. Samvel estimates that setting up a data warehouse with a data pipeline system would’ve taken over a month, with Hevo, they were able to get it up and running in under 2 weeks saving almost $10K in initial set up cost.

Hevo is an excellent solution for companies undergoing a multi-directional growth, have numerous data sources, and are planning to or have a data warehouse in place. With Hevo, data is always reliable and on time!

- Samvel Khachatryan, Head of Business Intelligence, Omnicore

After successfully setting up Omnicore’s data stack, Samvel is now planning to create a cross-project administrative portal, implement end-to-end analytics principles, create live KPI dashboards on LTV, CAC, Marketing funnel, ARPU, and more. Hevo is elated to play a key role in helping Omnicore deliver a superior customer experience and is excited to partner with them for their next series of data challenges.

Excited to see Hevo in action and understand how a modern data stack can help your business grow? Sign up for our 14-day free trial or register for a personalized demo with our product expert.