Latest Stories In: Panoply Blog - Data Management, Data Warehousing, And Data Analysis. | Best Practices

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

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

‘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?

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

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

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

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

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

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

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

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

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

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

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?

“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 ecommerce and ...
Being Data Driven

How Ecommerce Analysts Can Prep for the Holiday Season

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

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

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

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

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

You’ve done the hard work. You’ve now gotten to the point of data visualization, but can you trust your results? We’ll look at some tips and strategies on how to avoid ...
Data Analysis

How to Avoid Fallacies in Data

Anybody who hangs out in IT or data science circles will invariably become familiar with the acronym GIGO. GIGO stands for “garbage in, garbage out” (or “good in, good ...
Best Practices

Less GIGO, more KNOW: Do's and Don't's in Data Collection and Distribution

The idea is pretty simple: the more you have of something, the more challenging it is to manage. This absolutely holds true when it comes to data. Today, we’re seeing ...
Best Practices

Big Data Management: 5 Key Points to Remember

When defining your data warehouse strategy—or moving from on-premise to cloud—you’ve got lots of options. But your data warehouse is only as good as the strategy you use ...
Being Data Driven

10 Questions to Help Define a Successful Data Warehouse Strategy

As an analyst who deals with data from many data sources daily, you might find yourself as the go-to source for information about business intelligence in your office. ...
Data Warehousing

9 Things Your Boss Wants to Know About Data Warehousing

Work smarter, better, and faster with monthly tips and how-tos.