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 to level up is to deploy a data warehouse. You've also heard that data warehouses can cost a lot of time and money—and you don't have either to spare.
Just a few years ago, that would be the end of the story. But the world of data warehouses has changed dramatically.
In this article, we'll give you a brief overview of how a data warehouse can help you move beyond Salesforce's limits, why traditional approaches to data warehouses just don't cut it anymore, and how to take advantage of a modern data warehouse on a budget and timeline you can afford.
Salesforce is the industry standard for managing your core sales relationship with prospects and customers. But if you've used it for any length of time, you've almost certainly bumped up against its limits as a tool for analyzing your business data.
Basic Salesforce reports are quite useful when you're first getting started. As you develop more sophisticated needs, you'll find that it's increasingly difficult if not impossible to get the information you need to grow your business.
For example, because of the way Salesforce data is structured, it's hard to run a number of critical queries that you'll most certainly need. Is it possible to analyze which accounts have purchased which products? Yes it is. But do you or your staff have the time and energy to bang your head against that wall?
Not only are you limited in what you can do to get insights from your business data that's in Salesforce, but your Salesforce data only offers a partial look into your prospects and customers.
Salesforce won't have all the relevant information from your customer support system's data. It won't have info from your email marketing and web analytics systems. And it won't have vital business data from all of the other systems your business uses.
While it's possible to create data integrations between Salesforce and other systems, getting it to work exactly the way you need it to and maintaining it can be time-consuming and difficult. And Salesforce isn't designed to be your Single Source of Truth (SSOT).
Salesforce experts will tell you that because Salesforce is so customizable, there are ways to get around many of these problems.
That's true—if you can afford to spend a lot of time and money. But if you're a startup looking to create a data stack or a lean business that can't add headcount just to make Salesforce's data model work for you instead of against you, you'll need a little help.
People who are experts in Salesforce make a very good living. There's a reason for that. Getting Salesforce set up so you can take full advantage of what it can do requires a high degree of skill. And once you go beyond what Salesforce does well, getting around its quirks and limitations can rapidly chew up a lot of hours.
You could train some of your staff to be Salesforce experts. But is it really worth spending so much of their time wrestling with Salesforce instead of delving into your data to find the business insights that can make the difference between failure and success?
Because Salesforce can get pretty pricey, odds are not all of your staff have access to it. Staff who don't have access may only need reporting and analytics on a slice of your Salesforce data or on a much higher level view of the data. So you'll be faced with the unenviable choice of forking out a lot more money or limiting who can derive insights from your business data.
A Data warehouse is a specialized tool for storing and analyzing large amounts of data from databases and other sources of information. Combine your Salesforce data with all the other information your business gathers, and you have the potential to understand the opportunities and risks facing your business that will help you thrive.
But what many businesses have learned the hard way is that far too often, the road to building a robust traditional data warehouse is long and treacherous.
Ask people in your industry who have created a data warehouse about what the process was like, and odds are you'll get an earful. Sometimes businesses get lucky. But more often than not, traditional data warehouses are giant projects with a staggering number of complex details that you need to get right.
To get a feel for what it's like to build a traditional data warehouse, let's take a look at an article on Salesforce's website. In Advantages of Implementing an Enterprise Data Warehouse, Salesforce talks about how awesome data warehouses are and explains that for a data warehouse solution "that fits perfectly with your existing systems and processes, you’ll be better off building your own." Then they link to an article on a high level overview of what's involved.
Here's what you're signing up for:
Step 1: "Define Your Logical Data Model (LDM)," which means "you have taken the time to document your business’s description of the operations," including "a catalog of business entities and relationships that are meaningful and critical to the business." And don't forget to "take any industry relevant standards (HL7, Party Model, etc) into consideration"!
Step 2: "Define Your Enterprise Data Strategy (including Master Data Management)." This lovely step includes answering questions like, "is there a Customer Master or Master Data Management system and if so what LDM entities are involved?"
In Step 3, we get to the fun stuff: "Document the Data Lifecycle of Each Entity in the LDM." Because "each entity within the LDM will have its own lifecycle," the article cheerfully informs you, "it is critical to capture, document, and analyze each specific entity." And you better get it right -- later you're going to use all this info you painstakingly collected and analyzed to decide "how to build a tiering strategy, and even how to build a governance model."
Now we're onto Step 4: " Translate Entities and Cardinality into Objects and Relationships" -- "an art and not a science and I definitely recommend working closely with someone very knowledgeable on the Salesforce platform."
If you haven't broken out in hives by this point, congratulations! You've only got another eight steps to go!
And that's assuming that everything goes as planned. Which of course it never does.
Once you've built your data warehouse, the fun doesn't stop. Data warehouses take a lot of care and feeding. If the data warehouse is on-prem, your IT staff will have to back up the servers, keep the system server software up to date, and a host of other tasks. And when your data warehouse inevitably outgrows your server? You've got the pain and suffering of server migrations to look forward to.
You can eliminate some maintenance work by managing your Salesforce ETL and data warehouse in the cloud. But your IT staff will still have lots to do. For example, they'll have to regularly tune your data warehouse's performance to ensure queries stay speedy as the volume of your business data grows and your staff use the data warehouse more intensively.
Your IT staff will also have to keep a close eye on the ever-changing cost of crunching lots of data in the cloud. The formulas for calculating cloud costs can be quite complex. And as many businesses have learned the hard way, the cost of a cloud-based data warehouse can easily jump dramatically.
But probably the biggest challenge you'll face is constantly having to adapt the data warehouse as your users' and your business' needs change.
For example, suppose your business is now running enough events that you decide to start using an online events management system. Or you realize that your social media marketing tool doesn't really fit your needs and you need to switch to a new one. Guess what? You've just created a whole new project to analyze the data, design a solution, test it out, etc.
On top of that, over time your users will get more sophisticated in how they want to slice and dice the data. More often than not, your IT staff will have to change the structure of your data warehouse so it can handle users' new needs. The more experienced your users get, the more your IT staff will have to scramble to keep up.
Given these daunting obstacles, it's not surprising that the business world is littered with traditional data warehouse projects which had high hopes when they started but eventually crashed and burned. As InfoWorld noted last year:
Big data projects are, well, big in size and scope, often very ambitious, and all too often, complete failures. In 2016, Gartner estimated that 60 percent of big data projects failed. A year later, Gartner analyst Nick Heudecker said his company was "too conservative" with its 60 percent estimate and put the failure rate at closer to 85 percent. [In 2019], he says nothing has changed.
Far too often, traditional data warehouses are a tar pit that can swallow up a staggering amount of your business' time and money. But if Salesforce's analytical tools aren't enough, what's your alternative?
There are three ways to solve your problem:
1) You can push all of your data into Salesforce and maintain loads of integrations. Even Salesforce doesn't think this is a good idea. That's because Salesforce isn't designed to accommodate all of the data sources you'll need to integrate if you're serious about using your data to drive your business.
2) You can use an off-the-shelf data warehouse that provides black box, cookie-cutter solutions. For example, there are a number of companies which can help you whip up pretty dashboards that look great but don't give you any way to access the data used to create them. If you're comfortable not having any way to check to ensure the dashboard is accurate, that could work for you. These data warehouses also assume that your analytical needs are pretty simple. That's fine if all you care about is a basic overview of your data. But no cookie-cutter solution is going to give you the edge you need over your competitors.
3) You could try to do all your analyses by integrating all of your sources of data through a spreadsheet. The technical term for the solution is spreadsheet hell. If you're reading this article, you already know you don't want to go there.
It used to be that these were your only choices: roll the dice with a traditional data warehouse, or live with a solution that doesn't take care of your business needs. Today, you've got another option: modern data warehouses like Panoply.
Panoply is one of the first modern data warehouses to harness the latest tech developments in order to give you the analytic power of a traditional data warehouse on a budget and timeline you can afford. It takes advantage of the fact that cloud-based computing power and storage are cheaper than ever. And it automates most of the work of a traditional data warehouse engineering team. As a result, with Panoply all of your business data is in one place where it's always up-to-date and fully controlled by you.
Here's what that means for you:
These and other advantages are why Panoply is ranked #1 in for Ease of Implementation and Ease of Use on sites such as G2 Crowd.
What is it take to get a Salesforce Data warehouse up and running using Panoply? With Panoply it’s a three-step process:
As you can see, the process is really straightforward: choose Salesforce as a data source, log into Salesforce so Panoply can ingest the data, then connect Panoply to your favorite analytics/visualization tool, and you're ready to gain a new understanding of your business' opportunities to succeed.
Like what you see? Talk with a Panoply solutions specialist to learn more and to get a personalized demo. Or start your free trial today!