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

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

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

How To Analyze Dynamodb Data In Power Bi

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!

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

Data and music have much in common given that both tell stories with points and notes, yet each on its own lacks the coherence and context that distinguishes music from ...
Data Analysis

Data Dithering: How Noisy Data Can Improve Data Importing

The byproduct of the ever increasing integration of the internet in our daily lives is massive growth of data transitioning between applications and servers every ...
Data Analysis

Handling And Constructing Json Semi-structured Data Models

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