What can data analytics do for you?
Old but still valid! This article was created in 2017. Today, we are already looking at a slightly different dashboard (you will see it below), yet the same rules still apply, even in 2020.
Very often we get a question from you: How the data analytics or data detective services can be useful to me? You often want specific practical examples from us, but because the confidentiality of our customers' data is the alpha and omega of the whole business, we decided to show you examples of how we use data analytics by us - in BizzTreat - such a Data Detective for ourselves!
What does a dashboard look like today?
Below we will have a video summary. But firstly, let's show that the dashboard can also develop :-) Today it looks like this and it is far from being the only one we show every Monday.
What are we most interested in?
We follow 3 basic parameters that are key to the financial health of the entire BizzTreat:
- achieved average hour-rates,
- the number of hours worked, that we will invoice directly to the customer and
- so-called utilization: the ratio of paid hours to all hours worked.
The basic thermometer shows us how many paid hours we have already delivered and whether we are heading for the goal. We use 2 goals, the minimal one, set to cover all the costs of the company and create an agreed profit, and the optimal one, which covers costs, profit and allows us to invest in the development of the company.
As you can see, we're not doing very well this month.
This chart even shows why. Here you can see the breakdown of paid hours into individual clients (we anonymized their names for the purposes of this video). The red line shows the number of hours contracted in the flat rate; the orange line recalculates this information to current date. So, as you can see, we are late with the delivery by those three marked clients.
What is needed for this?
In order to be able to analyze our business this way, we must:
- "take out" data from the systems we use - here you can see that we use Fakturoid for invoicing and Paymo for reporting,
- then it is necessary to clean and enrich the data
- and then "push" the data into some display. In our case we use Tableau.
Are you curious about ETL process using cloud? - Google Cloud Platform, AWS, MS Azure? --> See our Bizzflow.
And that’s it :-)
It looks simply, doesn't it? It surely comes to your mind that "I can do this in Excel too." But try updating the data daily. Or several times a day. And what if you have so much data that it doesn't even fit into Excel? What if you need to make a small change and your whole system of Excels sheets and tables falls apart? These are exactly the situations where it pays to call a data detective.
Do you have any questions or comments about the article? Feel free to write to me, I'll be happy to discuss it with you :-)
About two years ago, Keboola decided to meet the dream enterprise segment and unfortunately adjusted the price list accordingly. We are more than happy that after quite a long time Keboola is returning to the roots – to small and medium-sized companies. For SMB-companies Keboola is launching a pay-as-you-go program that makes the "KBC" really available to every team and allows you to start literally for free. What are our first impressions?
Unfortunately, there are so many so-called "beautiful" designs of dashboards circulating on the Internet, which ignore the basic rules, that one is quite surprised. And later then, you are even more surprised, when your client brings you this "beautiful" horror, saying that this is how his dashboard might look like. The analytical team sometimes defends these transgressions, because "business wants it that way". What types of transgressions are we talking about? Let's take a look at the most common ones.
To si takhle jednou vyrazíte do Krkonoš k zákazníkovi. S láskou vyberete tři ingredience, správně je promícháte, nastavíte a najednou máte luxusní recept - JIDOKI. No a než se nadějete, může vaše firma díky datům až ztrojnásobit obrat. True story, bro.