Tag: data warehouse

May 15, 2023

Your CEO knows what a database is and probably thinks a data warehouse is a large data vault used for reporting and analytics. They know little about NoSQL data stores, why they need a Spark cluster, or how data lakes […]

May 3, 2023

A data warehouse stores data from in-house systems and various outside sources. Data warehouses are designed to support the decision-making process through data collection, consolidation, analytics, and research. They can be used in analyzing a specific subject area, such as […]

April 18, 2023

The ability to integrate data successfully into a single platform can be a challenge. Well-integrated data makes it easy for the appropriate staff to access and work with it. Poorly integrated data creates problems. Data integration can be described as […]

April 11, 2023

Structured data and unstructured data are both forms of data, but the first uses a single standardized format for storage, and the second does not. Structured data must be appropriately formatted (or reformatted) to provide a standardized data format before […]

April 6, 2023

In 1865, Richard Millar Devens presented the phrase “Business Intelligence” (BI) in the “Cyclopædia of Commercial and Business Anecdotes.” He used it to describe how Sir Henry Furnese, a banker, profited from information by gathering and acting on it before […]

February 22, 2023

Snowflake on Wednesday said it was making another industry-specific product available in the form of managed Telecom Data Cloud, nearly a year after launching Retail Data Cloud and the Healthcare and Life Sciences Data Cloud offering. With Snowflake’s proprietary cloud […]

January 25, 2023

Over the past few years, enterprise data architectures have evolved significantly to accommodate the changing data requirements of modern businesses. The emergence of advanced data storage technologies, such as cloud computing, data hubs, and data lakes, makes us question the […]

January 18, 2023

Businesses rely on knowing their data to survive and grow. Metadata management and master data management (MDM) provide essential processes for organizations to gain this knowledge and succeed. As a result, both need to be managed well. However, the differences […]

December 12, 2022

When it comes to data sources, analytic apps developers are facing new and increasingly complex challenges, such as having to deal with higher demand from event data and streaming sources. Here in the early stages of this “stream revolution,” developers […]

October 28, 2022

In the past, designing and developing a robust data warehouse that satisfied the need for timely and effective business intelligence (BI) was an overwhelmingly difficult task, as it required significant time, capital, and risk. However, the advent of agile data […]

September 16, 2022

From the humble data warehouse to the lake and swamp to potentially an ocean of data, take your pick where you want to drown yourself. The reality is the customer doesn’t care about the fancy lake or the Kafka pipelines; […]

August 26, 2022

Companies across sectors and of all sizes face a common problem: understanding their profit margins and identifying the levers that are attributing to those margins. It’s as fundamental to business operations as you can get – if the margin isn’t […]

May 24, 2022

Data warehouses have advanced in the past few years, adding multiple enhancements and new capabilities. A data warehouse stores business data from a variety of applications and databases. It acts as a single repository, which an organization can access with […]

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 […]