In Panoply’s Data Bytes mini videos, we’ll chat with our experts and explore topics relevant to the industry, to us, and especially to you. The first episode coincided with the six-month anniversary of SQream acquiring Panoply, so we spoke to SQream…
Continue reading Data Bytes Episode 1: After the Acquisition
Google has announced that Universal Analytics (UA) will have its sunset – will be switched off, to put it straight – by the autumn of 2023. Enterprise users are given time to rescue their marketing analytics until the 1st of…
Continue reading Google Moves Marketers to GA4: Good News or Not?
Moving your business from disparate data sources and ad hoc reporting to a single source of truth data warehouse solution is a sign of growth in the right direction.However, data warehousing requirements differ from one company to the next, and service providers…
Continue reading 10 Questions to Help Define a Successful Data Warehouse Strategy
The buzzwords “big data” have been around for a few years. Simply put, it refers to extremely large amounts of information. As this data grows in quantity, variety, and complexity, it’s vital to manage it appropriately. Doing so lets you…
Continue reading Data Management Best Practices and How They Help Your Team
Using insights generated from company data is essential when making business decisions. Having reliable data enables a company to make strategic decisions to optimize operations, track overall company performance, and observe valuable trends.Power BI has proven to be a handy tool…
With the launch of our new 21-day Free Proof of Value, new users have plenty of time to begin seeing the value that Panoply adds as a part of their tech stack. In order to make sure you get the…
Earlier this year we partnered with Square to tackle a common problem: how can Square sellers unlock more robust reporting, without hiring a full data team? While we already had a Square connector in the Panoply platform, we took this…
Continue reading Analyzing Square Data with Panoply: No Code Required
Try Free for 14 Days! No doubt you’ve seen this language all around the data industry and the internet at large as the free 14-day trial has become table stakes for any SaaS Platform. But we decided to toss that standard…
Continue reading Exploring Panoply’s New 60-Day Proof of Value
Data flows like never before, and with so much at our disposal, making the best use of it is a challenge. Many businesses use Google Sheets for everything from content planning or list building, to financial reporting and KPI tracking.…
Continue reading 6 Use Cases for Connecting Google Sheets to Panoply
A recent IDC DataSphere forecast report predicts that the compound annual growth rate of global data creation and replication will reach 23% between 2020 and 2025.Another study suggests global data creation will grow to over 180 zettabytes during that same period.Cheaper data storage and advanced analytics…
Continue reading 10 Benefits and Use Cases of a Data Warehouse
This article will cover how to work with time series/datetime data in Redshift.Time series data holds the date and/or time information and is different from string or numeric data since it has components like day, month, year, hours, etc., that we…
Continue reading Manipulating Time Series/Datetime Data with SQL in Redshift
Sometimes, The only thing standing between an analyst and a catastrophic management decision could be knowing the difference between the tables:_web\_user\_behavior\_v2_and _web\_user\_behavior\_new._Effective naming conventions for your data warehouses allow data analysts to do an exponentially better job…but it’s far from…
