WordPress and Google Analytics are two BI tools (Business Intelligence) that go together like peas and carrots (if you’re into that sort of thing). WordPress powers over 35% of websites today and Google Analytics is running on over over 53%…
Continue reading How To Combine And Analyze WordPress And Google Analytics Data Together
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?
If you’re in the marketing and data circles, keeping tabs on your social media ads performance is constantly at the forefront of your mind. This is why we’ve built native data source connectors to most major social media properties and…
We know that many in the data analyst and data decision making world are often teams of one. There might be one data analyst in a company, even an SMB or large company, that person is a lone wolf. While…
With Cumul.io and Panoply, ProSoccerData built a data stack that enables business intelligence based off data from the soccer startup’s production application, support and billing systems. Reports are shared company-wide and with end-users inside the data-rich ProSoccerData service, used by…
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 have many different applications serving different parts of that funnel which can make…
Continue reading Advanced Customer Lifecycle Analytics with HubSpot
New Panoply system email notifications are out! Panoply is releasing a new email notification mechanism to help keep you informed on the activity around Panoply data sources. We’ll notify you when these data sources have been successfully ingested into your data…
Financial data is pivotal to any business or organizations. Startups especially need to be on top of their financial accounting – every penny of investment and budgetary spend counts. Many companies use third party providers like Xero to help keep…
Continue reading Get Xero Financial Reporting Into A Data Warehouse In Minutes
ClickHouse is my top analytics database pick for 2026 if you need fast dashboards over large datasets. It works well for real-time reporting and product analytics. If you’re working with files on your own machine, DuckDB is simpler; if you…
Continue reading Top 4 Analytics Databases (SQL & NoSQL): The Best and the Fastest
Know the progress of your data ingestions and query statusBased on feedback from our users, we redesigned Panoply’s main dashboard to give you more transparency into your data. With this dashboard, it will be easier to view the status of…
So. You run a business that lives on data. You’ve got a SQL-style relational database or two up and running to store your data, but your data keeps growing and you’re thinking you might want to set up a data…
Continue reading Redshift vs Postgres: Differences in Performance, Functions, and Cost
Instagram is the world’s most used social network and it’s no wonder why – we love living through others’ experiences and namely – through photos. At Panoply, we see Instagram as good times as well as a marketing tool; and,…
Continue reading Instagram Data Challenge – let’s get started!
