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

By An Bui   |   September 4, 2018

What is data management? Data management is a broad and ambiguous concept. The Global Data Management Community (DAMA International) defines it as “the development of ...

Data Management

12 Data Management Tools & 4 Ways of Thinking About Data Management

By An Bui   |   August 9, 2018

As a company formed by data engineers and analysts, we at Panoply love data in all its forms! But when you’re working with different types of data storage and processing ...

Data Warehousing

How to Tell the Difference between a Database and a Data Warehouse

By An Bui   |   July 26, 2018

According to Gartner, more than 50% of marketing organizations use a data management platform (DMP), either directly or through an agency partner, and a vast majority of ...

Data Stack

What to do When Data Management Platforms are not Enough

By An Bui   |   July 10, 2018

Data preparation, part of the data management process, involves collecting raw data from multiple sources and consolidating it into a file or database for analysis. Data ...

Data Stack

Top Data Preparation Tools for Your Business

By An Bui   |   July 5, 2018

Data as a Service (BDaaS) is a reality today. Increasing cloud usage, and new cloud services, mean you can set up data infrastructure that just works—without maintaining ...

Data Warehousing

Data Platform As A Service: IaaS, PaaS And SaaS

By An Bui   |   June 26, 2018

Data processing and analysis can’t happen without data profiling—reviewing source data for content and quality. As data gets bigger and infrastructure moves to the ...

Data Management

What is Data Profiling? Process, Best Practices, Top 6 Tools

By An Bui   |   June 19, 2018

When we say “big data”, many think of the Hadoop technology stack. Is this the big data stack?

Data Management

Big Data Stack in Big Data Analytics | Panoply Blog

By An Bui   |   June 12, 2018

Just ten years ago, even the most advanced analytics professionals only had to manage a handful of data sources. But data volume, velocity, and variety are now ...

Data Warehousing

Data Warehousing Concepts: Everything You Need to Know in 4 Minutes

By An Bui   |   May 16, 2018

Humans are visually motivated. When we see a movie, we’re drawn to the most beautiful and exotic settings, the most striking and recognizable actors, the biggest ...

Data Warehousing

Business Intelligence and Data Warehousing Meet: Magic Ensues

By An Bui   |   April 19, 2018

Both business and tech analysts agree that a capacity for advanced analytics is becoming mission-critical to the basic viability for all companies. While some believe ...

Being Data-Driven

Becoming an analytics driven organization: challenge accepted

By An Bui   |   April 11, 2018

Build vs. Buy—tale as old as time, song as old as…"I need that analysis yesterday!"

Analytics Leadership

Cloud Data Warehouse Costs: a Build vs. Buy Analysis

By An Bui   |   March 30, 2018

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far: Cassandra vs. MongoDB Redis vs. MongoDB ...

Databases

PostgreSQL vs. MongoDB

By An Bui   |   March 16, 2018

International Women's Day is a day when women are recognized for their achievements without regard to divisions, whether national, ethnic, linguistic, cultural, economic ...

Analytics Leadership

Women Who Kick @$$ in Data Analysis, Science and Engineering

By An Bui   |   March 8, 2018

ETL. It should be fairly straightforward, right? We extract data, transform it as needed, and load it into the target application. But like the recipe for the perfect ...

ETL/ELT

The Worst Advice We’ve Ever Heard About ETL

By An Bui   |   February 27, 2018

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

By An Bui   |   February 7, 2018

Your company sits on an immense treasure trove of data, but tapping this data and accessing its value can be a challenge.

Data Stack

Get Stacked: Designing a High Performance, High ROI Data Stack

By An Bui   |   January 30, 2018

As a member of the marketing team you already know that data is power. However, it’s not always easy to get, and even when you can get the data you need, it’s not always ...

Data Analysis

A Marketing Professional's Guide to Collecting Twitter Data

By An Bui   |   January 19, 2018

The data industry continues to impress with new tools being released every month. While we all love choices, the current data stack landscape can be overwhelming. We’re ...

Data Stack

Top Tools For A Dangerously Effective Data Stack

By An Bui   |   December 20, 2017

Data warehouses and data lakes are two different types of data storage repositories. Data warehouses integrate data from various sources and structures them for business ...

Data Warehousing

Key Differences Between a Data Warehouse and a Data Lake

By An Bui   |   November 21, 2017

The future of any successful enterprise will hinge on its ability to harness and use massive amounts of data currently available, to improve productivity, decrease ...

Data Warehousing

Database vs Data Warehouse - What's The Difference?

By An Bui   |   November 7, 2017