Help Center > > FAQs> General Problems> What Scenarios Use Data Warehouses?

What Scenarios Use Data Warehouses?

Updated at: Nov 04, 2021 GMT+08:00

Data warehouses excel in BI systems, dashboards, exploratory and interactive data analysis, and batch data processing.

BI Systems

This common use case provides support for enterprise decision making from daily operations to long-term strategy planning. BI systems process a large amount of data to help enterprises identify new business opportunities and build up competitiveness. Enterprise users use BI systems to collect business data for analysis, presentation, and distribution. BI systems can provide historical, current, and expected business operational data and use report display, data analysis, data mining, predictive analysis, performance indicators, baseline assessment, and other core technologies and methods to mine data value.


A dashboard is a visual tool that displays enterprise key performance indicators (KPIs). Multiple KPIs and related graphs are displayed together, effectively showing business status to decision makers. Generally, data used in graphs on a dashboard is extracted from a data warehouse in real time. Many BI systems have a dashboard function.

Exploratory and Interactive Data Analysis

This method analyzes and summarizes data characteristics in conjunction with data visualization. Data exploration personnel can assume a data model and check it against the statistical data to be explored. If the assumption is correct, test new data sets to refine the model for better analysis results. Exploratory data analysis verifies and reduces assumptions. This powerful tool for data scientists and engineers is widely used in finance, insurance, Internet, social science, healthcare, and pharmacy.

Batch Data Processing

Lots of data is generated regularly and needs effective processing. In many service systems, data generated by hour, day, or week will be processed, migrated, aggregated, and associated to produce data result sets. Batch data processing invokes multiple data processing scripts or tasks, with built-in fault tolerance and restart functionality. The daily or monthly reports on business operation indicators are generated by the batch data processing system. Batch data processing requires many compute resources, but no immediate responsiveness, so it usually runs during off-peak hours.

In today's data era, data warehouses are even more useful. Enterprises increasingly adjust business decisions based on data and apply data warehouses in their production and services. Data warehousing influences every aspect of daily life, including phone applications, loan, spending, traffic, social security, and government services. Data warehousing is changing the way we live and work.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel