Enterprise Data Warehouse (EDW) is a strategy for centralization and presentation of corporate data that facilitates timely and accurate business decisions.
We categorize the EDW functions in 4 main areas of focus or expertise:
Loading: Gathering Data from Source Systems
- Finance
- Sales
- Product
- ERP
- Other
Preparation: Logical & Physical Data Structures
- Database architecture
- Data Cleansing
- Tuning
- Data Packaging
- Data Access
- Data Integration
- Security/Views
Reporting & Analytics: Enterprise Reporting & Analytics
- Operational Reports
- Data Analytics
- Dashboards & Scorecards
- OLAP reports
- Ad Hoc Queries
- Forecasts & Modeling
Governance: Enterprise Data Management
- Executive Sponsorship
- Data Owner & Steward
- Master Data Management
- Enterprise Data Model
Increased benefits of EDW
- Increased usage of Business intelligence
- Increased business user satisfaction
- Increased decision-making speed
- Better understanding of the value of BI
- Decreased Software costs
- Decreased staff costs