AWS Big Data

AUGUST 1, 2024

Large-scale data warehouse migration to the cloud is a complex and challenging endeavor that many organizations undertake to modernize their data infrastructure, enhance data management capabilities, and unlock new business opportunities. This makes sure the new data platform can meet current and future business goals.

Data Warehouse 115

Data Warehouse KPI Optimization Cost-Benefit 115

AWS Big Data

JANUARY 15, 2025

AWS Database Migration Service (AWS DMS) is used to securely transfer the relevant data to a central Amazon Redshift cluster. The data in the central data warehouse in Amazon Redshift is then processed for analytical needs and the metadata is shared to the consumers through Amazon DataZone.

IoT 111

IoT Machine Learning Metadata Data-driven 111

Birst BI

FEBRUARY 25, 2020

Managing large-scale data warehouse systems has been known to be very administrative, costly, and lead to analytic silos. The good news is that Snowflake, the cloud data platform, lowers costs and administrative overhead. The post Birst automates the creation of data warehouses in Snowflake appeared first on Birst.

Data Warehouse 52

Data Warehouse Cost-Benefit Data Architecture Enterprise 52

AWS Big Data

NOVEMBER 9, 2023

In this post, we delve into a case study for a retail use case, exploring how the Data Build Tool (dbt) was used effectively within an AWS environment to build a high-performing, efficient, and modern data platform. It does this by helping teams handle the T in ETL (extract, transform, and load) processes.

Data Warehouse 126

Data Warehouse Testing Data Quality Reporting 126

AWS Big Data

AUGUST 9, 2024

Dafiti’s data infrastructure relies heavily on ETL and ELT processes, with approximately 2,500 unique processes run daily. Amazon Redshift at Dafiti Amazon Redshift is a fully managed data warehouse service, and was adopted by Dafiti in 2017. We started with 115 dc2.large We removed the DC2 cluster and completed the migration.

Data Lake 111

Data Lake Analytics Data Warehouse Data-driven 111

AWS Big Data

SEPTEMBER 5, 2024

Federated queries allow querying data across Amazon RDS for MySQL and PostgreSQL data sources without the need for extract, transform, and load (ETL) pipelines. If storing operational data in a data warehouse is a requirement, synchronization of tables between operational data stores and Amazon Redshift tables is supported.

IoT 111

IoT Data Warehouse Cost-Benefit Reporting 111

CIO Business Intelligence

APRIL 8, 2025

As data volumes and use cases scale especially with AI and real-time analytics trust must be an architectural principle, not an afterthought. Comparison of modern data architectures : Architecture Definition Strengths Weaknesses Best used when Data warehouse Centralized, structured and curated data repository.

Data Quality 102

Data Quality Data-driven Key Performance Indicator Metadata 102

DataKitchen

JULY 27, 2023

Azure Synapse Analytics Pipelines: Azure Synapse Analytics (formerly SQL Data Warehouse) provides data exploration, data preparation, data management, and data warehousing capabilities. It provides data prep, management, and enterprise data warehousing tools. It does the job. So go ahead.

Machine Learning 130

Machine Learning Cost-Benefit Data Transformation Testing 130

AWS Big Data

DECEMBER 21, 2023

To speed up the self-service analytics and foster innovation based on data, a solution was needed to provide ways to allow any team to create data products on their own in a decentralized manner. To create and manage the data products, smava uses Amazon Redshift , a cloud data warehouse.

Data Lake 115

Data Lake Data Warehouse Data-driven B2B 115

AWS Big Data

DECEMBER 4, 2024

These nodes can implement analytical platforms like data lake houses, data warehouses, or data marts, all united by producing data products. For instance, one enhancement involves integrating cross-functional squads to support data literacy.

Metadata 105

Metadata Data Governance Data Quality Data-driven 105

AWS Big Data

NOVEMBER 15, 2023

The difference lies in when and where data transformation takes place. In ETL, data is transformed before it’s loaded into the data warehouse. In ELT, raw data is loaded into the data warehouse first, then it’s transformed directly within the warehouse.

Dashboards 111

Dashboards Analytics Metadata Data Warehouse 111

Octopai

NOVEMBER 13, 2022

The modern data stack is a data management system built out of cloud-based data systems. A given modern data stack will usually include components for data ingestion from your data sources, data transformation, data storage, data analysis and reporting.

Enterprise 97

Enterprise Data Warehouse Reporting Metadata 97

DataKitchen

OCTOBER 5, 2021

Data operations (or data production) is a series of pipeline procedures that take raw data, progress through a series of processing and transformation steps, and output finished products in the form of dashboards, predictions, data warehouses or whatever the business requires. Their product is the data.

Testing 154

Testing Dashboards Measurement Experimentation 154

AWS Big Data

MAY 25, 2023

Data transformation plays a pivotal role in providing the necessary data insights for businesses in any organization, small and large. To gain these insights, customers often perform ETL (extract, transform, and load) jobs from their source systems and output an enriched dataset.

Reporting 95

