Panoply.io - A blog about data management and data infrastructure

Technical insights and creative ideas about data management, data infrastructure, and data analysis.

Subscribe to our emails and get Panoply updates on the fly.

An Bui

Recent Posts

Data Analysis and Visualization Data Management

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

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 cloud, data profiling is....

[+]
Written by An Bui |June 19, 2018

Data Management

The Big Data Stack: Powering data lakes, data warehouses and beyond

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

[+]
Written by An Bui |June 12, 2018

Being Data Driven

Big Data Management: 5 Key Points to Remember

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 the “datafication” of the....

[+]
Written by An Bui |May 29, 2018

Data Technology

MySQL vs Oracle

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

[+]
Written by An Bui |May 22, 2018

From raw data to analysis in under 10 minutes.

Sign up now for a demo or a free trail of the Panoply.io platform.

Learn more about platform features

Being Data Driven

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

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 increasing exponentially. In 2016,....

[+]
Written by An Bui |May 16, 2018

Being Data Driven

10 Questions to Help Define a Successful Data Warehouse Strategy

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 to put it in place. Bottom....

[+]
Written by An Bui |May 10, 2018

Data Technology

PostgreSQL vs. MySQL

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far: [+]
Written by An Bui |April 25, 2018

Being Data Driven Data Technology

Business Intelligence and Data Warehousing Meet: Magic Ensues

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 explosions. What we don’t spend a....

[+]
Written by An Bui |April 19, 2018

Being Data Driven

Becoming an analytics driven organization: challenge accepted

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 that we are only three to....

[+]
Written by An Bui |April 11, 2018

Being Data Driven

Build vs. Buy Analysis: how much will that cloud data warehouse cost?

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

[+]
Written by An Bui |March 30, 2018

Data Technology

PostgreSQL vs. MongoDB

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far: [+]
Written by An Bui |March 16, 2018

Data Industry and Trends Being Data Driven

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

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

As we....

[+]
Written by An Bui |March 07, 2018

Being Data Driven

The Worst Advice We’ve Ever Heard About ETL

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 Bloody Mary or the ideal....

[+]
Written by An Bui |February 27, 2018

10 Minutes to a High-Performance Big Data Stack. Really.

Nearly everyone in the IT world has heard the quote from Facebook’s Mark Zuckerberg about the need for speed and performance in technology—“Move fast, break things.” While that might apply to....

[+]
Written by An Bui |February 22, 2018

Being Data Driven

9 Things Your Boss Wants to Know About Data Warehousing

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. While it’s cute when your....

[+]
Written by An Bui |February 07, 2018

Data Technology

DynamoDB vs. MongoDB

This series of posts analyzes how specific NoSQL databases stack up against one of the most popular NoSQL databases, MongoDB. We've covered the following comparisons so far:

[+]
Written by An Bui |February 01, 2018

Being Data Driven

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

Your company sits on an immense treasure trove of data, but tapping this data and accessing its value is a challenge. As your company grew or new software solutions became available, your business....

[+]
Written by An Bui |January 30, 2018

Being Data Driven

A Marketing Professional's Guide to Collecting Twitter Data

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 easy to understand,....

[+]
Written by An Bui |January 19, 2018

Data Industry and Trends Data Technology

10 Critical ETL and Data Storage Posts You Need for 2018

2017 has come to an end, and as you're gearing up for a successful 2018, you might find a cheat sheet of essential ETL tools and data storage comparisions handy. This list provides commentary to....

[+]
Written by An Bui |January 05, 2018

Data Technology

Top 10 Tools for a Dangerously Effective Data Stack in 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 here to help separate the....

[+]
Written by An Bui |December 19, 2017

Being Data Driven Data Technology

Enterprise Data Warehousing vs Data Virtualization: The Battle

Data analytics allows organizations to gain insight into their business operations and find new ways to increase their revenue. However, the data sources used to provide these insights are often....

[+]
Written by An Bui |December 12, 2017

Data Industry and Trends

Three Data Warehousing Trends From AWS re:Invent 2017

ed. note: The latest data warehouse trends report is now available. Download it today.

Download Data Warehouse Trends Report 2018 

re:Invent, Amazon Web Services' yearly....

[+]
Written by An Bui |December 07, 2017

Data Technology

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

Good Business Intelligence (BI), allows your organization to query data obtained from trusted sources and use the answers to gain a competitive edge in your industry. The first step to achieving....

[+]
Written by An Bui |November 28, 2017

Being Data Driven Data Technology

Data Warehouse or Data Lake: How to Select the Right Solution

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 reporting. Data lakes....

[+]
Written by An Bui |November 21, 2017

Data Technology

Database vs Data Warehouse - What's The Difference?

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 costs, and increase profits. How....

[+]
Written by An Bui |November 07, 2017

Data Industry and Trends

Top Tweets from Tableau Conference, #Data17

TL;DR -- whether you were there or not, these interesting tweets provide food for thought until #Data18.

[+]
Written by An Bui |October 23, 2017