The Data Administration Newsletter

SEPTEMBER 14, 2021

Data lake is a newer IT term created for a new category of data store. But just what is a data lake? According to IBM, “a data lake is a storage repository that holds an enormous amount of raw or refined data in native format until it is accessed.” That makes sense. I think the […].

Data Warehouse 91

Data Warehouse Data Management Business Intelligence Business Intelligence 91

Astera

FEBRUARY 26, 2024

Azure SQL Data Warehouse, now called Azure Synapse Analytics, is a powerful analytics and BI platform that enables organizations to process and analyze large volumes of data in a centralized place. However, this data is often scattered across different systems, making it difficult to consolidate and utilize effectively.

Data Warehouse 52

Data Warehouse Data Quality Real-time Data Documentation 52

Actian

JULY 26, 2019

So, you have made the business case to modernize your data warehouse. But how do you effectively go about choosing the right data warehouse to migrate to? Should you stay with your existing traditional data warehouse provider as they try to convince you to stay on-premise with their latest appliance?

Data Warehouse 40

Data Warehouse Government Predictive Analytics Banking 40

Astera

JANUARY 18, 2024

Fivetran is a low-code/no-code ELT (Extract, load and transform) solution that allows users to extract data from multiple sources and load it into the destination of their choice, such as a data warehouse. So, in this article, we will explore some of the best alternatives to Fivetran. Award-winning customer support.

Data Warehouse 52

Data Warehouse Data Quality Data Management Government 52

Dataversity

DECEMBER 16, 2020

According to IDC, the size of the global datasphere is projected to reach 163 ZB by 2025, leading to the disparate data sources in legacy systems, new system deployments, and the creation of data lakes and data warehouses. Most organizations do not utilize the entirety of the data […].

Data Warehouse 173

Data Warehouse Data Quality Data Governance Government 173

Dataversity

DECEMBER 14, 2020

It was only a few years ago that BI and data experts excitedly claimed that petabytes of unstructured data could be brought under control with data pipelines and orderly, efficient data warehouses. But as big data continued to grow and the amount of stored information increased every […].

Data Warehouse 147

Data Warehouse Big Data Data Architecture Data Management 147

The Data Administration Newsletter

APRIL 19, 2022

Introduction We are living in the age of a data revolution, and more corporations are realizing that to lead—or in some cases, to survive—they need to harness their data wealth effectively.

Data Warehouse 72

Data Warehouse Data Modelling Data Management Business Intelligence 72

Astera

JUNE 13, 2023

The ETL process involves extracting data from various sources and transforming it into a structured format suitable for analysis. Finally, it involves loading it into a data warehouse or any other type of destination. Transformation: Data is cleaned, filtered, and manipulated to ensure quality and consistency.

Data Warehouse 52

Data Warehouse Data Quality Real-time Data Visualization 52

Astera

JUNE 13, 2023

The ETL process involves extracting data from various sources and transforming it into a structured format suitable for analysis. Finally, it involves loading it into a data warehouse or any other type of destination. Transformation: Data is cleaned, filtered, and manipulated to ensure quality and consistency.

Data Warehouse 52

Data Warehouse Data Quality Real-time Data Visualization 52

Astera

JUNE 13, 2023

The ETL process involves extracting data from various sources and transforming it into a structured format suitable for analysis. Finally, it involves loading it into a data warehouse or any other type of destination. Transformation: Data is cleaned, filtered, and manipulated to ensure quality and consistency.

Data Warehouse 52

Data Warehouse Data Quality Real-time Data Visualization 52

Astera

DECEMBER 29, 2023

Among the key players in this domain is Microsoft, with its extensive line of products and services, including SQL Server data warehouse. In this article, we’re going to talk about Microsoft’s SQL Server-based data warehouse in detail, but first, let’s quickly get the basics out of the way.

Data Warehouse 52

Data Warehouse Data Management Data Modelling Data Quality 52

Astera

DECEMBER 29, 2023

Among the key players in this domain is Microsoft, with its extensive line of products and services, including SQL Server data warehouse. In this article, we’re going to talk about Microsoft’s SQL Server-based data warehouse in detail, but first, let’s quickly get the basics out of the way.

Data Warehouse 52

Data Warehouse Data Management Data Modelling Data Quality 52

ElegantJ BI

SEPTEMBER 30, 2021

