David Menninger's Analyst Perspectives

MARCH 17, 2022

Organizations face various challenges with analytics and business intelligence processes, including data curation and modeling across disparate sources and data warehouses, maintaining data quality and ensuring security and governance.

Business Intelligence 204

Business Intelligence Data Warehouse Data Quality Dashboards 204

AWS Big Data

DECEMBER 19, 2023

Sun King is driven by data for analyzing areas of growth across thousands of miles using a dashboards that are powered by Amazon Redshift. In this post, we share how Sun King uses Amazon Redshift and Redshift’s features like Data Sharing capabilities to improve the performance of queries in Looker for over 1,000 of our staff.

Data Analytics 62

Data Analytics Analytics Data Warehouse Data-driven 62

AWS Big Data

MARCH 27, 2024

You can send data from your streaming source to this resource for ingesting the data into a Redshift data warehouse. This will be your online transaction processing (OLTP) data store for transactional data. With continuous innovations added to Amazon Redshift, it is now more than just a data warehouse.

Data Analytics 87

Data Analytics Analytics Data Warehouse Data Lake 87

AWS Big Data

FEBRUARY 1, 2024

This stack creates the following resources and necessary permissions to integrate the services: Data stream – With Amazon Kinesis Data Streams , you can send data from your streaming source to a data stream to ingest the data into a Redshift data warehouse. version cluster. version cluster.

Data Warehouse 119

Data Warehouse Dashboards Risk Management Risk 119

AWS Big Data

OCTOBER 26, 2023

times better price-performance than other cloud data warehouses on real-world workloads using advanced techniques like concurrency scaling to support hundreds of concurrent users, enhanced string encoding for faster query performance, and Amazon Redshift Serverless performance enhancements. Amazon Redshift delivers up to 4.9

Data Warehouse 91

Data Warehouse Cost-Benefit Dashboards Optimization 91

AWS Big Data

JUNE 29, 2023

Amazon Kinesis Data Analytics makes it easy to transform and analyze streaming data in real time. 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.

Data Analytics 71

Data Analytics Analytics IoT Data Lake 71

Sisense

AUGUST 4, 2021

Infusing intelligence everywhere is where Sisense shines, which is why in Q2 we’ve invested in bringing you Infusion Apps that leverage our brand new Extense Framework along with other features that allow you to explore new dimensions of your data. Analytics adoption has stalled; only infused analytics can help. Learn more.

Dashboards 52

Dashboards Analytics Data Warehouse Forecasting 52

AWS Big Data

APRIL 10, 2024

and zero-ETL support) as the source, and a Redshift data warehouse as the target. The integration replicates data from the source database into the target data warehouse. Additionally, you can choose the capacity, to limit the compute resources of the data warehouse. For this post, set this to 8 RPUs.

Data Warehouse 88

Data Warehouse Analytics Metrics Snapshot 88

AWS Big Data

DECEMBER 5, 2023

HR&A has used Amazon Redshift Serverless and CARTO to process survey findings more efficiently and create custom interactive dashboards to facilitate understanding of the results. The following are sample screenshots of the dashboards that show survey responses by zip code.

Measurement 79

Measurement Dashboards Data Warehouse Analytics 79

Jedox

OCTOBER 22, 2020

The term “data analytics” refers to the process of examining datasets to draw conclusions about the information they contain. Data analysis techniques enhance the ability to take raw data and uncover patterns to extract valuable insights from it. Data analytics is not new. Self-service reporting.

Data Analytics 69

Data Analytics Analytics Unstructured Data Data mining 69

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 88

Data Warehouse Data Lake Analytics Data Science 88

Cloudera

JULY 21, 2022

Cloudera users can securely connect Rill to a source of event stream data, such as Cloudera DataFlow , model data into Rill’s cloud-based Druid service, and share live operational dashboards within minutes via Rill’s interactive metrics dashboard or any connected BI solution. Cloudera Data Warehouse).

Metrics 84

Metrics Slice and Dice Data Warehouse Dashboards 84

AWS Big Data

NOVEMBER 28, 2023

To run analytics on their operational data, customers often build solutions that are a combination of a database, a data warehouse, and an extract, transform, and load (ETL) pipeline. ETL is the process data engineers use to combine data from different sources.