Reporting Metrics Optimization Data Lake 95

AWS Big Data

SEPTEMBER 19, 2023

However, our legacy data warehouse-based solution was not equipped for this challenge. However, with a minimum data freshness of 10 minutes, this architecture inherently didn’t align with the near real-time fraud detection use case.

Analytics 109

Analytics Risk Big Data Machine Learning 109

Alation

OCTOBER 18, 2022

Alation is pleased to be named a dbt Metrics Partner and to announce the start of a partnership with dbt, which will bring dbt data into the Alation data catalog. In the modern data stack, dbt is a key tool to make data ready for analysis. Data Transformation in the Modern Data Stack.

Metadata 52

Metadata Metrics Recreation/Entertainment Data Quality 52

Sisense

MAY 11, 2021

Here at Sisense, we think about this flow in five linear layers: Raw This is our data in its raw form within a data warehouse. We follow an ELT ( E xtract, L oad, T ransform) practice, as opposed to ETL, in which we opt to transform the data in the warehouse in the stages that follow.

Modeling 84

Modeling Big Data IoT Data Warehouse 84

Cloudera

JUNE 17, 2022

In the second blog of the Universal Data Distribution blog series , we explored how Cloudera DataFlow for the Public Cloud (CDF-PC) can help you implement use cases like data lakehouse and data warehouse ingest, cybersecurity, and log optimization, as well as IoT and streaming data collection.

Cost-Benefit 94

Cost-Benefit IoT Data Warehouse Manufacturing 94

AWS Big Data

MARCH 3, 2023

Data ingestion – Steps 1 and 2 use AWS DMS, which connects to the source database and moves full and incremental data (CDC) to Amazon S3 in Parquet format. Data transformation – Steps 3 and 4 represent an EMR Serverless Spark application (Amazon EMR 6.9 Monjumi Sarma is a Data Lab Solutions Architect at AWS.

Data Lake 98

Data Lake Dashboards Metrics Metadata 98

Alation

OCTOBER 27, 2022

Few actors in the modern data stack have inspired the enthusiasm and fervent support as dbt. This data transformation tool enables data analysts and engineers to transform, test and document data in the cloud data warehouse. But what does this mean from a practitioner perspective?

Metrics 52

Metrics Dashboards Sales Reporting 52

AWS Big Data

MARCH 3, 2023

It has been well published since the State of DevOps 2019 DORA Metrics were published that with DevOps, companies can deploy software 208 times more often and 106 times faster, recover from incidents 2,604 times faster, and release 7 times fewer defects. Fixed-size data files avoid further latency due to unbound file sizes.

Software 52

Software Data Lake Testing Cost-Benefit 52

Occam's Razor

OCTOBER 19, 2010

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! If you can show ROI on a DW it would be a good use of your money to go with Omniture Discover, WebTrends Data Mart, Coremetrics Explore. Mongoose Metrics ~ ifbyphone.

Analytics 136

Analytics Testing Measurement Optimization 136

Jet Global

MAY 9, 2024

The key components of a data pipeline are typically: Data Sources : The origin of the data, such as a relational database , data warehouse, data lake , file, API, or other data store. This can include tasks such as data ingestion, cleansing, filtering, aggregation, or standardization.

Data Lake 52

Data Lake Data Warehouse Business Intelligence Machine Learning 52

Jet Global

MAY 1, 2023

As a result, end users can better view shared metrics (backed by accurate data), which ultimately drives performance. When treating a patient, a doctor may wish to study the patient’s vital metrics in comparison to those of their peer group. Visual Analytics Users are given data from which they can uncover new insights.

Analytics 52

Analytics Cost-Benefit Visualization Dashboards 52

Jet Global

OCTOBER 30, 2023

Together, CXO and Power BI provide you with access to insights from both EPM and BI data in one tool. You can now elevate their decision-making process by drilling down into more detailed data, and enriching EPM figures with non-financial data. Transforming Financial Reporting with Dynamic Dashboards Download Now 1.

Dashboards 52

Dashboards Reporting Operational Reporting Software 52

Jet Global

JULY 19, 2023

Data Connectivity Enhancements Data and content authors are the first users in the app building infrastructure and content. It is important for our customers to access advanced connectors and data transformation features so they can build a robust data layer.

Dashboards 52

Dashboards Visualization Reporting Interactive 52

AWS Big Data

DECEMBER 17, 2024

dbt provides a SQL-first templating engine for repeatable and extensible data transformations, including a data tests feature, which allows verifying data models and tables against expected rules and conditions using SQL. Solution overview DeNA designed the following architecture using AWS serverless services.

Data Quality 90

Data Quality Testing Metrics Optimization 90

AWS Big Data

APRIL 29, 2025

While enabling organization-wide efficiency, the team also applied these principles to the data architecture, making sure that CLEA itself operates frugally. After evaluating various tools, we built a serverless data transformation pipeline using Amazon Athena and dbt. The Source stage maintains raw data in its original form.

Data Transformation 54

Data Transformation Cost-Benefit Testing Data Lake 54