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 106

Data Warehouse Testing Data Quality Reporting 106

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 91

Data Lake Data Warehouse Data-driven B2B 91

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

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 97

Dashboards Analytics Metadata Data Warehouse 97

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 77

Enterprise Data Warehouse Reporting Metadata 77

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 71

Reporting Metrics Optimization Data Lake 71

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 80

Analytics Risk Big Data Machine Learning 80

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

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

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 152

Testing Dashboards Measurement Experimentation 152

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 92

Cost-Benefit IoT Data Warehouse Manufacturing 92

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 85

Data Lake Dashboards Metrics Metadata 85

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

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

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

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 135

Analytics Testing Measurement Optimization 135