4 answers
4
Questions
4 answers
Updated
GIRIDHAR RAO’s Answer
Evelyn,
A simple answer is that an enterprise data warehouse (EDW) is a centralized data storage across the organization. Typically, data is formatted and more organized in EDW readily available for data analytics and decision making
A simple answer is that an enterprise data warehouse (EDW) is a centralized data storage across the organization. Typically, data is formatted and more organized in EDW readily available for data analytics and decision making
Updated
Sri’s Answer
Large enterprises typically have 100s of business applications with each application having its own databases. For example e-commerce, inventory, sales, account receivables and accounts payable to name a few. To see how well the business is doing, business users or executives might have to look into 10 different applications. Even then they may not find the accurate data. The enterprise data warehouse (EDW) addresses this problem. Basically through ETL (Extract, Transform and Load) process related data from disparate databases are ingested into EDW then analyzed and reported via reporting dashboards.
EDW now evolved into Data Lake and other synonyms used are Big data and Hadoop. These platform allow you to ingest data from both relational and non-relational databases (structured and unstructured data). You can derive insights out of Bigdata using varieties of business intelligence tools.
Data Warehouse in the era of Bigdata: http://www.dbta.com/BigDataQuarterly/Articles/Data-Warehousing-in-the-Era-of-Big-Data-108590.aspx
Business Intelligence Software: https://en.wikipedia.org/wiki/Business_intelligence_software
EDW now evolved into Data Lake and other synonyms used are Big data and Hadoop. These platform allow you to ingest data from both relational and non-relational databases (structured and unstructured data). You can derive insights out of Bigdata using varieties of business intelligence tools.
Sri recommends the following next steps:
Updated
Raphael’s Answer
Referencing Wiki:
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
Simply put, this is a place to store financial accounting data, sales & distribution data, materials management data, human resource data, quality management data, materials data, etc.. which provides a central location with structured data. This data represents much of what is known about the business and allows data scientists and business staff to manage & track against current goals or strategize about new opportunities. Before enterprise data warehouses the data was very silo'd and not structured in a way to allowed easy access or usable data for analytics. There are many vendors in this space including SAP, Oracle, Microsoft and expertise in this area is still in high demand.
Reference:
Wiki: https://en.wikipedia.org/wiki/Data_warehouse
Look up some of the vendors to see if they offer free training or provide more information.
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
Simply put, this is a place to store financial accounting data, sales & distribution data, materials management data, human resource data, quality management data, materials data, etc.. which provides a central location with structured data. This data represents much of what is known about the business and allows data scientists and business staff to manage & track against current goals or strategize about new opportunities. Before enterprise data warehouses the data was very silo'd and not structured in a way to allowed easy access or usable data for analytics. There are many vendors in this space including SAP, Oracle, Microsoft and expertise in this area is still in high demand.
Reference:
Wiki: https://en.wikipedia.org/wiki/Data_warehouse
Raphael recommends the following next steps:
Updated
Krishna Chaitanya’s Answer
It is a centralized data store for the organization which can be used for variety of needs. Reporting and BI are some of those. Data is EDW is often heavily modelled for different reporting needs. Some of them are deformalized to make it easily accessible for reporting. Usually transaction tables are heavily normalized, but for reporting it is tedious to hit the transactional tables as it takes complex joins to pull the data. It also effects the performance of the transactions. EDW solves the purpose by creating the heavily modeled tables creating for analytics and reporting. Tables in EDW are refreshed often as per the need