Category: Data Warehousing

At Panoply, we aim to be transparent with our customers and partners by frequently updating you on new features within the product that help you get your data faster. On top of these user-focused updates, our team is also continuously developing…

Continue reading New and Improved Data Engine Architecture

Google’s Universal Analytics (UA) will sunset on July 1st, and if you haven’t exported your historical UA data yet, it’s probably your top priority for June. You might have seen Google’s not-at-all ominous countdown for extra motivation:If you were hoping…

Continue reading Warehouse Your UA Data Without Missing a Beat

Everyone’s talking about the benefits of a single source of truth for business data. They say a centralized hub helps you reduce manual tasks, get clearer insights for better decision-making, and increase productivity. However:Don’t the businesses not looking for those benefits…

Continue reading Why Shouldn’t You Have a Single Source of Truth?

As a data analyst helping navigate my company through these choppy economic waters, I understand the conflicting needs of providing actionable insights while keeping costs low. Luckily, with the expanding array of open-source data analytics tools, you can provide the…

Continue reading Best Open-Source Data Analytics Tools and Software

Optimizing your SQL code is an important part of maintaining the performance and efficiency of your data pipeline. There are essentially no hard limits on the logical complexity of a single SQL query, plus, most modern database solutions allow a…

Continue reading SQL Optimization Benefits and Techniques

Modern businesses create, collect, analyze, and store vast amounts of data on metrics that impact their operations and decision-making. The amount is forecasted to grow to even more monumental proportions in the near future. With data workflows becoming more critical…

Continue reading How Data Observability Can Help Your Bottom Line

You know Python and SQL and Java and VixenCaching and Lakehouse and Pipeline and BlitzenBut do you recallThe most famous reindeer of all?🎄Rudolph the Data ReindeerReally makes your data flowAnd if you ever met himYou’d thank him for those perfect…

Continue reading Rudolph the Data Reindeer

Overseeing a fast-moving, dynamic marketing department is no easy task. Chief marketing officers (CMOs) need to juggle a variety of responsibilities while making sure the department stays on track to meet its quarterly and annual goals.  This process is infinitely easier…

Continue reading Why You Need a CMO Dashboard and What to Put on It

If you’re looking for a great metric to track user engagement and growth on your platform, you might want to measure your daily active users (DAU). But keep in mind that while DAU is a good starting point, it’s not…

Continue reading How to Calculate Daily Active Users (DAU) and Why It Matters

In the past, Panoply users didn’t have visibility into their usage compared to their tier’s quota, and couldn’t track their queries and monthly usage. They could see rows scanned and extracted, storage, and query bytes, but there was no way…

Continue reading Usage Reports: Get the Data on Your Data

If it seems like data and analytics companies can’t stop talking about a “single source of truth,” well… you’re right. Single source of truth (SSOT) has emerged as a practice businesses simply can’t go without. It’s a necessity for data…

Continue reading Data Bytes: Everyone Needs a Single Source of Truth

In Panoply’s Data Bytes mini videos, we’ll chat with our experts and explore topics relevant to the industry, to us, and especially to you. The first episode coincided with the six-month anniversary of SQream acquiring Panoply, so we spoke to SQream…

Continue reading Data Bytes Episode 1: After the Acquisition