Tag: data warehouse

Feed: AWS Big Data Blog. Yelp connects people with great local businesses. Since its launch in 2004, Yelp has grown from offering services for just one city—its headquarters home of San Francisco—to a multinational presence spanning major metros across more than 30 countries. The company’s performance-based advertising and transactional business model led to revenues of more than $500 million during 2015, a 46% increase over the prior year. Yelp has evolved into a mobile-centric company, with more than 70% of searches, and more than 58% of content originating from mobile devices. Yelp uses Amazon Redshift to analyze mobile app usage ... Read More

Feed: Matillion. Author: Julie Polito; We’re thrilled to welcome back Holt Calder, Data Engineer at InterWorks, for another partner guest blog. Today, Holt talks about the four skills that every modern data team in 2020 must possess. For more tips on closing the data skills gap, download our latest ebook, Build a Modern Data Team. In the recent blog post, “The Case for Cloud-Based ELT in 2020,” InterWorks’ Data Practice Director Brian Bickell makes a great case for what we call “Modern Cloud Analytics,” a repeatable schematic that aims to kill the trend where analytics projects fail to deliver true ... Read More

Feed: Teradata Blog. Gaining Perspective on the True Cost of Pricing Models for Analytics I had a client years ago that was looking to add their International operations onto their existing data warehouse – which supported only the U.S. users at the time. They asked for an analysis on what it would take in terms of additional investment. Independently, the resources (and associated investment) would have been significant.  As I looked at the workload and usage patterns, however, it turned out that nearly the entire new set of users would be able to leverage the current system without additional investment ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: brad-miller; There are some people, like me, who like to know how the story ends and thus may occasionally read the last chapter before going back and reading the rest of the book. So, I guess this is a spoiler alert. The answer to the question is, “Netezza is still alive, well and evolving and IBM has now come out with the next generation of Netezza as part of Cloud Pak for Data System.”There were some decisions about two years ago which led me to believe that Netezza was ... Read More

Feed: Matillion. Author: Julie Polito; In this partner guest blog, Joe Caparula from Pandata Group explains how to manage Type 2 Slowly Changing Dimensions in Snowflake with the Detect Changes component.   Attributes in data warehouse dimension tables change over time, and you may want to retain the history of those changes as separate dimension records. This is known as a Type 2 Slowly Changing Dimension (SCD).  Changed records are not overwritten but rather flagged as “Inactive” with beginning and ending effective dates, while the updated values are inserted as new records.  Because each record still has a distinct key, ... Read More

Feed: AWS Big Data Blog. With IBM announcing Netezza reaching end-of-life, you’re faced with the prospect of having to migrate your data and workloads off your analytics appliance. For some, this presents an opportunity to transition to the cloud.Enter Amazon Redshift. Amazon Redshift is a cloud-native data warehouse platform built to handle workloads at scale, and it shares key similarities with Netezza that make it an excellent candidate to replace your on-premises appliance. You can migrate your data and applications to Amazon Redshift in less time and with fewer changes than migrating to other analytics platforms. For developers, this means ... Read More

Feed: Events. Author: . Organizations everywhere are calibrating against a new, challenging business landscape, and we want to help you reduce costs and solve for operational efficiency with cloud technology.  Please join our Solving Together Digital Conference (sessions starting today and available on demand) to hear best practices in navigating these challenges. Leaders are finding they need to make tough decisions about what projects to prioritize and how to allocate resources. Cloud technologies are playing an increasingly central role in supporting businesses as they focus on prioritization and operational efficiency.At Google Cloud, we’ve helped businesses of all sizes take advantage ... Read More

Feed: Actian. Author: Lewis Carr. In the first part of my blog on Real-Time Decision-Making (RTDM) highlighting Retail industry use cases, we discussed how combining existing historical data patterns with disparate new sources of data completes the Common Operational Picture (COP).  To illustrate the use-case, we used an Actian customer, Kiabi, and how they used RTDM strategic capabilities to enhance their customer loyalty program.In the second part, we explored how different roles and responsibilities can use the COP in business-as-usual scenarios versus periods of market disruption using another Actian Retail customer, LeRoy Merlin.  LeRoy Merlin wanted to extend their decision ... Read More

Feed: Matillion. Author: Julie Polito; This week, we’re excited to feature one of our partners, William M. Cohee of Greenwich Analytica, writing about how his team has been using Matillion Data Loader. This post originally appeared on LinkedIn. Thanks to Bill for allowing us to feature it here! In the digital economy businesses have new needs around data. According to a recent IDG Marketpulse survey, 99 percent of respondents said they are planning to shift data to the cloud by 2021. If you’re a company aspiring to compete on data and migrate it to the cloud, you need to become ... Read More

Feed: Redis Labs. Author: Haley Kim. (As organizations look to modernize their applications, many are turning to a microservices architecture to deconstruct their legacy apps into collections of loosely coupled services. This profound change inspired us to reach out to Redis users in various stages of this journey to microservices architectures. We are telling their microservices stories in a series of blog posts, which began in late 2019.) You’re on the way to the grocery store when your phone rings. It’s a number you don’t recognize. Do you pick up? If the idea of ignoring your phone—even for an unknown ... Read More