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
The popular Shopify e-commerce service has everything you need to create, market, and manage an online business. The platform’s in-app payment platform works on websites, social media platforms, and even as a mobile POS. To make it all happen, Shopify…
Continue reading Top 6 Shopify ETL Tools for your Ecommerce Data Pipeline
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
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 great place to start if you’re looking for something to…
Continue reading Is MySQL as a Data Warehouse Your Best Option?
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
Panoply is the ultimate cloud data warehouse – with scalable storage and optimizations that make your warehouse and queries perform in the fastest possible way, Panoply aims to make data management easy.When bringing data into your warehouse, our users were…
Continue reading Making Data Management Easier With Preview, Now In Panoply
Getting the right data into the right hands is our specialty here at Panoply. With our data management platform, teams collect their numerous data sources into one place – and share dashboards, views and tables so that all data-driven team…
Continue reading Announcing Panoply’s New Data Governance Features
