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 (2024 Updated)

By Peter Weinberg on August 5, 2024

Google has announced that Universal Analytics (UA) will have its sunset – will be switched off, to put it straight – by the autumn of 2023. Enterprise users are given ...

Data Industry Trends

Google Moves Marketers to GA4: Good News or Not?

By Yulia Lukashina on June 29, 2022

Earlier this year we partnered with Square to tackle a common problem: how can Square sellers unlock more robust reporting, without hiring a full data team? While we ...

Product

Analyzing Square Data with Panoply: No Code Required

By Alon Brody on April 27, 2022

Data analytics can mean a lot of things. Sometimes you’re delivering relevant metrics to analysis experts; other times, you’re identifying which tools, resources, and ...

Data Analysis

The Pros and Cons of Open-source Software in Data Analytics

By Corissa Haury on December 6, 2021

Google Ads is Google's platform for digital business advertisement. If you're new to Google Ads analysis, you'll need to understand the kind of data on the platform.

Data Analysis

The Analyst's Guide to Google Ads & Successful Ad Spends

By Temilade Adefioye Aina on September 14, 2021

Google released Google Analytics 4 (GA4) in October 2020 in an effort to improve upon the previous generation called Universal Analytics (UA).

Data Analysis

The Analyst's Guide to Google Analytics 4

By Temilade Adefioye Aina on August 17, 2021

For years, Microsoft has been a leader in Gartner's quadrant for intelligence and analytics platforms. In other words: it has a complete vision and can execute it.

Data Analysis

How to Analyze DynamoDB Data in Power BI

By Roel Peters on July 13, 2021

MongoDB's data flexibility is a breeze for developers but can be a major headache for analysts and data scientists. Here's how to wrangle your non-relational MongoDB ...

Data Analysis

How to Analyze MongoDB Data in Tableau

By Michelle Hoogenhout on May 3, 2021

For the final entry in our SQL and pandas series, we’re going to be talking today about closing the loop. We’ve talked about the difference between pandas and SQL, how ...

Data Analysis

How to load pandas dataframes into SQL

By Peter Weinberg on February 24, 2021

You want to get more out of your Salesforce data—and who doesn't? So it’s time to boot up your favorite BI tool, hook it up to Salesforce, and rock out. That's a fine ...

Data Management

Why You Absolutely Shouldn't Connect Salesforce Straight to a BI Tool

By Anders Schneiderman on February 9, 2021

Maybe you're a business analyst who's sick of not being able to level up your Power BI reports. Or maybe your New Year's resolution is that this is the year you'll ...

Data Analysis

How To Nail Your New Year's Resolution To Actually Learn SQL This Time

By Anders Schneiderman on January 21, 2021

As today’s number one CRM platform, Salesforce provides support to a variety of business processes within companies. With that in mind, you can only imagine the huge ...

Data Analysis

Understanding the Salesforce Data Model for Analytics

By Belma Mesihovic on December 7, 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 on December 1, 2020

Google Ads is all about efficiency. The formula for success is simple: target the right audience with the right ads at the right price. The better you do at each of ...

Data Analysis

How to Find Google Ads Negative Keywords at Scale

By Trevor Fox on March 5, 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 on 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 on December 23, 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 on 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 on 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 on 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 on July 16, 2019

The typical customer funnel is easy to understand and is useful for creating a strategy for your entire Sales, Marketing, and Customer Success teams. However, you likely ...

Data Analysis

Advanced Customer Lifecycle Analytics with HubSpot

By Marissa Ramirez on June 11, 2019

Today I want to show you how you can combine performance metrics from three popular ad networks, Google Ads, Bing Ads, and Facebook Ads without exporting a CSV or ...

Data Analysis

Combining Data from Google Ads, Bing Ads, and Facebook Ads in Google Data Studio

By Trevor Fox on March 1, 2019

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 Analysis

How to Avoid Fallacies in Data

By Loni Schuman Shape on October 17, 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 on January 19, 2018

Every single day we, as a connected – mobile – workforce, are creating vast amounts of data. In fact, a recent Cisco report indicates that by 2020, data center storage ...

Data Industry Trends

How Big is Big Data - Discover New Ways to Leverage Data

By Bill Kleyman on October 18, 2017