David Menninger's Analyst Perspectives

NOVEMBER 30, 2021

TIBCO is a large, independent cloud-computing and data analytics software company that offers integration, analytics, business intelligence and events processing software. It enables organizations to analyze streaming data in real time and provides the capability to automate analytics processes.

Analytics 175

Analytics Data Warehouse Business Intelligence Software 175

AWS Big Data

AUGUST 31, 2023

One of the major and essential parts in a data warehouse is the extract, transform, and load (ETL) process which extracts the data from different sources, applies business rules and aggregations and then makes the transformed data available for the business users.

Data Warehouse 83

Data Warehouse Data-driven Testing Business Intelligence 83

AWS Big Data

MARCH 7, 2024

At the same time, they need to optimize operational costs to unlock the value of this data for timely insights and do so with a consistent performance. With this massive data growth, data proliferation across your data stores, data warehouse, and data lakes can become equally challenging.

Data Lake 113

Data Lake Analytics Dashboards Metrics 113

AWS Big Data

FEBRUARY 12, 2024

Objective Gupshup wanted to build a messaging analytics platform that provided: Build a platform to get detailed insights, data, and reports about WhatsApp/SMS campaigns and track the success of every text message sent by the end customers. Additionally, extract, load, and transform (ELT) data processing is sped up and made easier.

Data Warehouse 100

Data Warehouse Analytics Snapshot Cost-Benefit 100

AWS Big Data

NOVEMBER 13, 2023

Join the AWS Analytics team at AWS re:Invent this year, where new ideas and exciting innovations come together. For those in the data world, this post provides a curated guide for all analytics sessions that you can use to quickly schedule and build your itinerary. A shapeshifting guardian and protector of data like Data Lynx?

Analytics 110

Analytics Data Lake Data Warehouse Data-driven 110

AWS Big Data

NOVEMBER 13, 2023

Amazon Redshift is a fully managed data warehousing service that offers both provisioned and serverless options, making it more efficient to run and scale analytics without having to manage your data warehouse. These upstream data sources constitute the data producer components.

Data Warehouse 92

Data Warehouse Data Lake Analytics Data Science 92

AWS Big Data

AUGUST 1, 2023

Although Jira Cloud provides reporting capability, loading this data into a data lake will facilitate enrichment with other business data, as well as support the use of business intelligence (BI) tools and artificial intelligence (AI) and machine learning (ML) applications. Search for the Jira Cloud connector.

Data Lake 85

Data Lake Data Transformation Cost-Benefit Data-driven 85

AWS Big Data

APRIL 27, 2023

Amazon Athena supports the MERGE command on Apache Iceberg tables, which allows you to perform inserts, updates, and deletes in your data lake at scale using familiar SQL statements that are compliant with ACID (Atomic, Consistent, Isolated, Durable).

Data Lake 74

Data Lake Snapshot Optimization Data Transformation 74

AWS Big Data

FEBRUARY 24, 2023

Data lakes are a popular choice for today’s organizations to store their data around their business activities. As a best practice of a data lake design, data should be immutable once stored. A data lake built on AWS uses Amazon Simple Storage Service (Amazon S3) as its primary storage environment.

Data Lake 83

Data Lake Metadata Testing Data Warehouse 83

DataKitchen

AUGUST 19, 2021

In figure 1 below, we see that the data requirements are quite different for each of three critical phases of a drug’s lifecycle: Table 1: Lifecycle phases of pharmaceutical product launch. Each distinct phase of the drug lifecycle requires a unique focus for analytics. Pharma Data Requirements. The new Recipes run, and BOOM!

Data Warehouse 246

Data Warehouse Data Lake Manufacturing Testing 246

AWS Big Data

MARCH 28, 2023

In a data warehouse, a dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. As organizations across the globe are modernizing their data platforms with data lakes on Amazon Simple Storage Service (Amazon S3), handling SCDs in data lakes can be challenging.

Data Lake 71

Data Lake Testing Snapshot Sales 71

Jet Global

JULY 2, 2019

The sheer scale of data being captured by the modern enterprise has necessitated a monumental shift in how that data is stored. From the humble database through to data warehouses , data stores have grown both in scale and complexity to keep pace with the businesses they serve, and the data analysis now required to remain competitive.

Data Lake 73

Data Lake Data Warehouse Big Data Machine Learning 73

