Latest Stories

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 ...
Data Collection

Less GIGO, More KNOW: Do's And Don't's In Data Collection And Distribution

What is data architecture? Data architecture defines information flows in an organization, and how they are controlled. A data architect is responsible for understanding ...
Data Engineering

Data Architecture:  People, Process And Technology

Microsoft PowerBI integrates with MySQL out of the box. However, loading data into PowerBI to create MySQL visualizations is not straightforward—especially if MySQL is ...
BI And Data Visualization

PowerBI With MySQL: Challenges And Alternatives

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

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

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 Management

What To Do When Data Management Platforms Are Not Enough

What is data preparation? Data preparation, part of the data management process, involves collecting raw data from multiple sources and consolidating it into a file or ...
Data Management

5 Data Preparation Tools & 1 Automated Data Platform

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

Big Data As A Service: IaaS, PaaS And SaaS

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

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

The Big Data Stack: Powering Data Lakes, Data Warehouses And Beyond

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 ...
Data Engineering

MySQL Vs Oracle

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

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 ...
Analytics Leadership

10 Questions To Help Define A Successful Data Warehouse Strategy

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 ...
Postgres

PostgreSQL Vs. MySQL

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

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 ...
Analytics Leadership

Becoming An Analytics Driven Organization: Challenge Accepted

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

Build Vs. Buy Analysis: How Much Will That Cloud Data Warehouse Cost?

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 ...
Postgres

PostgreSQL Vs. MongoDB

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

Women Who Kick @$$ In Data Analysis, Science And Engineering

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 ...
Data Engineering

The Worst Advice We’ve Ever Heard About ETL

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.” ...
Data Stack

10 Minutes To A High-Performance Big Data Stack. Really.

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. ...
Analytics Leadership

9 Things Your Boss Wants To Know About Data Warehousing

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 ...
MongoDB

DynamoDB Vs. MongoDB

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 ...
Data Stack

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

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