Data Science Blog

MAY 15, 2023

tl;dr Ein Data Lakehouse ist eine moderne Datenarchitektur, die die Vorteile eines Data Lake und eines Data Warehouse kombiniert. Organisationen können je nach ihren spezifischen Bedürfnissen und Anforderungen zwischen einem Data Warehouse und einem Data Lakehouse wählen.

Data Warehouse 147

Data Warehouse Data Lakes Azure AWS 147

Alation

APRIL 25, 2023

That means if you haven’t already incorporated a plan for data governance into your long-term vision for your business, the time is now. Let’s take a closer look at what data governance is — and the top five mistakes to avoid when implementing it. 5 common data governance mistakes 1.

Data Governance 52

Data Governance ETL Natural Language Processing Machine Learning 52

Data Science Dojo

JULY 6, 2023

Data engineering tools offer a range of features and functionalities, including data integration, data transformation, data quality management, workflow orchestration, and data visualization. Essential data engineering tools for 2023 Top 10 data engineering tools to watch out for in 2023 1.

Data Engineering 195

Data Engineering Data Engineer Data Engineering Data Engineering 195

Dataversity

JANUARY 28, 2021

It has been ten years since Pentaho Chief Technology Officer James Dixon coined the term “data lake.” While data warehouse (DWH) systems have had longer existence and recognition, the data industry has embraced the more […]. The post A Bridge Between Data Lakes and Data Warehouses appeared first on DATAVERSITY.

Data Lakes 59

Data Lakes Data Warehouse Data Quality Data Governance 59

Dataversity

MARCH 1, 2021

Data warehouse (DW) testers with data integration QA skills are in demand. Data warehouse disciplines and architectures are well established and often discussed in the press, books, and conferences. Each business often uses one or more data […]. Each business often uses one or more data […].

Data Warehouse 52

Data Warehouse ETL Data Governance Data Quality 52

Alation

APRIL 25, 2023

That means if you haven’t already incorporated a plan for data governance into your long-term vision for your business, the time is now. Let’s take a closer look at what data governance is — and the top five mistakes to avoid when implementing it. 5 common data governance mistakes 1.

Data Governance 40

Data Governance ETL Natural Language Processing Machine Learning 40

Alation

JANUARY 26, 2023

These data requirements could be satisfied with a strong data governance strategy. Governance can — and should — be the responsibility of every data user, though how that’s achieved will depend on the role within the organization. How can data engineers address these challenges directly?

Data Governance 52

Data Governance Data Engineering Data Engineer Data Engineering 52

Dataversity

FEBRUARY 1, 2021

Project sponsors seek to empower more and better data-driven decisions and actions throughout their enterprise; they intend to expand their […]. The post Avoid These Mistakes on Your Data Warehouse and BI Projects: Part 3 appeared first on DATAVERSITY.

Data Warehouse 59

Data Warehouse Business Intelligence Business Intelligence Data Profiling 59

Alation

SEPTEMBER 7, 2021

In the previous blog , we discussed how Alation provides a platform for data scientists and analysts to complete projects and analysis at speed. In this blog we will discuss how Alation helps minimize risk with active data governance. So why are organizations not able to scale governance? Meet Governance Requirements.

Data Governance 59

Data Governance Data Scientist Data Quality Data Profiling 59

Dataversity

NOVEMBER 1, 2021

Whether through acquisition or organic growth, the amount of enterprise data coming into the organization can feel exponential as the business hires more people, opens new locations, and serves new customers. The post Building a Grassroots Data Management and Data Governance Program appeared first on DATAVERSITY.

Data Governance 52

Data Governance Data Silos Data Warehouse Data Quality 52

Data Science Dojo

JANUARY 12, 2023

When it comes to data, there are two main types: data lakes and data warehouses. What is a data lake? An enormous amount of raw data is stored in its original format in a data lake until it is required for analytics applications. Which one is right for your business? Let’s take a closer look.

Data Lakes 222

