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…
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.Continue reading 10 Benefits and Use…
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…
The enterprise data warehouse (EDW) is a fairly new entrant into the universe of databases mainly optimized for reading operations. By structuring data in a rigid schema, EDWs accommodate the need of data analysts to deliver decision-supporting insights.This article elaborates…
Data analytics can mean a lot of things. Sometimes you’re delivering relevant metrics to analysis experts; other times, you’re identifying which tools, resources, and people you need for data processing.Many of the tools available to carry out data analytics work…
Continue reading The Pros and Cons of Open-source Software in Data Analytics
One of the significant challenges in handling data comes from the massive amount of data your organization is most likely generating constantly. Having the ability to react quickly and accurately turns into a differential item among competitors.More and more companies…
Continue reading Data Warehouse Design: The Good, the Bad, the Ugly
