Latest Stories

The ETL approach has been the traditional approach for data warehousing and analytics. ELT is the new kid on the block. Beyond the differences between ETL vs ELT, how ...
Data Warehousing

Improving And Shortening The ETL Process With ELT

Simply defined, a data warehouse is a system that pulls together data from many different sources within an organization. On top of this system, business users can ...
Data Warehousing

The Many Use-Cases Of A Data Warehouse

There is a misconception that you only need a data warehouse if you have huge amounts of data. This just isn’t true. Businesses of all sizes can benefit greatly from ...
Data Warehouse

How To Successfully Implement A Data Warehouse

I recently sat down with Aron Clymer to talk about his approach to architecting and building data stacks. Aron has built data analytics stacks and developed analytics ...
Data Stack

When It's Time To Build An Analytics Stack

The PostgreSQL database serves two roles in the Tableau ecosystem:

Tableau And PostgreSQL: Two Ways Of Working Together

Almost across the board, businesses are asking themselves. “How are we going to grow our business to the next stage?” No matter what industry you are in, using your ...
Being Data Driven

5 Opportunities To Scale Your Business With Data

Data has become the lifeblood of the business. To understand and utilize all this data, data warehouses have become an essential part of modern business. Today, we ...
Data Warehousing

Redshift Vs Snowflake: The Full Comparison

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 Analytics

How To Avoid Fallacies In Data

Today we’re proud to announce a new feature that will enable teamwork within your organization. At Panoply, we believe in teamwork. When teams collaborate with one ...

Announcing The New Teams Functionality

Data mining is the process of deriving business insights from large or complex data sets, while data warehouses are typically the storage and processing infrastructure ...
Data Warehouse

How Your Data Warehouse Can Make Data Mining Easier And More Efficient

Data. It’s the word that that results in billion dollar valuations, that drives industries, that creates new revenue streams, and that has introduced a “New Economy” ...
Data Industry And Trends

Why ETL Software And Data Warehousing Are Foundational To Modern Analytics

In a world where data continues to grow, working with this critical business asset has become even more important. In fact, IDC estimates that by 2025, nearly 20% of the ...
Data Visualization

Data Visualization 101: Understanding The Power Of Data And Dashboards

At Panoply, we're lucky to have some really smart customers using our data warehouse. Because they're so smart, we want to share their knowledge with you!

Join Us On Oct 4 For Winning With Data Webinar

Massive upgrade to Panoply’s query optimization - prepare to be blown away by lightning fast query results As a data analyst, you’re all too familiar with how long ...

Query 100x Faster With Automated Query Materialization

So you’ve heard of a data warehouse, but now what? Do I need one? How can a data warehouse work for me and my business? We’ll look into the basics of a data warehouse, ...
Data Industry And Trends

What Is A Data Warehouse? A Tutorial For Beginners

With data flowing in from all directions, how are businesses to make sense of all of this information, let alone make meaningful decisions? This is where a having the ...
Data Industry And Trends

How To Pick The Right BI Tool For Your Business

Rolls Royce is synonymous with power, reliability and dependability. What many may be surprised about, is that the engine manufacturer that powers some of the world’s ...
Data Analytics

5 Essential ETL Tools Data Analysts Can't Live Without

Saucey is a convenient alcohol delivery app developed by three friends over lunch. The founders wondered why there was delivery available for everything - groceries, ...
Customer Stories

How Data Powers Saucey's Business From The Inside Out

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

Before we get into the power of data, it’s important to understand just how much data we’re creating. A recent report from Cisco indicates that globally, the data stored ...
Big Data

Don’t Let Data Collect Digital Dust: Leverage The Power Of Information To Create Competitive Advantages

We’re really beginning to experience another industrial revolution. That is, we’re actively entering into the ‘Age of Data.’ As you look at your own life, business, and ...
Big Data

Defining The Data Warehouse: Applications In The Real World

Today's customer spotlight highlights Resuelve, a Mexican consumer credit agency. There, the engineering and data team, led by José Akle, is using data science to model ...
Big Data

Powered By Data, Resuelve Is Inventively Qualifying Leads Using Panoply

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 Architecture

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

PowerBI With MySQL: Challenges And Alternatives

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