Tag: data warehouse

May 11, 2022

How can an organization thrive in the 2020s, a changing and confusing time with significant Data Management demands and platform options such as data warehouses, Hadoop, and the cloud? Trying to save money by bandaging and using the same old […]

April 21, 2022

Anthony J. Algmin believes Data Architecture is moving from a time of chaos and tangles into something more clean and organized. Speaking at the DATAVERSITY Data Architecture Online Conference, Algmin looked at past predictions, current hot topics, and predictions for […]

March 2, 2022

Without effective and comprehensive validation, a data warehouse becomes a data swamp. With the accelerating adoption of Snowflake as the cloud data warehouse of choice, the need for autonomously validating data has become critical. While existing Data Quality solutions provide […]

December 28, 2021

A data model should show the relationships that exist between various customers, concepts, products, among many. Data Modeling describes the creation of a visual representation (a chart or diagram) of a data system, or parts of that system. It is […]

December 16, 2021

In the last five years, we’ve seen the cloud data warehouse, exemplified by Snowflake and BigQuery, become the dominant tool for large and small businesses that need to combine and analyze data. The initial use cases are usually classic decision […]

November 11, 2021

Solving business problems using big data depends upon the approach taken. For example, if an organization only knows data warehouses, then challenges will be framed to fit using a data warehouse. As Abraham Maslow, a prominent psychologist eloquently said “I […]

October 11, 2021

IT has weaponized jargon since the very beginning of IT itself. Jargon was a key element to create vendor lock-in situations during the ’90s and early 2000s. Moreover, complex usability helped in developing a network of certified (aka expensive and […]

August 30, 2021

DataOps, which focuses on automated tools throughout the ETL development cycle, responds to a huge challenge for data integration and ETL projects in general. ETL projects are increasingly based on agile processes and automated testing. ETL (i.e., extract, transform, load) […]

August 24, 2021

Databases are typically classified as relational (SQL) or NoSQL, and transactional (OLTP), analytic (OLAP), or hybrid (HTAP). Departmental and special-purpose databases were initially considered huge improvements to business practices, but later derided as “islands.” Attempts to create unified databases for […]