Data warehousing

Data warehousing captures data from a variety of sources so it can be accessed and analyzed by business analysts, data scientists and other end users. One goal is to enhance data quality and consistency for analytics uses while improving business intelligence. Read how data warehousing provides these and other unique benefits to overall data management strategy.

September 23, 2022 23 Sep'22
How Lufthansa is flying its data warehouse to the cloud

Moving from an on-premises data system to the cloud can be a complex operation. Lufthansa is looking to remove some of the complexity with virtualization.
September 22, 2022 22 Sep'22
Google launches trio of new tools for its data cloud

The data management and analytics tools, including new data sharing and data lake platforms, are designed to let users access more data at lower expense.
September 15, 2022 15 Sep'22
Google eases cloud database migration, improves Datastream

Google wants to make migrating to its new AlloyDB database easier for its users as well as provide new support for database migration from PostgreSQL.
September 15, 2022 15 Sep'22
Ricoh modernizes its analytics with Qlik

The information management and digital services company is beginning to develop a data culture, and the BI vendor's platform has enabled new efficiencies.

Bring yourself up to speed with our introductory content

data warehouse as a service (DWaaS)

Data warehouse as a service (DWaaS) is an outsourcing model in which a cloud service provider configures and manages the hardware and software resources a data warehouse requires, and the customer provides the data and pays for the managed service. Continue Reading
Elastic Stack (ELK Stack)

The Elastic Stack is a group of open source products from Elastic designed to help users take data from any type of source and in any format, and search, analyze and visualize that data in real time. Continue Reading
How to evaluate and optimize data warehouse performance

Organizations build data warehouses to satisfy their information management needs. Data warehouse optimization can help ensure that these warehouses achieve their full potential. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

Cloud database comparison: AWS, Microsoft, Google and Oracle

Here's a look at the rival cloud database offerings from AWS, Google, Microsoft and Oracle based on their product breadth, migration capabilities and pricing models. Continue Reading
On-premises vs. cloud data warehouses: Pros and cons

Data warehouses increasingly are being deployed in the cloud. But both on-premises and cloud data warehouses have pluses and minuses to consider, as explained here. Continue Reading
Bill Inmon's data warehouse approach tackles text analysis

Learn the fine points of a concept at the heart of 'The Textual Warehouse' a new book that aims to help organizations profit through textual analysis. Continue Reading

Learn to apply best practices and optimize your operations.

NLP and AI boost the automated data warehouse

Businesses are working to automate as many elements of their data warehouses as they can through nascent tools like augmented analytics and natural language processing. Continue Reading
Top 5 elements needed for a successful data warehouse

While conventional data warehouses may struggle to keep up with growing volumes of data, these five elements best give the ability to tap into valuable BI. Continue Reading
6 strategies to tap into data warehouse BI

Data warehouse BI benefits include data storage, summarization and transformation and can be unlocked with these six strategies leveraging cloud architectures. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Dimension tables vs. fact tables: What's the difference?

Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading
Operational data store vs. data warehouse: How do they differ?

Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading
Key issues to consider when building a data warehouse

There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are from our data warehousing expert. Continue Reading