Sisense

DECEMBER 23, 2019

Artificial Intelligence and machine learning are the future of every industry, especially data and analytics. AI and ML are the only ways to derive value from massive data lakes, cloud-native data warehouses, and other huge stores of information. Use AI to tackle huge datasets.

Data Lake 86

Data Lake Machine Learning Data Warehouse Digital Transformation 86

AWS Big Data

MARCH 7, 2023

This post provides guidance on how to build scalable analytical solutions for gaming industry use cases using Amazon Redshift Serverless. Flexible and easy to use – The solutions should provide less restrictive, easy-to-access, and ready-to-use data. Data hubs and data lakes can coexist in an organization, complementing each other.

Analytics 71

Analytics Data Warehouse Data Lake Metadata 71

AWS Big Data

FEBRUARY 22, 2023

In this post, we show how Ruparupa implemented an incrementally updated data lake to get insights into their business using Amazon Simple Storage Service (Amazon S3), AWS Glue , Apache Hudi , and Amazon QuickSight. An AWS Glue ETL job, using the Apache Hudi connector, updates the S3 data lake hourly with incremental data.

Data Lake 52

Data Lake Dashboards Cost-Benefit Metadata 52

CDW Research Hub

JULY 18, 2022

While many organizations understand the business need for a data and analytics cloud platform , few can quickly modernize their legacy data warehouse due to a lack of skills, resources, and data literacy. Sirius has created a lightweight development tool to rapidly build and deploy best-practice data models.

Optimization 87

Optimization Data Lake Data Warehouse Manufacturing 87

AWS Big Data

JANUARY 8, 2024

It aims to provide a framework to create low-latency streaming applications on the AWS Cloud using Amazon Kinesis Data Streams and AWS purpose-built data analytics services. In this post, we will review the common architectural patterns of two use cases: Time Series Data Analysis and Event Driven Microservices.

Analytics 113

Analytics IoT Data-driven Snapshot 113

Jet Global

MAY 9, 2024

A data pipeline is a series of processes that move raw data from one or more sources to one or more destinations, often transforming and processing the data along the way. Data pipelines support data science and business intelligence projects by providing data engineers with high-quality, consistent, and easily accessible data.

Data Lake 52

Data Lake Data Warehouse Business Intelligence Machine Learning 52

AWS Big Data

NOVEMBER 15, 2023

AWS re:Invent is a powerhouse of a learning event and every time I have attended, I’ve been amazed at its scale and impact. The analytics team is waiting to engage with our customers and partners at the analytics kiosk in the expo hall. And there are plenty of announcements you don’t want to miss!

Data Lake 65

Data Lake Data Warehouse B2B Deep Learning 65

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 89

Data Lake Data Warehouse Data-driven B2B 89

AWS Big Data

FEBRUARY 16, 2023

Amazon Redshift is the most widely used data warehouse in the cloud, best suited for analyzing exabytes of data and running complex analytical queries. Amazon QuickSight is a fast business analytics service to build visualizations, perform ad hoc analysis, and quickly get business insights from your data.

Data Warehouse 80

Data Warehouse Sales Visualization Data Processing 80

Cloudera

JANUARY 21, 2021

While cloud-native, point-solution data warehouse services may serve your immediate business needs, there are dangers to the corporation as a whole when you do your own IT this way. Of course you don’t want to re-create the risks and costs of data silos your organization has spent the last decade trying to eliminate.

Data Lake 94

Data Lake Data Warehouse IT Analytics 94

AWS Big Data

MAY 16, 2024

As technology continues to evolve, one specific facet of this journey is reaching unprecedented proportions: geospatial data. H3 indexing and related H3 spatial functions are now available for Amazon Redshift spatial analytics. Let’s dive into a use case to see how this can be used to solve an example spatial analysis problem.

Data Warehouse 108

Data Warehouse Visualization Cost-Benefit Optimization 108

AWS Big Data

MARCH 25, 2024

For example, in a chatbot, data events could pertain to an inventory of flights and hotels or price changes that are constantly ingested to a streaming storage engine. Furthermore, data events are filtered, enriched, and transformed to a consumable format using a stream processor.

Data Lake 90

Data Lake Unstructured Data Management Modeling 90

AWS Big Data

MARCH 20, 2024

