<img alt="" src="https://secure.dump4barn.com/213374.png" style="display:none;">

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. 



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


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 15 years. With experience from a range of different clients, Anja is an expert in understanding our customers' needs and mapping those needs to data and data models to achieve 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

Multicloud Azure & AWS and Databricks

Multicloud Azure & AWS and Databricks

Picture of Terje Vatle

by Terje Vatle

17. Mar 2023, 9 min reading time

DataOps: Source control and data quality

DataOps: Source control and data quality

Picture of Anja Loug Helland

by Anja Loug Helland

24. Feb 2023, 10 min reading time

DNO Norge selects Xpert BI to accelerate digital transformation.

DNO Norge selects Xpert BI to accelerate digital transformation.

Picture of BI Builders

by BI Builders

17. Feb 2023, 3 min reading time