Do you know how business analysts get information about a company in order to compete with other companies in the market? It is through data warehouse. A data warehouse can boost business efficiency by gathering information fast and efficiently. A data warehouse gives us a consistent view of consumers and things, which aids in customer relationship management. A data warehouse can also help you save money by tracking trends and patterns over time in a consistent and reliable way. A data warehouse architecture is a way of describing the total architecture of data communication, processing, and presentation for end-user computing within an organization. Each data warehouse is unique, yet they all have the same essential components. Online transaction processing is designed into production systems including payroll, accounts payable, product purchasing, and inventory control (OLTP). These apps collect detailed data from day-to-day operations. Data Warehouse applications are built to serve users' ad-hoc data requests, a practice called "online analytical processing" recently (OLAP). Applications such as forecasting are among them.

Gokul Pradeep

119 resources

0

2

3

Like