Data Warehouse 89

Data Warehouse Data-driven Machine Learning B2B 89

AWS Big Data

OCTOBER 18, 2023

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that provides the flexibility to use provisioned or serverless compute for your analytical workloads. Modern analytics is much wider than SQL-based data warehousing. Fault tolerance is built in. Any hardware failures are automatically replaced.

Analytics 92

Analytics Data Warehouse Testing Dashboards 92

AWS Big Data

JUNE 28, 2023

There are two broad approaches to analyzing operational data for these use cases: Analyze the data in-place in the operational database (e.g. With Aurora zero-ETL integration with Amazon Redshift, the integration replicates data from the source database into the target data warehouse.

Data Warehouse 81

Data Warehouse Analytics Metrics Dashboards 81

DataKitchen

AUGUST 27, 2021

Marketing invests heavily in multi-level campaigns, primarily driven by data analytics. This analytics function is so crucial to product success that the data team often reports directly into sales and marketing. The Otezla team built a system with tens of thousands of automated tests checking data and analytics quality.

Analytics 246

Analytics Sales Testing Cost-Benefit 246

AWS Big Data

DECEMBER 21, 2023

As the volume and complexity of analytics workloads continue to grow, customers are looking for more efficient and cost-effective ways to ingest and analyse data. OpenSearch Service is used for multiple purposes, such as observability, search analytics, consolidation, cost savings, compliance, and integration.

Analytics 92

Analytics IT Data Lake Visualization 92

AWS Big Data

DECEMBER 8, 2023

More and more of FanDuel’s community of analysts and business users looked for comprehensive data solutions that centralized the data across the various arms of their business. Their individual, product-specific, and often on-premises data warehouses soon became obsolete.

Data Warehouse 66

Data Warehouse Cost-Benefit KPI Risk 66

datapine

SEPTEMBER 27, 2022

Business leaders, developers, data heads, and tech enthusiasts – it’s time to make some room on your business intelligence bookshelf because once again, datapine has new books for you to add. We have already given you our top data visualization books , top business intelligence books , and best data analytics books.

Business Intelligence 292

Business Intelligence Data Warehouse Data Processing Data mining 292

AWS Big Data

MARCH 26, 2024

The AWS modern data architecture shows a way to build a purpose-built, secure, and scalable data platform in the cloud. Learn from this to build querying capabilities across your data lake and the data warehouse. The following diagram shows a sample C360 dashboard built on Amazon QuickSight.

Data Strategy 66

Data Strategy Strategy Data Warehouse Prescriptive Analytics 66

DataKitchen

JANUARY 3, 2022

A DataOps process hub offers a way for business analytics teams to cope with fast-paced requirements without expanding staff or sacrificing quality. Analytics Hub and Spoke. The data analytics function in large enterprises is generally distributed across departments and roles. Business Analytic Challenges.

Business Analytics 245

Business Analytics Analytics Testing Dashboards 245

AWS Big Data

FEBRUARY 22, 2023

The data lake implemented by Ruparupa uses Amazon S3 as the storage platform, AWS Database Migration Service (AWS DMS) as the ingestion tool, AWS Glue as the ETL (extract, transform, and load) tool, and QuickSight for analytic dashboards. The audience of these few reports was limited—a maximum of 20 people from management.

Data Lake 52

Data Lake Dashboards Cost-Benefit Metadata 52

AWS Big Data

MAY 17, 2023

During that same time, AWS has been focused on helping customers manage their ever-growing volumes of data with tools like Amazon Redshift , the first fully managed, petabyte-scale cloud data warehouse. One group performed extract, transform, and load (ETL) operations to take raw data and make it available for analysis.

Data Warehouse 108

Data Warehouse Cost-Benefit Sales Data-driven 108

AWS Big Data

NOVEMBER 9, 2023

It allows users to write data transformation code, run it, and test the output, all within the framework it provides. Use case The Enterprise Data Analytics group of a large jewelry retailer embarked on their cloud journey with AWS in 2021. Create boto3 client for Glue glue_client = boto3.client('glue',

Data Warehouse 100

Data Warehouse Testing Data Quality Reporting 100

datapine

MAY 21, 2019

“BI is about providing the right data at the right time to the right people so that they can take the right decisions” – Nic Smith. Data analytics isn’t just for the Big Guys anymore; it’s accessible to ventures, organizations, and businesses of all shapes, sizes, and sectors.

Business Intelligence 183

Business Intelligence Cost-Benefit Dashboards Slice and Dice 183

Smart Data Collective

APRIL 29, 2020

The extraction of raw data, transforming to a suitable format for business needs, and loading into a data warehouse. Data transformation. This process helps to transform raw data into clean data that can be analysed and aggregated. Data analytics and visualisation. Reference data management.

Management 84

Management Data Warehouse Digital Transformation Dashboards 84

AWS Big Data

JULY 12, 2023

Introduction to Amazon Redshift Amazon Redshift is a fast, fully-managed, self-learning, self-tuning, petabyte-scale, ANSI-SQL compatible, and secure cloud data warehouse. Thousands of customers use Amazon Redshift to analyze exabytes of data and run complex analytical queries.

Data Warehouse 52

Data Warehouse Modeling Dashboards Data Lake 52

Smarten

MAY 30, 2023

You will achieve seamless integration of Augmented Analytics and Business Intelligence Objects with easy to use, scalable integration APIs. Integrate objects (Dashboards, Crosstab, Tabular, KPIs, Graphs, Reports, models, Clickless Analytics and more).’

Slice and Dice 52

Slice and Dice Business Intelligence Cost-Benefit Dashboards 52

AWS Big Data

FEBRUARY 21, 2023

Data warehouses play a vital role in healthcare decision-making and serve as a repository of historical data. A healthcare data warehouse can be a single source of truth for clinical quality control systems. What is a dimensional data model? What is a dimensional data model? What is a data vault?

Data Warehouse 63

Data Warehouse Data Lake Cost-Benefit Modeling 63

CDW Research Hub

JANUARY 21, 2021

At Sirius, we’re piloting a modern analytic solution using Snowflake’s scalable cloud data warehouse in combination with ThoughtSpot through its Partner Connect service offering. Eliminate the need to move data by running queries directly in Snowflake to give you the most up-to-date answers. Light data modeling.

Data Warehouse 52

Data Warehouse Dashboards Structured Data Predictive Analytics 52

CIO Business Intelligence

SEPTEMBER 14, 2023

They’re often responsible for building algorithms for accessing raw data, too, but to do this, they need to understand a company’s or client’s objectives, as aligning data strategies with business goals is important, especially when large and complex datasets and databases are involved.

Analytics 134

Analytics Data Science Unstructured Data Data mining 134

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. No one seems to care.

Testing 157

Testing Dashboards Measurement Experimentation 157

FineReport

DECEMBER 27, 2021

Dashboards and visualizations are the primary user interfaces of many tools and platforms. Enterprise BI typically functions by combining enterprise data warehouse and enterprise license to a BI platform or toolset that business users in various roles can use. Enterprise BI dashboard by FineReport. Enterprise BI solution.

Enterprise 59

Enterprise Dashboards Business Intelligence Visualization 59

AWS Big Data

JULY 13, 2023

In particular, they wanted to enable their account managers, sales executives, and analysts to use actual data and facts to get a 360 view of their accounts. Target – Dashboards to be refreshed on a daily basis that would provide insights on sales, gross profit, sales pipelines, and customers.

Optimization 87

Optimization B2B Data Quality Sales 87

datapine

JANUARY 24, 2021

If nothing can be changed, there is no point of analyzing data. But if you find a development opportunity, and see that your business performance can be significantly improved, then a KPI dashboard software could be a smart investment to monitor your key performance indicators and provide a transparent overview of your company’s data.

IT 317

IT Statistics KPI Data-driven 317

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 109

Analytics IoT Data-driven Snapshot 109

AWS Big Data

JUNE 6, 2023

In this post, we highlight the seamless integration of Amazon Athena and Amazon QuickSight , which enables the visualization of operational metrics for AWS Glue Data Quality rule evaluation in an efficient and effective manner. The crawler builds a Data Catalog, so the data can be queried using Athena. Choose Visualize.

Data Quality 68

Data Quality Metrics Visualization Dashboards 68