Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021
Tags: datascience, database, sql, startup
Published: 2020-11-29 17:58:43

Photo by [CoWomen](https://unsplash.com/@cowomen?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText) on [Unsplash](https://unsplash.com/s/photos/consulting?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText)

If you're a small business or start-up, you're probably reading articles about companies using data science, data analytics and machine learning to increase their profits and reduce their costs. In fact, [McKinsey just came out with a study that found that the companies they survey could attribute 20% of their bottom line to AI implementations](https://www.mckinsey.com/business-functions/mckinsey-analytics/our-insights/global-survey-the-state-of-ai-in-2020#). All those trendy and hyped up words are proving to be effective for companies of all sizes.

As data consultants we have had the opportunity to help multiple clients in industries like healthcare, insurance and transportation realize similar gains and cost savings. All of which started with us helping them determine what was the best data strategy for them.

In this article we wanted to take you through few of the steps we walk clients through to help them figure out their future data strategy. We hope this article can help you take into consideration what your goals are and perhaps how data can help you achieve those goals in 2021.

Open Office Hours For Consultations
===================================

Before we get to the main article. I wanted to give the readers a heads up. I will be holding office hours providing consultations to your questions for your data analytics strategy questions on Saturday December 5th at 7 PM PT.

[Please send me your questions here!](https://forms.gle/TDed78YydtKfJK2i8)

And now, back to the article!

Define Where You Are In Your Data Strategy And What Your Data Goals Are
=======================================================================


![Image for post](https://miro.medium.com/max/2048/1*HSp536Ru8dvHasTxJiA65A.png)

Step one, regardless of how big your company is for our team of data science and software engineering consultants is to figure out where your company is as far as data strategy.

We will ask you questions that help us pin-point how much data do you have on your company's various workflows, do you already have some data analytics in place, what data tools do you use, etc.

Before we get to deep we need to figure out where we are starting.

Once we have a good scope, our teams next goal will be to figure out where you want to go.

Do you want to build a dashboard for your small business, how about a machine learning model?

Are you looking to reduce costs? Increase profits? Create a data product?

Even if you don't know what your data goal is, our team will work with you to understand your needs and help you craft a data analytics strategy.

We don't expect you to know everything, that's why our team is there!

But let's go down one possible path for your 2021 data strategy. Let's start by saying you just know you want to get more value from your data.

Here are the steps our team of data and software consultants would go down to help you define that value.

Assess What Data You Have
=========================

Data is an asset.

Which means you need to know what types of data you have to know what you can do with it. The more of your businesses workflows that are stored in databases or third-party tools, the more you can gain from the data.

But it all starts with you actually figuring out what data you have access to and where is it tracked. Lots of modern tools allow you to pull data from them or at least get an extract through some CSV or Excel report.

Before you can even start to plan your data strategy, you need to know what data you have. Take an inventory, and see if there are valid questions you think you could answer with the data.

Here are a few examples if you are uncertain where dat can come from.

1.  Salesforce
2.  Workday
3.  Asana
4.  ShipWell
5.  Trello
6.  Hubspot
7.  Zendesk
8.  Stripe
9.  Shopify
10. Xero
11. And more.

Determine How You Want To Store Your Data For Analytics
=======================================================

A common tool for managing data is a [data warehouse](https://www.theseattledataguy.com/what-is-a-data-warehouse-and-why-we-build-them-a-video/#page-content). This is a central system that acts as a source of truth for your teams dashboards and reporting needs. These systems do require a general understanding of data modeling, but they are much more approachable now a days for smaller and medium sized companies compared to 15 years ago.

So, do you need a data warehouse?

There are a couple of reasons you might consider utilizing a data warehouse for a small company. For example:

-   You need to constantly access your data daily for analytical purposes and want to avoid impacting the operations database
-   Your data needs to be processed heavily before you can use it for analytical purposes
-   You need to develop multiple dashboards that your business will use that update automatically
-   You want to have a central place for all your data so you can connect it all together

Thanks to AWS and other cloud providers, small business owners and start-up CEOs can access data warehouse and [ETL](https://seattledataguy.substack.com/p/what-are-etls-and-why-we-use-them)(extract transform load) technology for a fraction of the cost it has cost larger companies in the past.

This provides a huge advantage to your data strategy. Instead of having multiple technical employees design, develop and implement a data warehouse. You can pay one data engineering/science consultant. This is because you don't need to spend time acquiring a server, setting it up on your network, managing licenses, etc. Instead, all of your data warehouse management can be set up on the cloud on a virtual private cloud for your company.

How Can We Help You Use Data To Increase Profits Or Reduce Costs
================================================================

![Image for post](https://miro.medium.com/proxy/0*24PvrN9oICC6qCBh.png)

Just having data in a data warehouse or some central storage location does not create a data strategy. It merely starts to set your team up with an easy place to access your data.

So you need to ask yourself, how will you make your data an asset.

It can provide revenue through the means of creating a product, it can help reduce costs by helping your team spot inefficiencies and it can increase profits by showing possible new tools or solutions you had not considered before.

So how do you go from raw data to actual insights?

This process is a combination of utilizing subject matter experts and data analysts/scientists.

In some cases you can bring on a [data science consultant](https://www.theseattledataguy.com/data-science-consultants/) or analyst and see if they can find cost savings you might have not been aware of.

Here are 4 examples of how our team helped reduce costs and increase profits.

Reducing Costs
==============

Example 1 --- Reducing Costs Of Service [Cannibalization](https://corporatefinanceinstitute.com/resources/knowledge/strategy/market-cannibalization/)
---------------------------------------------------------------------------------------------------------------------------------------------------

Our team for example, has done some analysis for several companies with little to no guidance and we were able to find optimizations such as when one of our clients had started cannibalizing their services.

This is to say that they had started to add more services over the years to try to increase their profits. However, when we examined their historical data we found that the average users per service was done while the total users had barely changed.

So the business owner was paying more to service the same amount of people.

We found this with no prior knowledge of the owners business trends or patterns.

From there our team was able to work with the owner of the business to reduce market [Cannibalization](https://corporatefinanceinstitute.com/resources/knowledge/strategy/market-cannibalization/) and better optimize their services.

Example 2 --- Reducing Fraud Costs
--------------------------------

Another approach is to have a more targeted approach. For example, perhaps there is a specific problem in your business you are trying to solve. Such as fraud.

Fraud appears in many industries in many ways. Whether it be healthcare, insurance or credit cards. Fraud is everywhere.

That being said, often time fraud follows particular patterns.

In healthcare, a common scenario you will see is called upcoding. This is when a healthcare provider bills for a service that is more expensive than the service they provided.

For example, a service provider might claim they provided an emergency or surgical service when all they provided was a standard procedure.

If this happens once or twice, there might be some reasoning behind this. However, if a provider shows higher than normal signs of this behavior, it is likely a sign of fraud.

This might seem obvious now that we have explained it. But just going and telling a data scientist or analyst who has never worked on healthcare fraud before to find fraud, might have them spend days or weeks to com to that conclusion. Instead, you could pair them with a fraud analysts (which are common in insurance companies) to help them understand the domain better.

What About Increasing Profits?
==============================

Example 3 --- Optimizing Pricing
------------------------------

Companies like Uber and Lyft have been optimizing pricing for a long time. The idea of pricing your service based on demand to ensure both you and the customer are getting the highest value is a great way to increase your profits.

We have done a lot of work in the transportation industry, one of the major projects we took on was improving the pricing model for a company that had been manually pricing without considering historical or current demand.

Our team of software and data science consultants helped develop a product that has increased that companies profits by 15%, solely on the model alone. This was done by creating a model that took in past travel data, current reservations as well as possible future local activities(baseball games, fairs, concerts, etc) into consideration.

From there, our team built a simple UI that their team could punch in a date and find an optimized price.

We are now working on integrating that tool into a larger part of this companies infrastructure.

Example 4 --- Developing A Data Product
-------------------------------------

There are companies out there that make 100% of their revenue based on their ability to take data and create insights. These are analytics companies that have developed dashboards and algorithms to help drive insights for other companies.

This may or may not be an opportunity for your company. Many companies will pay to have insights and dashboards pre-delivered to them.

One way you can do this is find an opportunity for creating a report or dashboard internally inside your company.

If you're a healthcare company it might be developing a dashboard for fraud detection, if you're in operations it might be focused around creating a dashboard to help track inefficiencies.

Whatever it may be, you can work to package it and then resell the base of that dashboard to similar companies/teams.

In turn you now can make money of both your domain knowledge and your data.

Overall, these are just four ways your company can utilize your data to improve your overall company strategy.

What Will Be Your 2021 Data Strategy Roadmap
============================================

Next year will be here sooner than we realize. Taking the time as a small business or start-up to plan how you will use data to improve your overall strategy can make a huge difference. Hopefully this article providing some ideas on where your team can start.

Whether you need to determine what data you have on hand or what you can do with that data, take the time to write a roadmap.