When a business enters the domain of data management, it is easy to get lost in a flurry of promises, brochures, demos and the promise of the future. In this article, we will present the factors and considerations involved in choosing the right data management solution for your business.

Data Management 130

Data Management Data Warehouse Data Governance Government 130

ElegantJ BI

SEPTEMBER 30, 2021

When a business enters the domain of data management, it is easy to get lost in a flurry of promises, brochures, demos and the promise of the future. In this article, we will present the factors and considerations involved in choosing the right data management solution for your business. Data Warehouse.

Data Management 130

Data Management Data Warehouse Data Governance Government 130

ElegantJ BI

SEPTEMBER 30, 2021

When a business enters the domain of data management, it is easy to get lost in a flurry of promises, brochures, demos and the promise of the future. In this article, we will present the factors and considerations involved in choosing the right data management solution for your business. Data Warehouse.

Data Management 130

Data Management Data Warehouse Data Governance Government 130

The Data Administration Newsletter

MAY 16, 2023

Data quality management (DQM) has advanced considerably over the years. The full extent of the problem was first recognized during the data warehouse movement in the 1980s.

Data Quality 52

Data Quality Data Warehouse Master Data Management Data Governance 52

The Data Administration Newsletter

MAY 31, 2022

As we enter a new cloud-first era, advancements in technology have helped companies capture and capitalize on data as much as possible. Deciding between which cloud architecture to use has always been a debate between two options: data warehouses and data lakes.

Data Warehouse 52

Data Warehouse Data Governance Data Architecture Government 52

The Data Administration Newsletter

FEBRUARY 1, 2022

In this blog, we will discuss a common problem for data warehouses that are designed to maintain data quality and provide evidence of accuracy. Without verification, the data can’t be trusted. Enter the mundane, but necessary, task of data reconciliation. This is often a time-consuming and wasteful process.

Government 59

Government Data Warehouse Data Quality Data Governance 59

Dataversity

AUGUST 5, 2021

According to Gartner, data fabric is an architecture and set of data services that provides consistent functionality across a variety of environments, from on-premises to the cloud. Data fabric simplifies and integrates on-premises and cloud Data Management by accelerating digital transformation.

Digital Transformation 246

Digital Transformation Digital Data Management Data Warehouse 246

Tableau

FEBRUARY 14, 2022

Editor’s note: This article originally appeared in Forbes. The data lakehouse is one such architecture—with “lake” from data lake and “house” from data warehouse. Invest in strong data management and governance up front—it pays off downstream. Vidya Setlur. Director of Research, Tableau.

Chief Data Officer 73

Chief Data Officer Supply Chain Government Data Architecture 73

GAVS Technology

NOVEMBER 3, 2020

As evident in most hospitals, these information are usually scattered across multiple data sources/databases. Hospitals typically create a data warehouse by consolidating information from multiple resources and try to create a unified database. Limitations of Current Methods. GRAPH processing In Rhodium.

Healthcare 52

Healthcare Data Mining Data Warehouse Data Management 52

Tableau

FEBRUARY 14, 2022

Editor’s note: This article originally appeared in Forbes. The data lakehouse is one such architecture—with “lake” from data lake and “house” from data warehouse. Invest in strong data management and governance up front—it pays off downstream. Vidya Setlur. Director of Research, Tableau.

Chief Data Officer 71

Chief Data Officer Supply Chain Government Data Architecture 71

Astera

JUNE 13, 2023

Data pipelines are a fundamental element in today’s technology landscape, providing seamless data movement and valuable insights for businesses. In this article, we will explore the concept of data pipelines, their key components, and the various use cases and benefits they offer. Find out How

E-Commerce 52

E-Commerce Data Quality Real-time Data Data Warehouse 52

Ntara

JULY 26, 2021

What is a “homegrown” product data system? Most manufacturing organizations have some kind of database or data warehouse that holds lots and lots of company information. If this sounds like you, and you haven’t intentionally setup a PIM or other data management system, this article is for you.

Data Warehouse 52

Data Warehouse Digital Logistics Process Analysis 52

Ntara

JULY 26, 2021

What is a “homegrown” product data system? Most manufacturing organizations have some kind of database or data warehouse that holds lots and lots of company information. If this sounds like you, and you haven’t intentionally setup a PIM or other data management system, this article is for you.

Data Warehouse 52

