Select ALL the correct answers, write formulas to calculate business metrics, optimize data for analysis and human interaction, combine data from several sources, and store raw data in its original format. A data warehouse centralizes and consolidates large amounts of data from various sources. Its analytical capabilities allow organizations to obtain valuable business information from their data to improve decision-making. Over time, it creates a historical record that can be invaluable to data scientists and business analysts.
Thanks to these capabilities, a data warehouse can be considered an organization's “only source of reliable information”. Metadata management, data distribution, storage management, recovery, and backup are some of the data storage capabilities. BI functions include creating intuitive visualizations and dashboards, reporting, predictive analysis and modeling, data extraction, and much more. Although they work very well as current data sources and are often used as such by data warehouses, they do not support queries rich in historical data.
Data marts usually function as a subset of a data warehouse to focus on an area for analytical purposes, such as a specific department of an organization. Data warehouses offer the unique global advantage of allowing organizations to analyze large amounts of variable data and extract significant value from them, as well as maintain a historical record. As data warehouses became more efficient, they went from information warehouses compatible with traditional BI platforms to extensive analytics infrastructures that support a wide variety of applications, such as operational analysis and performance management.
