Is ETL dead? What is the difference between ETL vs ELT? Did ELT take over or is something new taking its place? It’s a question that has come up a lot in recent years as organizations modernize their analytics infrastructure. Huge shifts are underfoot in the analytics landscape and it isn’t always clear where this […]
More Will Davis • December 21, 2020 Picture this scenario: a group of health insurance analysts want to understand the variation in cost of a medical procedure. However, the data they receive from partnering hospitals is stored in different systems throughout the organization and its accompanying metadata doesn’t match up, making it nearly impossible for users to understand the context of the […]
More Will Davis • October 25, 2020 If you are wondering how to format cells in excel, you have came to the right place. Small formatting adjustments can make all the difference to a Microsoft Excel workbook. A small pop of color here, a change of font there, and suddenly, your workbook is no longer just a sea of rows and columns, […]
More Will Davis • October 24, 2020 What is a Master Data Management Strategy? Master data management strategy (MDM) refers to the governing procedures for entering, aggregating, consolidating, de-duping, standardizing, and maintaining data en masse throughout an organization. By ensuring control and reliability, MDM creates a single source of master data that can be applied and maintained by many different entities throughout […]
More Will Davis • October 18, 2020 The appeal of being a data analyst or data scientist does not come from cleaning messy data. And yet, it’s the activity that often ends up consuming the majority of their total analytic time—on average, 80 percent of it—while just 20 percent is dedicated to visualizing and analyzing data, creating machine learning models, or other […]
More Will Davis • September 22, 2020 This is the fourth post in an ongoing series about how marketers are leveraging Designer Cloud. It follows previous posts on marketing data onboarding, marketing analytics, and building a 360º view of the customer experience. What is marketing analytics‘ opportunity and challenge in the modern business landscape? Some marketers might say that it’s digital ads. […]
More Will Davis • June 18, 2020