As your organization becomes more data driven and uses data as a source of competitive advantage, you’ll want to run analytics on your data to better understand your core business drivers to grow sales, reduce costs, and optimize your business. ETL is the process data engineers use to combine data from different sources.

Data Warehouse 122

Data Warehouse Business Driver Data Lake Data-driven 122

IBM Big Data Hub

SEPTEMBER 19, 2023

Though you may encounter the terms “data science” and “data analytics” being used interchangeably in conversations or online, they refer to two distinctly different concepts. Meanwhile, data analytics is the act of examining datasets to extract value and find answers to specific questions.

Data Science 76

Data Science Data Analytics Prescriptive Analytics Analytics 76

Jet Global

NOVEMBER 21, 2023

To have any hope of generating value from growing data sets, enterprise organizations must turn to the latest technology. You’ve heard of data warehouses, and probable data lakes, but now, the data lakehouse is emerging as the new corporate buzzword. To address this, the data lakehouse was born.

Data Lake 52

Data Lake Data Warehouse Reporting Enterprise 52

AWS Big Data

DECEMBER 13, 2023

Traditionally, customers used batch-based approaches for data movement from operational systems to analytical systems. A batch-based approach can introduce latency in data movement and reduce the value of data for analytics. usually a data warehouse) needs to reflect those changes in near real-time.

Data Warehouse 98

Data Warehouse Snapshot Data Processing Management 98

AWS Big Data

AUGUST 16, 2023

Apache Iceberg is an open table format for very large analytic datasets. Iceberg manages large collections of files as tables, and it supports modern analytical data lake operations such as record-level insert, update, delete, and time travel queries. On the Code tab, choose Test , then Configure test event.

Data Lake 71

Data Lake Metadata Testing Snapshot 71

Ontotext

APRIL 10, 2024

“Any enterprise CEO really ought to be able to ask a question that involves connecting data across the organization, be able to run a company effectively, and especially to be able to respond to unexpected events. Most organizations are missing this ability to connect all the data together.”

Metadata 52

Metadata Data Lake Data Warehouse Data Quality 52

Andrew White

DECEMBER 9, 2019

This was a great inquiry since it called into question the perceived wisdom peddled by some that cataloging everything was a prerequisite for data (and analytics) governance. Modern data (and analytics) governance does not necessarily need: Wall-to-wall discovery of your data and metadata. Events or transactions.

Analytics 66

Analytics Data Lake Data Governance Metadata 66

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 84

Enterprise Data Warehouse Snapshot Cost-Benefit 84

AWS Big Data

FEBRUARY 1, 2023

With data volumes exhibiting a double-digit percentage growth rate year on year and the COVID pandemic disrupting global logistics in 2021, it became more critical to scale and generate near-real-time data. You can use it for analytics, ML, and application development. Then we chose Amazon Athena as our query service.

Optimization 52

Optimization Forecasting Data Lake Metadata 52

AWS Big Data

FEBRUARY 15, 2024

You might be modernizing your data architecture using Amazon Redshift to enable access to your data lake and data in your data warehouse, and are looking for a centralized and scalable way to define and manage the data access based on IdP identities. Select the data share and choose Authorize.

Management 89

Management Data Lake Sales Data Warehouse 89

AWS Big Data

NOVEMBER 29, 2023

You also need services to store data for analysis and machine learning (ML) like Amazon Simple Storage Service (Amazon S3). Customers have created hundreds of thousands of data lakes on Amazon S3. Now data analysts, scientists, and engineers can be more productive using generative AI text-to-code functionality.

Data Warehouse 109

Data Warehouse Data Lake Dashboards Data Integration 109

AWS Big Data

MARCH 26, 2024

In this post, we discuss how you can use purpose-built AWS services to create an end-to-end data strategy for C360 to unify and govern customer data that address these challenges. We recommend building your data strategy around five pillars of C360, as shown in the following figure.

Data Strategy 68

Data Strategy Strategy Data Warehouse Prescriptive Analytics 68

AWS Big Data

MAY 7, 2024

It also makes it easier for engineers, data scientists, product managers, analysts, and business users to access data throughout an organization to discover, use, and collaborate to derive data-driven insights. Note that a managed data asset is an asset for which Amazon DataZone can manage permissions.

Metadata 75

Metadata Data Lake Data Processing Data-driven 75