This blog post is the first of a two-part series. The first part will focus on Hubspot lead analytics and will equip you with the tools you need to go beyond standard Customer Relationship Management (CRM) reporting. Part 2 will…
Continue reading Hubspot Lead Analytics in SQL, Beyond CRM Reporting
Ecommerce is getting more competitive every day as big players like Amazon and Alibaba consume more markets and scrappy D2C players try to disrupt them.It is impossible to ignore the competitive edge that data has provided for companies large and…
Continue reading Building Shopify Dashboards in Tableau, Power BI and Google Data Studio
Comparing metrics over time is a great way to benchmark progress and to identify issues as they come up. In order to compare metrics over time, the dates in your table(s) should be stored as dates or timestamps. To learn…
Congratulations! You’ve connected to your data warehouse (or database). You are on your way towards analytics awesomeness. But first, you need to get your bearings. Lucky for you, there are some pretty stellar data exploration features to get you started…
Continue reading Exploring Tables And Columns In Redshift: A PG_TABLE_DEF Tutorial
In this blog post, I will introduce you to the basics of using CASE statements/expressions. This post will also cover comparison operators (greater than, less than, equal to) and BETWEEN. My goal is to present the material in a way…
When I started my SQL journey not too long ago, I diligently completed interactive tutorials and to be honest, thought I had a grasp on this thing. Fast forward a couple of months, I tried to write my own queries…
Continue reading A Beginner’s Guide to Formatting Dates in SQL
This post has been updated to reflect changes to Instagram’s API (Facebook’s Graph API). You will now need to switch to anInstagram Business accountto perform this analysis in Panoply.Welcome back to all the Instagram brand ambassadors, social media analysts and…
Continue reading 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 anInstagram Business accountto perform this analysis in Panoply.Ok, Instagram datanauts, welcome back to the second installment of our ongoing…
Continue reading 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 analysis in Panoply.Even though Instagram isn’t one of the original social media…
Continue reading Instagram User Analytics: Getting Started with SQL Queries
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 yourself, you probably know that it’s not particularly easy.…
Continue reading DynamoDB Analytics and Visualization in Tableau: Step by Step Tutorial
If you’re working with data, you’ll often need to collect data from different sources and store it in various destinations. Whether your data transfer is a one-time task or a continuous process, you’ll need ETL (extract, transform, and load) to connect your…
Continue reading How to Use Singer for Your ETL Pipeline: Step-by-Step Tutorial
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 writing a single line of code. Then I’ll show you how…
Continue reading Combining Data from Google Ads, Bing Ads, and Facebook Ads in Google Data Studio