Data Warehouse Digital Logistics Process Analysis 52

Astera

MARCH 20, 2024

This article covers everything about enterprise data management, including its definition, components, comparison with master data management, benefits, and best practices. What Is Enterprise Data Management (EDM)? Why is Enterprise Data Management Important?

Data Management 52

Data Management Master Data Management Data Warehouse Government 52

Astera

JANUARY 2, 2024

Relying on this data to power business decisions is like setting sail without a map. This is why organizations have effective data management in place. But what exactly is data management? What Is Data Management? As businesses evolve, so does their data.

Data Management 52

Data Management Data Warehouse Data Governance Data Quality 52

Smart Data Collective

DECEMBER 13, 2022

Five Best Practices for Data Analytics. Extracted data must be saved someplace. There are several choices to consider, each with its own set of advantages and disadvantages: Data warehouses are used to store data that has been processed for a specific function from one or more sources. Select a Storage Platform.

Visualization 334

Visualization Data Analytics Data Analytics Artificial Intelligence 334

Actian

DECEMBER 2, 2019

Checklist: Critical Capabilities to Consider when Selecting a Data Integration Vendor That Enables Real-Time Analytics Use Cases. Migrating to a cloud data warehouse makes strategic sense in the modern context of cloud services and digital transformation. If you missed the first article in this series, you can view it here.

Data Warehouse 8

Data Warehouse Digital Transformation Real-time Data Vision 8

Business Analysis Knowledge Share

OCTOBER 24, 2023

To excel in this role, it’s crucial for Business Analysts to have a solid understanding of Data Warehousing concepts. This article aims to provide a comprehensive overview of Data Warehousing, breaking down key concepts that every Business Analyst should know. What is Data Warehousing?

IBM Maintenance 73

IBM Maintenance Data Warehouse IBM cost Data Quality 73

Actian

DECEMBER 9, 2019

How Avalanche and DataConnect work together to deliver an end-to-end data management solution. Migrating to a cloud data warehouse makes strategic sense in the modern context of cloud services and digital transformation. If you missed the first two articles in this series, you can view them here and here.

Data Warehouse 8

Data Warehouse Digital Transformation Supply Chain Real-time Data 8

Data Pine

MARCH 31, 2022

For instance, you will learn valuable communication and problem-solving skills, as well as business and data management. Added to this, if you work as a data analyst you can learn about finances, marketing, IT, human resources, and any other department that you work with. Business Intelligence Job Roles.

Business Intelligence 95

Business Intelligence Business Intelligence Data Visualization Visualization 95

Dataversity

FEBRUARY 18, 2022

They say that history repeats itself, and that those who don’t remember the past are doomed to repeat it. We’re about to see another instance – with regards to consolidation – where these old adages ring true. Years ago, at the start of the cloud revolution, companies began to flee from the idea of a monolithic, […].

Data Warehouse 246

Data Warehouse Data Architecture Data Management 246

Astera

JANUARY 31, 2024

So, in this article we will explore some of the most capable SQL ETL tools for data integration. While SSIS is Microsoft’s own ETL service, it’s not the only player in the data integration landscape that enables users to implement ETL in SQL Server, as we’ll see later in the article.

Data Warehouse 52

Data Warehouse Visualization Data Management Data Quality 52

Dataversity

MAY 31, 2021

As I’ve been working to challenge the status quo on Data Governance – I get a lot of questions about how it will “really” work. The post Dear Laura: Should We Hire Full-Time Data Stewards? Click to learn more about author Laura Madsen. Welcome to the Dear Laura blog series! Last year I wrote […].

Data Governance 246

Data Governance Government Master Data Management Data Warehouse 246

Astera

DECEMBER 28, 2023

So, in this article, we’re going to compare Airbyte vs Fivetran vs Astera, three of the best data integration tools , to help you make an informed decision. Fivetran Fivetran is a cloud-based data movement platform that relies solely on ELT to move data between two systems.

Data Warehouse 52

Data Warehouse Data Quality Documentation Data Management 52

Astera

DECEMBER 28, 2023

So, in this article, we’re going to compare Airbyte vs Fivetran vs Astera, three of the best data integration tools , to help you make an informed decision. Fivetran Fivetran is a cloud-based data movement platform that relies solely on ELT to move data between two systems.

Data Warehouse 52

Data Warehouse Data Quality Documentation Data Management 52