<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. 

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 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


How data automation elevates your Power BI reports

How data automation elevates your Power BI reports

Picture of Terje Vatle

by Terje Vatle

28. Jun 2023, 10 min reading time

Adding the missing piece to Microsoft Fabric

Adding the missing piece to Microsoft Fabric

Picture of Terje Vatle

by Terje Vatle

21. Jun 2023, 13 min reading time

Seasonal shifts and exciting updates!

Seasonal shifts and exciting updates!

Picture of BI Builders

by BI Builders

03. May 2023, 8 min reading time