O'Reilly on Data

OCTOBER 19, 2021

We need robust versioning for data, models, code, and preferably even the internal state of applications—think Git on steroids to answer inevitable questions: What changed? The applications must be integrated to the surrounding business systems so ideas can be tested and validated in the real world in a controlled manner.

IT 346

IT Testing Experimentation Software 346

Alation

JANUARY 17, 2023

The modern data stack is a combination of various software tools used to collect, process, and store data on a well-integrated cloud-based data platform. It is known to have benefits in handling data due to its robustness, speed, and scalability. A typical modern data stack consists of the following: A data warehouse.

Data Warehouse 52

Data Warehouse Cost-Benefit Data Transformation Data Science 52

AWS Big Data

NOVEMBER 16, 2023

Amazon Redshift is a popular cloud data warehouse, offering a fully managed cloud-based service that seamlessly integrates with an organization’s Amazon Simple Storage Service (Amazon S3) data lake, real-time streams, machine learning (ML) workflows, transactional workflows, and much more—all while providing up to 7.9x

Enterprise 83

Enterprise Data Warehouse Data Lake Optimization 83

AWS Big Data

FEBRUARY 8, 2023

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. Amazon Redshift enables you to run complex SQL analytics at scale and performance on terabytes to petabytes of structured and unstructured data, and make the insights widely available through popular business intelligence (BI) and analytics tools.

Data Quality 74

Data Quality Testing Data Warehouse Unstructured Data 74

AWS Big Data

JUNE 29, 2023

In this post, we discuss why AWS recommends moving from Kinesis Data Analytics for SQL Applications to Amazon Kinesis Data Analytics for Apache Flink to take advantage of Apache Flink’s advanced streaming capabilities. View the stream data. Transform and enrich the data. Manipulate the data with Python.

Data Analytics 73

Data Analytics Analytics IoT Data Lake 73

AWS Big Data

APRIL 27, 2023

With these features, you can now build data pipelines completely in standard SQL that are serverless, more simple to build, and able to operate at scale. Typically, data transformation processes are used to perform this operation, and a final consistent view is stored in an S3 bucket or folder.

Data Lake 71

Data Lake Snapshot Optimization Data Transformation 71

AWS Big Data

NOVEMBER 29, 2023

dbt is an open source, SQL-first templating engine that allows you to write repeatable and extensible data transforms in Python and SQL. dbt is predominantly used by data warehouses (such as Amazon Redshift ) customers who are looking to keep their data transform logic separate from storage and engine.

Data Lake 102

Data Lake Management Metrics Data Warehouse 102

Occam's Razor

OCTOBER 19, 2010

so you have some reference as to where each item fits (and this will also make it easier for you to pick tools for the priority order referenced in Context #3 above). If after rigorous analysis you have determined that you have evolved to a stage that you need a data warehouse then you are out of luck with Yahoo!

Analytics 135

Analytics Testing Measurement Optimization 135

Smarten

JANUARY 4, 2018

Extract, Transform and Load (ETL) refers to a process of connecting to data sources, integrating data from various data sources, improving data quality, aggregating it and then storing it in staging data source or data marts or data warehouses for consumption of various business applications including BI, Analytics and Reporting.

Data Warehouse 40

Data Warehouse OLAP Data Governance Optimization 40

Jet Global

FEBRUARY 23, 2024

This field guide to data mapping will explore how data mapping connects volumes of data for enhanced decision-making. Why Data Mapping is Important Data mapping is a critical element of any data management initiative, such as data integration, data migration, data transformation, data warehousing, or automation.

Data Warehouse 52

Data Warehouse Reporting Data Transformation Sales 52

Jet Global

MAY 1, 2023

that gathers data from many sources. These sit on top of data warehouses that are strictly governed by IT departments. The role of traditional BI platforms is to collect data from various business systems. Strategic Objective Create a complete, user-friendly view of the data by preparing it for analysis.

Analytics 52

Analytics Cost-Benefit Visualization Dashboards 52