Enterprise Data Warehouse

Data Warehousing with Apache Hive on AWS: Architecture Patterns


Big Data Warehousing Data Warehousing is Dead? Or Long Live Data Warehousing? Every large organization has an enormous amount of historical data tied up in relational databases in the form of data warehouses and data marts. These data warehouses are the workhorses behind business intelligence reporting and analytics. Even when an organization is embarking on […]

Enterprise Data Lake Architecture: What to Consider When Designing


The Business Case of a Well Designed Data Lake Architecture Let’s start with the standard definition of a data lake: A data lake is a storage repository that holds a vast amount of raw data in its native format, including structured, semi-structured, and unstructured data. The data structure and requirements are not defined until the […]

Is Your Legacy Data Warehouse an Unruly Octopus?


This is the first article in a multi-part series discussing the strategic considerations and crucial technical details that senior managers and CxOs need to consider in an enterprise-wide analytics infrastructure modernization strategy. The Old Octopus and Its Tentacles If we walked into a Fortune 500 company today and investigated the analytics infrastructure that supports its […]

How to Successfully Adopt an Enterprise Data Warehouse in the Cloud


By adopting a cloud EDW to compliment existing EDW platforms, organizations can allow more agile growth, more flexibility in workload location and better cost points for different types of workloads. The EDW is a key technology used in every large company today. EDWs can support a variety of workloads, including financial reporting, customer satisfaction analysis, […]