Data Lakes Data Warehouse Hadoop Machine Learning 222

ODSC - Open Data Science

SEPTEMBER 27, 2023

In this article, we will delve into the concept of data lakes, explore their differences from data warehouses and relational databases, and discuss the significance of data version control in the context of large-scale data management. Schema Enforcement: Data warehouses use a “schema-on-write” approach.

Data Lakes 98

Data Lakes Data Warehouse Database Big Data 98

IBM Journey to AI blog

APRIL 25, 2023

To do so, Presto and Spark need to readily work with existing and modern data warehouse infrastructures. Now, let’s chat about why data warehouse optimization is a key value of a data lakehouse strategy. To effectively use raw data, it often needs to be curated within a data warehouse.

Data Warehouse 57

Data Warehouse Data Engineering Data Engineer Data Engineering 57

Data Science Blog

MARCH 30, 2023

Eine bessere Idee ist es daher, Event Logs nicht in einzelnen Process Mining Tools aufzubereiten, sondern zentral in einem dafür vorgesehenen Data Warehouse zu erstellen, zu katalogisieren und darüber auch die grundsätzliche Data Governance abzusichern. Dank AI werden damit noch viel verborgenere Prozesse sichtbar.

Data Warehouse 147

Data Warehouse Business Intelligence Business Intelligence Power BI 147

Dataversity

FEBRUARY 13, 2024

Are you drowning in data? Feeling shackled by rigid data warehouses that can’t keep pace with your ever-evolving business needs? Traditional data storage strategies are crumbling under the weight of diverse data sources, leaving you with limited analytics and frustrated decisions. You’re not alone.

Data Warehouse 57

Data Warehouse Analytics Analytics Data Governance 57

phData

SEPTEMBER 19, 2023

Cost reduction by minimizing data redundancy, improving data storage efficiency, and reducing the risk of errors and data-related issues. Data Governance and Security By defining data models, organizations can establish policies, access controls, and security measures to protect sensitive data.

Data Lakes 52

Data Lakes Data Modeling Data Models Data Warehouse 52

Dataversity

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.

Data Quality 52

Data Quality Data Warehouse Cloud Data Data Governance 52

ODSC - Open Data Science

JUNE 12, 2023

They all agree that a Datamart is a subject-oriented subset of a data warehouse focusing on a particular business unit, department, subject area, or business functionality. The Datamart’s data is usually stored in databases containing a moving frame required for data analysis, not the full history of data.

Power BI 52

Power BI Data Warehouse ETL Data Preparation 52

Pickl AI

OCTOBER 19, 2023

Regular Data Audits Conduct regular data audits to identify issues and discrepancies. This proactive approach allows you to detect and address problems before they compromise data quality. Data Governance Framework Implement a robust data governance framework. How Do You Fix Poor Data Quality?

Data Quality 52

Data Quality Data Governance Data Warehouse Machine Learning 52

phData

APRIL 29, 2024

Understanding Fivetran Fivetran is a popular Software-as-a-Service platform that enables users to automate the movement of data and ETL processes across diverse sources to a target destination. The phData team achieved a major milestone by successfully setting up a secure end-to-end data pipeline for a substantial healthcare enterprise.

SQL 52

SQL Azure Data Warehouse Cloud Data 52

Data Science Dojo

SEPTEMBER 6, 2023

M aintaining the security and governance of data within a data warehouse is of utmost importance. Data Security: A Multi-layered Approach In data warehousing, data security is not a single barrier but a well-constructed series of layers, each contributing to protecting valuable information.

Data Warehouse 195

Data Warehouse Data Governance ETL Data Quality 195

Pickl AI

NOVEMBER 15, 2023

Discover the nuanced dissimilarities between Data Lakes and Data Warehouses. Data management in the digital age has become a crucial aspect of businesses, and two prominent concepts in this realm are Data Lakes and Data Warehouses. It acts as a repository for storing all the data.

Data Lakes 52

