Use-cases for data warehouse (automation) functionality

Bilde av Anja Loug Helland
by Anja Loug Helland

18. Mar 2021, 5 minutes reading time

Use-cases for data warehouse (automation) functionality

During several years of providing data warehouse solutions with automation software, we have come across a range of use-cases for making data available within organizations of all sizes and industries.

The usual, initial and generic use-case is being able to combine data from different source applications where logic or integration rules needs to be applied such as:

  • Production, sales and costs
  • Absence and production
  • Sales and inventory
  • External market trends and sales
  • Budgets on various detail levels with actuals from various applications
  • Resource planning, orders and utilization
  • And much, much more

Data may exist in various granularities and more often than not, it requires processes with logic in order to create a combined data model.


Other normal use cases that we see at our customers are:

  • Need for table historization. This can be tracking of snapshot data, historizing transactional changes, historizing dimensional attributes (SCD2)
  • Flexibility, usability and performance of application reports. Built-in reports in source applications are often very fixed/Standardized and struggles with performance on large data sets or more complicated queries.
  • Need for manual input. The need to supporting tables either for data mapping purposes or for adding data which does not exist in source systems.

An automation tool will also accelerate the process of implementing such type of requirements, and often these features are out-of-the box features.

Customer use cases with Xpert BI
We also encounter more specific data requirements, where a data warehouse automation tool provides functionality to support users or applications with easy and qualified access to data. Below are some examples of how we have used the data warehouse automation tool Xpert BI to meet customer needs.

The use cases are structured using the format: Situation →Challenge →Solution → Benefits, with an Xpert BI data platform architecture below, highlighting in pink squares the features that are being used.
 

CASE 1: Providing data to a Chatbot. 

case1

 

CASE 2: Automating data ingestion from external APIs into existing data platform. 

case2 

CASE 3: Providing Data-as-a-Service to an external application trough API.  case3

 

CASE 4: SAP as a data source to the SQL Server DWH (cheaper than HANA/BW). case4

 

We see that many organizations want to automate more of their data delivery to reports and insights, but do not know how to get started. To learn more about how you can use data more extensively or how to get started with automating your data platform, please contact us in BI Builders. 

New call-to-action

Anja Loug Helland

Anja Loug Helland

Anja is Head of Advisory and co-founder of BI Builders and has worked with data warehousing and data platforms for over a decade. Having experience from a range of different clients, Anja is an expert in understanding our customers' needs and map that to data and data models to get business value.

Follow our blog


Our dedicated employees write professional blogs worth reading.
Follow the blog for a sneak peek at the future!

Others would also read


How to improve efficiency in the organization using data

How to improve efficiency in the organization using data

Picture of Kurt S. Helland

by Kurt S. Helland

08. Jun 2021, 4 min reading time

Do you spend too much time and resources preparing data?

Do you spend too much time and resources preparing data?

Picture of Jarle Soland

by Jarle Soland

01. Jun 2021, 4 min reading time

Why data-driven companies outperform the competition

Why data-driven companies outperform the competition

Picture of Kurt S. Helland

by Kurt S. Helland

25. May 2021, 3 min reading time