article thumbnail

How Novanta’s CIO mobilized its data-driven transformation

CIO Business Intelligence

When I joined, there was a lot of silo data everywhere throughout the organization, and everyone was doing their own reporting. It was also a lot of churning for the different groups to come up with those data on the weekly, monthly and quarterly basis.” But where to begin? “We That’s the first level of a cultural shift.

article thumbnail

Data Modeling 201 for the cloud: designing databases for data warehouses

erwin

Designing databases for data warehouses or data marts is intrinsically much different than designing for traditional OLTP systems. Accordingly, data modelers must embrace some new tricks when designing data warehouses and data marts. Data modeling for the cloud: good database design means “right size” and savings.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Orca Security’s journey to a petabyte-scale data lake with Apache Iceberg and AWS Analytics

AWS Big Data

With data becoming the driving force behind many industries today, having a modern data architecture is pivotal for organizations to be successful. In this post, we describe Orca’s journey building a transactional data lake using Amazon Simple Storage Service (Amazon S3), Apache Iceberg, and AWS Analytics.

article thumbnail

How Aura from Unity revolutionized their big data pipeline with Amazon Redshift Serverless

AWS Big Data

Amazon Redshift is a recommended service for online analytical processing (OLAP) workloads such as cloud data warehouses, data marts, and other analytical data stores. You can use simple SQL to analyze structured and semi-structured data, operational databases, and data lakes to deliver the best price/performance at any scale.