Data Lakes Data Warehouse Database ETL 52

Dataversity

FEBRUARY 10, 2023

It’s no surprise that, in 2023, business enterprises want to become truly data-driven organizations. For many of these organizations, the path toward becoming more data-driven lies in the power of data lakehouses, which combine elements of data warehouse architecture with data lakes.

Data Lakes 52

Data Lakes Data Warehouse Data Quality Data Governance 52

Alation

JULY 28, 2022

It’s costly and time-consuming to manage on-premises data warehouses — and modern cloud data architectures can deliver business agility and innovation. However, CIOs declare that agility, innovation, security, adopting new capabilities, and time to value — never cost — are the top drivers for cloud data warehousing.

Data Warehouse 69

Data Warehouse Cloud Data Data Governance Database 69

Data Science 101

DECEMBER 3, 2019

Do you have a data governance document? What data do you collect? Technical Questions Before Starting a Data Strategy. How and where is your current data stored? What is the current data infrastructure? Do you have a data warehouse? Do you use any external data?

Data Warehouse 84

Data Warehouse Data Governance Business Intelligence Business Intelligence 84

phData

APRIL 23, 2024

With their automated approach to data ingestion, Fivetran allows data teams to spend less time managing their data pipelines and more time on analysis and deriving insights for the business. Other organizations might have strict data governance policies that delegate who can work on and maintain these data connections.

Data Governance 52

Data Governance Data Pipeline Data Warehouse Cloud Data 52

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 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 Lakes 52

Data Lakes Data Warehouse Data Governance Business Intelligence 52

Dataversity

MAY 26, 2023

Suppose you’re in charge of maintaining a large set of data pipelines from cloud storage or streaming data into a data warehouse. How can you ensure that your data meets expectations after every transformation? That’s where data quality testing comes in.

Data Pipeline 52

Data Pipeline Data Warehouse Data Quality Data Observability 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 69

Data Warehouse Data Lakes Data Profiling Data Quality 69

Alation

JULY 30, 2021

A part of that journey often involves moving fragmented on-premises data to a cloud data warehouse. You clearly shouldn’t move everything from your on-premises data warehouses. Otherwise, you can end up with a data swamp. 2: Biz Problem – Making Data Ready for Business Analysis.

Data Warehouse 52

Data Warehouse Data Governance Cloud Data Machine Learning 52

Mlearning.ai

FEBRUARY 16, 2023

The ultimate need for vast storage spaces manifests in data warehouses: specialized systems that aggregate data coming from numerous sources for centralized management and consistency. In this article, you’ll discover what a Snowflake data warehouse is, its pros and cons, and how to employ it efficiently.

Data Warehouse 52

Data Warehouse Business Intelligence Business Intelligence Database 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 98

Data Governance Data Warehouse Data Quality 98

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.

Data Warehouse 59

Data Warehouse Data Quality Data Governance 59

IBM Journey to AI blog

OCTOBER 30, 2023

Thus, DB2 PureScale on AWS equips this insurance company to innovate and make data-driven decisions rapidly, maintaining a competitive edge in a saturated market. The platform provides an intelligent, self-service data ecosystem that enhances data governance, quality and usability.

AWS 83

AWS AI AI Data Warehouse 83

Alation

AUGUST 30, 2022

we are introducing Alation Anywhere, extending data intelligence directly to the tools in your modern data stack, starting with Tableau. We continue to make deep investments in governance, including new capabilities in the Stewardship Workbench, a core part of the Data Governance App. Data governance at scale.

Data Governance 52

Data Governance Data Quality Tableau Data Analyst 52

Alation

MAY 24, 2022

generally available on May 24, Alation introduces the Open Data Quality Initiative for the modern data stack, giving customers the freedom to choose the data quality vendor that’s best for them with the added confidence that those tools will integrate seamlessly with Alation’s Data Catalog and Data Governance application.

Data Quality 98

Data Quality Data Governance ETL Data Observability 98