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
Elasticsearch is the search and analytics engine that powers the Elastic Stack, a suite of products from the Elastic company. This popular search and analytics engine searches websites, apps enterprises, maps, logs, IoT data sources, and more, and creates a…
Continue reading Extract Data from Elasticsearch: Top 10 Tools for ETL
Salesforce is an industry-leading customer relationship management (CRM) platform. This BI tool supports integrated sales, automated marketing, and data analytics and management for more than 150,000 businesses of all sizes. Its advanced features include a built-in predictive AI and a…
Continue reading 11 Powerful ETL Tools For Salesforce Data Integration
Twitter, the punchy platform that gave us the #hashtag, turned 13 this year.Thankfully, it’s not a real teenager. But the iconic blue bird has done a lot of growing up, especially as a business marketing channel.75% of B2B businesses are…
