Latest Stories In: Panoply Blog - Data Management, Data Warehousing, And Data Analysis. | Data Analysis

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?
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
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
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
Disclaimer: The current Google Analytics connector in Panoply works with Universal Analytics. Stay tuned for our updated connector before UA is sunset in 2022.  Google ...
Data Analysis
The Analyst's Guide to Google Analytics 4
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
  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
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
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
There are some big things happening around big data. I’ve had the chance to work with various types of cloud, data center, and virtualization systems through the years. ...
Data Analysis
Don’t Just Create Data – Learn How to Use It!

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