Google released Google Analytics 4 (GA4) in October 2020 in an effort to improve upon the previous generation called Universal Analytics (UA).The update to GA4 provides some new analysis features like the ability to find advertising work tools and the ability to…
Category: Data Warehousing
Postgres to BigQuery: Convert PostgreSQL Queries into BigQuery SQL
Data Warehousing
One of the first big challenges in my career was migrating an application from Microsoft SQL Server to Oracle.A coworker and I were tasked with the migration, which included the translation of views, functions, and stored procedures from one database…
Continue reading Postgres to BigQuery: Convert PostgreSQL Queries into BigQuery SQL
Data Observability Tools: Enhancing Data Quality & Insights
Data Warehousing
In the world of data and analytics, data observability is an important but often overlooked process.Much of what goes on in data science today isn’t observable because we built most data pipelines to move data, not monitor it. In the…
Continue reading Data Observability Tools: Enhancing Data Quality & Insights
7 Signs You Need a Data Warehouse
Data Warehousing
Imagine that you are in a meeting with a potential investor, and they ask you for specific information about your company to help them decide whether to invest in your company or not. Maybe they ask you for sales records,…
MariaDB vs MySQL Performance Comparison
Data Warehousing
Should I use MySQL or MariaDB? That’s probably the question in your mind right now.So in this post you’ll learn what the two products are all about, what they have in common, how they’re different, and in which cases you…
New-and-Improved Ecommerce Data Sources: Stripe, Square & Shopify
Data Warehousing
At Panoply, we know how vital data is to running—and growing!—your business. That’s why we’re thrilled to announce big changes to three of our ecommerce data sources: Square, Stripe, and Shopify! Here’s what we’ve been up to:Merchants love Square because it’s…
Continue reading New-and-Improved Ecommerce Data Sources: Stripe, Square & Shopify
Using Shopify Reports: Going Beyond Spreadsheets with Your Ecommerce Data
Data Warehousing
Recently, we’ve talked to several prospective and existing clients who have all told us slightly different versions of the same story. These clients are solopreneurs or SME’s who are running Shopify-hosted businesses. For one reason or another, their sales have…
Continue reading Using Shopify Reports: Going Beyond Spreadsheets with Your Ecommerce Data
Snowflake vs BigQuery Pricing and Performance Comparison
Data Warehousing
With companies of all sizes looking to gain value from their data, cloud data warehouses are all the rage. They’re a critical component of any modern data stack, as they enable companies of all sizes that need to wrangle their…
Continue reading Snowflake vs BigQuery Pricing and Performance Comparison
Data Warehouse Selection Criteria: How To Choose the Right Storage
Data Warehousing
You’ve been thinking for a while that it’s time to level up your data solution. You could keep muddling by. But you’re spending too much time grinding through individual requests. It’s 2021; shouldn’t your users be able to take care…
Continue reading Data Warehouse Selection Criteria: How To Choose the Right Storage
Why You Absolutely Shouldn’t Connect Salesforce Straight to a BI Tool
Data Management Data WarehousingYou 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 plan if your startup has simple needs. But…
Continue reading Why You Absolutely Shouldn’t Connect Salesforce Straight to a BI Tool
How To Nail Your New Year’s Resolution To Actually Learn SQL This Time
Data Warehousing
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 finally buckle down and master SQL.And now, with the…
Continue reading How To Nail Your New Year’s Resolution To Actually Learn SQL This Time
Five Snowflake Alternatives: Complexity and Costs
Data WarehousingAlthough Snowflake hasn’t generated $1b in annual revenues (yet), the company continues to hog the headlines for potentially delivering a historic payout to Silicon Valley venture capitalists. Continue reading Five Snowflake Alternatives: Complexity and Costs