Data warehousing: making quick and informed decisions

Which products are available for data warehousing? What is the Data Warehouse Cloud? Which products does s-peers offer for data management? What are the latest data warehouse technologies? What is business intelligence? What kind of queries do I use data warehousing for? Find answers to these and other questions right here.

Data Warehouse (DWH) - Protecting all data: what solutions are there?

When it comes to data warehousing or in a database system, all the data for business intelligenceactivities from various sources is collated, analysed and managed, then preparedand made available for further analysis systems. A data warehouse almost exclusively contains large amounts of historical data from a variety of different sources.

Data warehousing

SAP Data Warehouse
Cloud (DWC)

  • Comprehensive data management in the form of virtualisation, integration, modelling and data transformation
  • Flexible, scalable solution
  • Strong security and data governance features
Data warehousing


  • Cloud and on-premise use
  • Simple data modelling via new info providers
    In-memory function provides quicker data access
  • Integration with applications from SAP and other providers
Data warehousing


  • Particularly "lean" InfoProvider,"open ODS views" are available.
  • In-memory function provides quicker data access
  • Simple data modelling via new info providers
Data warehousing

Seminar: System conversion

  • Prepare and implement system conversion to SAP BW/4HANA
  • The focus is on the use of SAP conversion tools for the in-place conversion approach as well as for remote conversion approaches
Your contact person for data warehousing
Paul Vatter Head of the Data Warehousing Competence Centre at s-peers AG
Paul Vatter
Data workshop manager

Data warehouse FAQ:

A data warehouse is designed to structure data and prepare the various formats. One of its main advantages is that it standardises data, which saves a great deal of time. Data warehousing makes it possible not just to bundle the data in a central system, but also to combine it as you wish, thus providing a consistent view of data from different sources. Thanks to this holistic approach, relationships can be recognised much more easily, meaning that management decisions can be reached in a well-founded and targeted way.

Data warehousing offers the outstanding advantage that companies are able to analyse large amounts of data from different source systems and gain significant analytical value from it, as well as record historical data.

Computer scientist William Inmon, who is seen as the father of data warehousing, describes the following four characteristics of data warehousing as distinctive advantages:

  • Subject-oriented: Relevant data can be prepared for a specific subject or for an expert / functional area (e.g. sales).
  • Integrated: Data warehouses can provide a consistent view of data from different sources.
  • Permanent: In a data warehouse, all data is stored in a stable and long-term way.
  • Time-dependent: Data warehouse analysis examines change over time.


A data warehouse delivers high data throughput and gives users enough flexibility to disaggregate the data so that they can analyse it from different angles.

A data warehouse serves as the basis for a customised BI environment that provides reports, dashboards and other interfaces.Company decision-makers can access all relevant data much faster with a data warehouse solution and generate solid forecasts and trends.

Download the "SAP Data Warehouse Guideline" guide free of charge


This is why you should implement your data warehouse project with s-peers!

Our holistic approach to enterprise-wide analytics platforms convinces with the following advantages and possibilities:

Visualised mobile dashboards for management

Industrialised reporting incl. planning functions for controllers (in Excel and on the web)

Self-service BI for the ad-hoc information needs of the departments

Advanced Analytics Options for Data Analysts and Data Scientists

Automation and optimisation of business processes using analytical functions


Useful information

Webinar DWC & SAC Feature Update Q1/2023

SAP DWC & SAC in focus - Learn all about the latest features in the first quarter. Experience the...

Webinar DWC & SAC Feature Update Q2/2023

SAP DWC & SAC in Q2 2023: Feature Update for Even Better Data Utilization Welcome to our webinar on the...

Event Walldorf Forum 2023

SAP Analytics Forum in Walldorf 2023

SAP Analytics Forum 2023 in Walldorf Success through data analysis: Get inspired at the SAP Analytics Forum in Walldorf! The...

Webinar SAP DWC & SAC Feature Update Q3

Webinar DWC & SAC Feature Update Q3/2023

Latest feature updates for SAP DWC & SAC in July 2023: Maximize your data usage! Experience the latest feature updates from...

Download the "SAP Data Warehouse Guideline" guide free of charge