Principals of Data Warehousing
Data warehousing (DW) or enterprise data warehousing (EDW) has been around for a long time and its not going away anytime soon. It’s only getting more complicated as the technology landscape continues toward cloud computing, in-memory computing, machine learning and artificial intelligence continues to evolve.
At its simplest form, data warehouses are systems and processes used to collect both historical and current data sets from one or more data sources into a central, integrated repository for the purpose of analysis and analytical reporting. It’s no doubt an integral component of the larger Business Intelligence capabilities and competencies.
Part of the data warehousing principals are processes to technologies used to extract, transform, enrich, load and manage both data and metadata elements/dictionaries into the warehouse. The entire process is geared towards turning data into information and making it available to Analysts, Managers, and Executives who leverage BI Reporting and Dash-boarding tools or facilitate downstream BI Marts and Systems needed.
An expanded definition of data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository and tools to manage and retrieve metadata
Source – Wikipedia
Data Warehouse Architecture
Data Warehousing Benefits
- Source, Transform and Enrich Data from multiple sources into a logical data store, accessible by multiple reporting platforms
- A safe, cost-effective way to store historical data with users having reporting capabilities past the purge threshold of said data in its operational system
- Central, consolidated, cleansed, consistent data and data model across the entries organization
- Serves as a data-hub for downstream operational/functional/strategic data marts
- Provides a technical and operational approach to structure data in logical business-friendly terms for users
The Future of Data Warehousing – EDW Modernization
Data warehouse modernization will be what many organizations will be working on as we move into the future. With the emersion of technologies like Hadoop, public cloud services, noSQL, Hive and SQL-On Hadoop, and the shifts in data management and knowledge management principals, it’s only inevitable that EDWs evolves as well.
Sonora’s many years of implementing Oracle & Hyperion BI solutions coupled with your federal management consulting experience uniquely positions us your best choice for your data warehouse and business intelligence project.
Connect With Nicky on LinkedIn