9 Steps for Creating an Effective Data Integration Strategy in 2024 Today's businesses depend on data, but more than that, they need to get the right data to the right ...

Being Data-Driven

9 Steps for Creating an Effective Data Integration Strategy in 2024 - Panoply

By Allison Foster on August 12, 2024

Poorly designed databases can cause many problems, including a waste of resources, difficult maintenance, and faulty performance. That's why having a great database ...

Best Practices

Database Schema Design Examples

By Carlos Schults on August 5, 2024

The Power of Data: How SMBs Can Thrive by Leveraging Data as an Asset While data used to be a byproduct of doing business, it’s become a valuable asset that can ...

Being Data-Driven

The Power of Data: How SMBs Can Thrive by Leveraging Data as an Asset

By Allison Foster on May 20, 2024

Demystifying Cloud-Based Data Warehouses: Benefits and Considerations

Being Data-Driven

Demystifying Cloud-Based Data Warehouses: Benefits and Considerations

By Allison Foster on November 23, 2023

As Google transitions from Universal Analytics (UA) to Google Analytics 4 (GA4) on July 1, data ownership becomes a top concern for anyone using their platform. While ...

Data Management

The Importance of Data Ownership

By Ryan Hsu on June 6, 2023

Moving your business from disparate data sources and ad hoc reporting to a single source of truth data warehouse solution is a sign of growth in the right direction.

Being Data-Driven

10 Questions to Help Define a Successful Data Warehouse Strategy

By Taurai Mutimutema on June 13, 2022

One of the significant challenges in handling data comes from the massive amount of data your organization is most likely generating constantly. Having the ability to ...

Data Warehousing

Data Warehouse Design: The Good, the Bad, the Ugly

By Daniel Paes on November 17, 2021

Designing and creating a data dictionary for your company is a big process with big returns. It's something you need to do if you want deep insights from your data and ...

Best Practices

7 Best Practices for Building a Data Dictionary

By Adam Murphy on August 6, 2021

Query Bytes’ are a unit of measure to track the compute power used when working with data. At Panoply, they also happen to be the main differentiator between our ...

Panoply News

What are Panoply Query Bytes?

By Brett Evans on June 15, 2021

It took a bunch of work, but you finally found the right consultant for your project and worked out a contract you're both happy with. Now you can relax and let them do ...

Working in Data

How to Manage a Data Consultant

By Anders Schneiderman on March 16, 2021

If you're a CEO or in leadership, you're often going to be faced with the question of what to do when your company’s data needs outstrip what your IT department, ...

Being Data-Driven

When to Hire a Data Consultant vs. Building Out Your Data Team

By Anders Schneiderman on March 2, 2021

You know the janky data solution your startup currently has in place just isn't cutting it. But when you think about building what you need, you get a pit in your ...

Being Data-Driven

How to Create a Data MVP for Your Startup

By Anders Schneiderman on February 16, 2021

There's no cookie-cutter way to choose metrics that will work for all startups. In fact, what the history shows us is that everybody who's tried to come up with a better ...

Being Data-Driven

How to Coach Your Startup to Choose Better Metrics

By Anders Schneiderman on December 21, 2020

As an analyst, you probably spend a lot of your time creating dashboards and other reports to help your teams and Top Brass track metrics. And you probably spend at ...

Being Data-Driven

KPIs, OKRs, OMTM: The History of Modern Metrics & Why It Matters for Analysts

By Anders Schneiderman on December 17, 2020

You know the drill: Sometime in mid-December, a tsunami of planning will crash into your company as teams frantically scramble to figure out their initiatives and KPIs ...

Being Data-Driven

How to Use Dashboards to Guide Your Startup's 2021 Planning

By Anders Schneiderman on December 10, 2020

You nailed your proof of concept project. Your initial group of users are happy, and they’re getting comfortable mining the first batch of data for insights that may ...

Best Practices

Deepening Your Approach to Data

By Anders Schneiderman on November 17, 2020

Trying to transform your business into a data-driven powerhouse can feel overwhelming. Even if you've got amazing self-service tools, helping your team become ...

Best Practices

Why and How to Assemble Data-Loving Allies

By Anders Schneiderman on October 21, 2020

In an ideal world, when you create an amazing plan to build a world-class data stack, your coworkers' minds would be blown, your company's CEO would thank you for your ...

Best Practices

How to Get High-Level Buy-In for Your Data Warehouse Project

By Anders Schneiderman on October 6, 2020

The first iteration of your shiny new data warehouse is up and running, and folks are loving it. For example, Marketing is thrilled at how easy it is to pull up the data ...

Best Practices

What Is a Single Source of Truth (SSOT) and Why Do You Need One?

By Anders Schneiderman on September 22, 2020

“It’s the most wonderful time of the year,” sang Andy Williams about the Christmas season, but a “wonderful time” might not be how analysts working in e-commerce and ...

Being Data-Driven

How Ecommerce Analysts Can Prep for the Holiday Season

By Andrew Pearson on September 8, 2020

You've spent a bunch of time figuring out the best data stack for your company. It was hard work, and occasionally it was frustrating, but mostly it was fun.

Data Stack

How to Propose a Data Stack

By Anders Schneiderman on September 3, 2020

There’s nothing more aggravating for a data analyst than sweating over a great analysis or dashboard only to have it go unused.

Best Practices

Why Data Analysts Should Adopt a Product Mindset

By Anders Schneiderman on August 18, 2020

Every week, analysts around the globe are working hard to create data warehouses.

Best Practices

Analyzing Business Needs: The First Step in Your Data Warehouse Project

By Anders Schneiderman on July 27, 2020

Implementing modern data management best practices can optimize voluminous amounts of disparate data. This facilitates insights by embracing full transparency across ...

Best Practices

Data Management Strategy and Best Practices in the Cloud

By Phillip Tanzer on April 3, 2019

It’s easy to sometimes forget just how much data we’re creating each day. We’re generating data when we work, when we’re at home, and in many cases, as we simply go ...

Best Practices

Data Governance Strategy – A Practical Approach

By Bill Kleyman on February 2, 2019