Welcome back, data folk, to our 3-part series on managing and analyzing data with SQL, Python and pandas. In our first post, we went into the differences, similarities, ...

Data Analysis

How to read a SQL query into a pandas dataframe

By Peter Weinberg   |   January 5, 2021

Finding the right ETL tool for your business is essential. ETL pulls data out of a source (extract), makes changes according to requirements (transform), and then pushes ...

ETL/ELT

Top ETL Tools for Business... And The Case For Saying 'No ETL'

By Peter Weinberg   |   December 1, 2020

SQL and pandas are both invaluable tools for any analyst or data scientist. They tend to be mentioned in the same breath when talking about data manipulation and ...

Data Analysis

SQL and pandas: A Rosetta Stone for Analysts

By Peter Weinberg   |   December 1, 2020

When it comes to flavors of SQL, everyone’s got an opinion—and often a pretty strong one. While the SQL debates aren’t quite as intense as, say, the Python/R holy war in ...

ETL/ELT

Top 5 Microsoft SQL Server ETL Tools

By Peter Weinberg   |   November 7, 2020

If you work with data of any real size, chances are you’ve heard of ETL before. If not (or if you just like having your memory refreshed), here’s a summary: ETL is a ...

ETL/ELT

What is Data Transformation, Anyway?

By Peter Weinberg   |   August 24, 2020

The speed, flexibility and ease of setup of NoSQL-style databases have all contributed to the rapid rise in popularity of MongoDB in recent years. Despite its advantages ...

Data Analysis

How to analyze MongoDB data in Power BI

By Peter Weinberg   |   January 23, 2020

At Panoply, we get a lot of customers who are looking to use Grafana to analyze data stored in DynamoDB instances. If you’ve ever looked into this, you’ve probably seen ...

Data Analysis

How to analyze DynamoDB data in Grafana

By Peter Weinberg   |   December 23, 2019

MySQL is one of the more popular flavors of SQL-based databases, especially when it comes to web applications. Owned by Oracle, MySQL is free and open source, so it’s a ...

Databases

MySQL as a Data Warehouse: is it really your best option?

By Peter Weinberg   |   October 10, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Instagram Data Analysis using SQL, part the third: Identifying Top Followers

By Peter Weinberg   |   September 25, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Analyzing Instagram API Data, part 2: Engagement Over Time

By Peter Weinberg   |   September 24, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Instagram Analytics with SQL Queries part 1: Getting Started

By Peter Weinberg   |   September 23, 2019

One thing we see a lot of here at Panoply is customers looking to use Tableau to analyze data stored in DynamoDB instances. If you’ve ever looked into this, or tried it ...

Data Analysis

DynamoDB Analytics and Visualization in Tableau: Step by Step Tutorial

By Peter Weinberg   |   July 16, 2019

So your startup is growing... Great! The only problem is, you can’t say exactly why it’s growing or how to increase the rate of growth. You know that analytics are ...

Being Data-Driven

How to Build your Startup's Analytics Operation from Scratch: Tools and Tips

By Peter Weinberg   |   June 18, 2019

So. You run a business that lives on data. You’ve got a SQL-style relational database or two up and running to store your data, but your data keeps growing and you’re ...

Data Warehousing

Redshift vs Postgres: Differences in Performance, Functions, and Cost

By Peter Weinberg   |   April 24, 2019

Cloud-based data warehouses are quickly replacing their on-premise counterparts, allowing organizations with big data needs to potentially save millions in costs. Amazon ...

Data Warehousing

Setting Up A Cloud Data Warehouse: A Schema To SQL Tutorial

By Peter Weinberg   |   January 17, 2019

Amazon Redshift is a massively popular data warehouse service that lives on their AWS platform, making it easy to set up and run a data warehouse. Redshift clusters can ...

Data Warehousing

Set up Your First AWS Redshift Database: A Schema to SQL Tutorial

By Peter Weinberg   |   January 10, 2019