DATA STUFF

At Pivot Analytics, we believe that it's our job to look after the boring stuff, so you can focus on the business stuff. For most people data pipelines and warehouses fit into the "boring

category". If that is you then it's OK, don't feel like you need to waste your time on this bit. We won't take offence. But if your interested, then take a look below to learn more about how we work with your data.

Getting the most out of your data means bringing together the data from the range of systems that you use within your business. This might be your CRM, your finance system, your web analytics, your social channels, and the wide range of SAAS platforms that you use like Jira, Trello, MailChimp and more. 

Traditionally data integration has meant custom code, time, money and a seemingly never ending rollercoaster of "glitches" and "fixes". Thankfully those days are over because...

 

CUSTOM DATA INTEGRATIONS ARE DEAD

We have partnered with Hevo a leading, modern cloud ETL platform that makes connecting to systems and moving data simple, fast and reliable.

 

With Hevo we have access to a huge library of connectors and the tools to build new connections, all with out a single line of code. That's great from a maintenance perspective and also means that we can get up and running really fast, which is cheaper for you and less frustrating for everyone.

Screen Shot 2022-03-03 at 2.27.00 pm.png
hevologo.png

So that's the first step, connecting and moving data. The next step is putting that data somewhere. There are lots of options to chose from and we can work with your own Cloud Data Warehouse, if you already have one. If not, we recommend SnowFlake.

 

SnowFlake is a modern Cloud Data Warehouse. They have split the database into two parts - storage and compute. What this means in practice is that it's really cheap to store data and they have optimised the performance when you are doing stuff with your data so it's blazingly fast.

We also really rate that Snowflake is cloud independent, that means you can be on AWS, Google or Azure and it's all good.

So that's why we recommend SnowFlake. But you don't have to just trust us on this one, check out the Gartner Reviews for more details.

Screen Shot 2022-03-03 at 3.19.22 pm.png

So the key message is, we look after the data so you don't have to.