erwin

APRIL 29, 2020

These tools range from enterprise service bus (ESB) products, data integration tools; extract, transform and load (ETL) tools, procedural code, application program interfaces (API)s, file transfer protocol (FTP) processes, and even business intelligence (BI) reports that further aggregate and transform data.

Key Performance Indicator 111

Key Performance Indicator Metadata Data Governance Data Quality 111

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. usr/local/airflow/.local/bin/dbt

Data Warehouse 126

Data Warehouse Testing Data Quality Reporting 126

CIO Business Intelligence

JUNE 23, 2022

Yet as companies fight for skilled analyst roles to utilize data to make better decisions , they often fall short in improving the data supply chain and resulting data quality. Without a solid data supply-chain management practices in place, data quality often suffers. First mile/last mile impacts.

Data Quality 98

Data Quality Key Performance Indicator Metrics KPI 98

CIO Business Intelligence

DECEMBER 22, 2022

Databricks Lakehouse Platform: a data management platform that unifies data warehousing and AI use cases Datafold: A data quality platform for detecting and fixing data quality issues DataKitchen: A data observability and automation platform that orchestrates end-to-end multi-tool, multi-environment data pipelines Dbt: A data transformation tool for (..)

Analytics 130

Analytics Machine Learning Data mining Software 130

CIO Business Intelligence

JANUARY 24, 2024

“Establishing data governance rules helps organizations comply with these regulations, reducing the risk of legal and financial penalties. Clear governance rules can also help ensure data quality by defining standards for data collection, storage, and formatting, which can improve the accuracy and reliability of your analysis.”

Data Strategy 136

Data Strategy Strategy Unstructured Data Data Governance 136

Smart Data Collective

APRIL 29, 2020

The techniques for managing organisational data in a standardised approach that minimises inefficiency. Extraction, Transform, Load (ETL). The extraction of raw data, transforming to a suitable format for business needs, and loading into a data warehouse. Data transformation. Microsoft Azure.

Management 99

Management Data Warehouse Digital Transformation Dashboards 99

CIO Business Intelligence

NOVEMBER 7, 2023

Given the importance of sharing information among diverse disciplines in the era of digital transformation, this concept is arguably as important as ever. The aim is to normalize, aggregate, and eventually make available to analysts across the organization data that originates in various pockets of the enterprise.

Data Warehouse 142

Data Warehouse Digital Transformation Data-driven Reporting 142

AWS Big Data

AUGUST 1, 2024

However, you might face significant challenges when planning for a large-scale data warehouse migration. Additionally, organizations must carefully consider factors such as cost implications, security and compliance requirements, change management processes, and the potential disruption to existing business operations during the migration.

Data Warehouse 115

Data Warehouse KPI Optimization Cost-Benefit 115

Jet Global

MAY 28, 2019

Unlike a database, a data warehouse’s architecture is built for getting the data out, and not just through technical expertise, but for common users like management, executives, finance professionals, and other staff. A data warehouse is typically used by companies with a high level of data diversity or analytical requirements.

Data Warehouse 85

Data Warehouse Reporting Business Intelligence Sales 85

AWS Big Data

FEBRUARY 8, 2023

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 98

Data Quality Testing Data Warehouse Unstructured Data 98

CIO Business Intelligence

FEBRUARY 16, 2023

But to augment its various businesses with ML and AI, Iyengar’s team first had to break down data silos within the organization and transform the company’s data operations. Digitizing was our first stake at the table in our data journey,” he says. The offensive side?

Unstructured Data 105

Unstructured Data Data Lake Prescriptive Analytics Data Warehouse 105

CIO Business Intelligence

DECEMBER 6, 2023

Airbus was conceiving an ambitious plan to develop an open aviation data platform, Skywise, as a single platform of reference for all major aviation players that would enable them to improve their operational performance and business results and support Airbus’ own digital transformation.

Digital Transformation 116

Digital Transformation Software Cost-Benefit Manufacturing 116

AWS Big Data

JULY 20, 2023

Prior to the creation of the data lake, Orca’s data was distributed among various data silos, each owned by a different team with its own data pipelines and technology stack. Moreover, running advanced analytics and ML on disparate data sources proved challenging.

Data Lake 98

Data Lake Analytics Snapshot Data Quality 98

IBM Big Data Hub

MARCH 14, 2024

Businesses face significant hurdles when preparing data for artificial intelligence (AI) applications. The existence of data silos and duplication, alongside apprehensions regarding data quality, presents a multifaceted environment for organizations to manage.

Cost-Benefit 75

Cost-Benefit Metadata Optimization Management 75

AWS Big Data

MARCH 3, 2023

Additionally, the scale is significant because the multi-tenant data sources provide a continuous stream of testing activity, and our users require quick data refreshes as well as historical context for up to a decade due to compliance and regulatory demands. Finally, data integrity is of paramount importance.

Software 52

Software Data Lake Testing Cost-Benefit 52

AWS Big Data

APRIL 5, 2023

The company decided to use AWS to unify its business intelligence (BI) and reporting strategy for both internal organization-wide use cases and in-product embedded analytics targeted at its customers. If each tool tells a different story because it has different data, we won’t have alignment within the business on what this data means.”

Dashboards 52

Dashboards Reporting Cost-Benefit Visualization 52

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

MAY 9, 2024

Data pipelines are designed to automate the flow of data, enabling efficient and reliable data movement for various purposes, such as data analytics, reporting, or integration with other systems. 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

FEBRUARY 23, 2024

The quick and dirty definition of data mapping is the process of connecting different types of data from various data sources. Data mapping is a crucial step in data modeling and can help organizations achieve their business goals by enabling data integration, migration, transformation, and quality.

Data Warehouse 52

Data Warehouse Reporting Data Transformation Visualization 52

Jet Global

MARCH 14, 2024

The solution offers data movement, data science, real-time analytics, and business intelligence within a single platform. Jet’s interface lets you handle data administration easily, without advanced coding skills. You don’t need technical skills to manage complex data workflows in the Fabric environment.

Analytics 52

Analytics Management Reporting Data Quality 52

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. However, our initial data architecture led to challenges.

Data Transformation 54

Data Transformation Cost-Benefit Testing Data Lake 54

CIO Business Intelligence

MARCH 26, 2025

Use AI to improve data, and knowledge to improve AI The good news is AI is part of the solution, adds Siz. For example, gen AI can be used to generate synthetic data, and other forms of AI can be used to help analyze and improve data quality.

Data Quality 129

Data Quality Forecasting Unstructured Data Data-driven 129