Portfolio

BI data warehouse integration

Logistics company gains timely business intelligence through data warehouse migration

Influential Software solved the company’s sluggish BI performance with a cloud-based data warehouse migration and integration solution.

Businesspeople at BI screen representing BI data warehouse integration

Executive brief

Data warehouse migration to the cloud

Our client is a publicly owned post and subscription management company. With 300 million items distributed each year, the company is a leader in its field. Influential Software helped the company overcome performance issues in its BI software through a cloud migration and integration project. The benefits of this were:

accelerated business intelligence

boosted customer satisfaction

cut customer service effort

helped onboard new clients

Wondering how they achieved this with BI data warehouse integration? Read on to learn more.

The full story

Purple arrow encouraging readers to scroll down for the rest of the GDPR data solutions case study

The challenge

Data warehouse performance was hindering BI

At the time of this project, our client’s business intelligence team worked with data from an on-premises data warehouse. While the data warehouse was set up correctly, it simply didn’t have the capacity to handle the client’s data volumes. As a result, the data warehouse was not providing the data needed for business intelligence in a timely manner.

 

First of all, this delay in BI data affected the company’s own financial reporting capability. The company’s management did not have access to the up-to-date financial insights they needed to steer the business effectively.

 

Secondly, the poor data warehouse performance also affected a BI service that the company provided for its customers. This meant that the BI platform, which customers used to track their subscription sales, was not meeting customers’ expectations. And this resulted in customers calling our client’s BI team for IT support, which added to the team’s workload.

 

Finally, the company had plans to onboard new customers — but expanding the data warehouse was prohibitively expensive. It was clear that a high-performing and scalable alternative was required.

 

Overall, the drawbacks of this poorly performing BI data warehouse were:

 

  • decreased ability to produce timely financial reports
  • reduced customer satisfaction from BI services
  • increased time spent on customer service calls
  • lack of scalability needed to take on new customers

The solution

Cloud-based BI data warehouse integration

Based on our reputation as integration experts, the company contacted Influential Software to solve its data warehouse issues. Our in-depth analysis pointed to two potential solutions:

 

  1. Migrating the data warehouse and BI software to a scalable cloud platform
  2. Carrying out a performance tune-up on the on-premises data warehouse

 

Because the data warehouse’s problem was scale rather than configuration, we did not expect a tune-up to make much improvement. For this reason, and because staying on-premises would not solve the scalability issue, we recommended moving to the cloud.

 

The client accepted our proposal to migrate the data warehouse to Microsoft Azure, a highly scalable and cost-effective platform. Following this we achieved SAP BusinessObjects data integration with the data warehouse, bringing the whole BI system into the cloud.

The benefits

Future-proof business intelligence

The decision to migrate this on-premises data warehouse to the cloud was beneficial both in the short-term and the long-term. Some of the immediate benefits were:

 

  • accelerated data processing with parallel processing capability
  • a reduction in time spent dealing with BI customer service calls
  • no costly maintenance of on-premises software and hardware

 

And in the long-term, our Azure-based BI data warehouse integration provided:

 

  • the ability to process any volume of BI data on time
  • fast and painless onboarding of new customers
  • a future-proof platform that supports business growth

Work with data integration experts

This company is one of hundreds that benefit from our data integration services. To find out more about our expertise, visit our integration solutions page.

Info

17th November 2020
data warehouse, business intelligence, SAP, integration, migration, Azure

Privacy Preference Center

Necessary

Advertising

Analytics

Analytics cookies collect information that is used either in aggregate form to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you.

Google Analytics
The cookie _gcl_au is used by Google Analytics to understand user interaction with the website.

For example, in order for Google Analytics to determine that two distinct hits belong to the same user, a unique identifier, associated with that particular user, must be sent with each hit.

The analytics.js library accomplishes this via the Client ID field, a unique, randomly generated string that gets stored in the browsers cookies, so subsequent visits to the same site can be associated with the same user.

By default, analytics.js uses a single, first-party cookie named _ga to store the Client ID, but the cookie's name, domain, and expiration time can all be customized. Other cookies created by analytics.js include _gid, AMP_TOKEN and _gac_. These cookies store other randomly generated ids and campaign information about the user.

Google Analytics
_gcl_au, _gid, _ga, gtm_preview

Other

WordPress uses cookies for authentication. That means that in order to log in to our WordPress site, you must have cookies enabled in your browser.

There are two types of cookies set by WordPress.
1 — Session cookies — These are ‘strictly necessary’ cookies as WordPress will not be able to function without it.
2 — Comment cookies — These are not ‘strictly necessary’ cookies and are set when users leave a comment on a post.

Wordpress Session cookies:
Users are those people who have registered an account with the WordPress site.
wordpress_[hash]
wordpress_logged_in_[hash]
wordpress_test_cookie
wp-settings-{time}-[UID]

Wordpress comments:
Comments are usually turned off by default.
If by chance they are still active on a post, asides being turned off when spotted, data from these are not saved by Influential.
- When visitors comment on a post, they too get cookies stored on their computer. This is purely a convenience so that the visitor won’t need to re-type all their information again when they want to leave another comment. Three cookies are set for commenters:
comment_author_{HASH}
comment_author_email_{HASH}
comment_author_url_{HASH}

Wordpress, Intercom
comment_author_{HASH} comment_author_email_{HASH} comment_author_url_{HASH} wordpress_[hash] wordpress_logged_in_[hash] wordpress_test_cookie wp-settings-{time}-[UID]
intercom-id-[app_id],intercom-session-[add-id]