Salesforce is a powerful tool for managing your sales processes. But if you’re serious about using your business data to drive your organization, at some point you’re going to run up against Salesforce’s limitations.Maybe you’ve heard that the best way…
Continue reading How to Build a Salesforce Data Warehouse: Budget-Friendly Solution
This tutorial was authored by Ahmed Shaaban, a MeasureMatch partner.In this tutorial we are going to walk through:This is a big debate in any business environment: why do I need to replicate my MySQL data?Continue reading MySQL Replication for Analytics…
Continue reading MySQL Replication for Analytics and Visualization: A Panoply Tutorial
Xero is widely recognized as the best online accounting software for small businesses. Similar to Google Ad Analytics, Xero is a lightweight and easy-to-use analytics suite lets you log in from anywhere, with any device, to get a real-time view…
Continue reading Top 6 Xero Analytics and Reporting Tools for SMBs
Google Ads is all about efficiency. The formula for success is simple: target the right audience with the right ads at the right price. The better you do at each of those things, the more cost-efficient and successful you’ll be.There…
Continue reading How to find Google Ads Negative Keywords at Scale: 10 Minute Analysis
The speed, flexibility and ease of setup of NoSQL-style databases have all contributed to the rapid rise in popularity of MongoDB in recent years.Despite its advantages in speed and flexibility, though, MongoDB can still be a bit of a pain…
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
NurseGrid’s goal is to unite the largest workforce in healthcare with cutting edge staffing and resource technology. NurseGrid creates tools for communication and collaboration for nurses, who need help with their workflows to boost engagement, productivity, and save on costs.…
Continue reading How NurseGrid Supercharges Product Improvement With Data
At Panoply, we get a lot of customers who are looking to use Grafana to analyze data stored in DynamoDB instances. If you’ve ever looked into this, you’ve probably seen that Grafana doesn’t have any native support for DynamoDB, and…
Continue reading How to Analyze and Connect DynamoDB Data in Grafana
Every business aspires to be more data-driven, further fueling the need for enabling data-driven insights & decision making at all levels in an organization.As the volume, variety, and velocity of data explode – so does the opportunity to harness data…
Continue reading Before 2019 Ends: Check Out Azure Synapse Analytics
Happy December! 🥳As the year draws to a close, we wanted to give Panoply some nice touches before we celebrate this holiday season.We’ve been working on a renewed user interface inside Panoply. If you’ve logged into your warehouse recently, you’ll…
DATEDIFF is a super useful function that returns the difference between date parts (or dateparts) of two date or time expressions. For this post we will use data from: Hubspot Lead Analytics in SQL, Beyond CRM Reporting and will use…
Continue reading Creating Elapsed Time Histograms in SQL Using DATEDIFF
This blog post is the first of a two-part series. The first part will focus on Hubspot lead analytics and will equip you with the tools you need to go beyond standard Customer Relationship Management (CRM) reporting. Part 2 will…
Continue reading Hubspot Lead Analytics in SQL, Beyond CRM Reporting
