Keboola Stats on Pebble

BI at your fingertips


In 2014 it’s already passe to have your dashboard behind two firewalls and two-factor authorization, full of information with various levels of importance. What our customers need in today’s fast world is literally have the most critical information at their fingertips - and not even an iPad dashboard can fulfill this promise with the expected level of convenience.

Why?

We believe that everyone of us, regardless of job or interest, has their ONE number. The one number that captures the essence of what you really do. For instance, as a salesperson you may be very easily motivated if you see what you will make on commissions and how you compare to the rest of the team. The CEO needs one number from the CFO… this immediate feedback loop is crucial for understanding and connecting actions and outcomes. Alternately, if you’re blogger, the number of followers and/or comments is what gets you out of the bed and to the keyboard each day.

In the time it takes you to reach for your iPad, another event in your business has taken place.  … And now the only thing you need to do is look at your watch.


There’s pretty short distance from your fingertips to your wrist, making the smartwatch an obvious choice. We choose the pioneer, Pebble, as our jumping point into the “wearables” movement.

Using Pebble, Keboola Stats connects with your data to deliver business insights on the go. With a delivery speed of up to 1x/10 second, we’re serious when we say “real time updates”.

How does it work?

Simple. Just three easy steps:
  1. If you don’t have it already … install the Pebble app into your phone (Android, iOS)

  2. Into that, you will install the Keboola Stats app.

  3. Finally, enter the token generated by our “Pebble Writer.”

… Oh, and it does help to have the Pebble watch.


Ok, show me what can I do ...

Keboola Stats can show you a dashboard with your top 2 numbers and their % changes in real time. So, what if you wanted to see your actual revenue from midnight (until now) and see the % change compared to (the same point in time) yesterday? Or how about today’s order count and it’s % change from the beginning of the week?

You can answer these questions in a matter of seconds, putting you ahead of the game and making you a rockstar in your next morning meeting. A glance on your ONE number tells you what you need to do next - be it nothing, or be it looking at in detail what changed the number.

But that’s only one example. Pretty much anything that fits on the screen and derived from your data can be delivered there. We now have 33 data sources + an API ready to accept any type of data from our clients - we routinely process everything from social data to POS transactions to support tickets.

So what’s next?

We have the full stack on back end - data collection, analyses and API. Now we’re ready to roll it out to LG, Samsung and Motorola :)

If you’re as psyched about this as we are, you can thank Tomas Kacur for making it all happen. Oh and Martin Karasek for snapping out the Pebble Store icons in record time - something like 45sec ? :)

If you already have your data in our care, tell us the numbers you want to see and we’re pretty much done. We will agree with you on the frequency of updates depending on the context (no point in frequently updating a number that in its nature changes slowly).

If you’re new to our services, let us know and let’s talk about how to get to your data in the most sensible way. GoodData clients have an advantage because we can connect directly to a report within the platform.

P.S.  For the tech savvy, the phone Pebble app (JS) and the app for your watch (Vanilla C) are published as an OpenSource. You can get it from our GitHub (backend API is in Apiary.io.).

The Beginner’s Guide To Keboola III: We ♥ Your Third Party Data Sources

You’re certainly using them, you probably like them, and perhaps they even help you save some money. However, you’ll find the real treasure of third party data sources the moment you interconnect them and find the answers to your business questions.

In this edition of the Beginner’s Guide you’ll find out how to use data from external services and databases to better understand your data. You will also begin to recognize the importance of getting to know your data (actually it’s time to become best friends), and how to ask the right questions to get the right results (or buckle up for one bumpy ride!).

What data sources does Keboola use?

The short answer…...lots. At Keboola, we are able to connect to most modern systems. We simply need to find the API and it’s ready, set, go.  We like to think of APIs as magical translators that allow programs to exchange data and thus make it more meaningful to you.

These are the 9 nominees for “most used source in a Keboola project” (in no particular order):

Although these are the most common, the potential for new sources is limitless (and that is why we love our dev team).

If it is readable, we can use any kind of data.

Along with service and applications connections via API, you can send us your data in almost any format. We are able to read data in everything from CSV to JSON to unstructured text in a notepad.

We can even go beyond text data and bring in pictures (bless the magic of OCR) if you so desire. The most important thing to remember when bringing data in is that it needs to be readable.

Once we have established the readability of your data we can start building out your project. Our process is generally top secret but usually involves locking ourselves in the office, utilizing only food delivery trucks for survival. We think through the logics of connection, carry out tests, and write documentation. We are then ready to upload your data and start building reports for your viewing pleasure.

Sounds great, except I have no idea where to start and what to do!

Don’t panic. Data can seem overwhelming but it is all about asking a few simple questions and then doing a few simple things.

Start by asking yourself some questions like:

  • What exactly do you want to assess?
  • How can data help you with that?
  • What indicators do you need to watch?
  • What information is missing from the tools you already have?

Next gather the data. 

For external sources begin investigating how information is communicated, the magical translators known as APIs are a great place to start. For internal sources just keep doing what you are doing and update the information you already have. If you haven’t started yet, think of ways to capture that internal information and initiate the process.

By doing some strategic thinking and then organizing your data you are well on your way to creating the right results. This process also helps to explain why more expensive data services are not necessarily better than those that are free. What matters most is the relevance of your data to answering your business questions.

It’s sort of like buying an s-class Mercedes for a ride through the rough and rocky Rubicon Trail. Arguably Mercedes makes one heck of a car, but if you don’t ask where you are going it might be a rather unpleasant ride for you and the car. That’s why it is important to ask questions first and then collect, collect, collect until you are able to cruise through to the right results.

We have to drive off into the sunset for now, but stayed tuned as we builds on this idea in our next article featuring an interview with Tomáš from Czech Keboola.

The Beginner’s Guide To Keboola

"The whole thing is a bit complicated…" started Vojta, one of Keboola’s consultants, over an English breakfast in the coffee shop with the best coffee in Prague. He was right. It was complicated. But a few hours (and a pint of coffee) I got pretty good idea what was going on. Here, I will try to relay it to you.

Intro: Companies today often have enough data to get completely lost in it and it is unfathomable to put it into context and extract any useful meaning. Even if they can, there are high costs associated with time and money.

Finding the gold in the data

Keboola does something called data ETL (Extract, Transform, Load). It sounds (just like many other fancy terms from this field) more complicated than it is.

Keboola helps you:

  1. Identify, locate and pull together all data relevant to your business from both your own and third-party sources. Anything from accounting and ERP systems to some related open-data initiatives of the government to comments on your Facebook pages. This is the Extract stage.
  2. They manage the whole load, organize it into a structure in which one can meaningfully work with it. That’s Transform.
  3. Then the data is pushed into the system or application selected for the final consumption - Load.

The toolset that Keboola uses to perform (amongst other things) the ETL tasks, is their own Keboola Connection.

The platform that Keboola uses for the analytics and producing all of those wondrous charts and dashboards is GoodData.

So what is it all good for?

You’ve got data. Lots of it.

To give it meaning, the data needs to be pre-processed, the pieces put in order and with the right context, so that GoodData will give you the results you need. That is what Keboola is for:

  • Helping you to find meaning in your data.
  • Continuously processes your data using Keboola Connection
  • Sets up GoodData so you can find the answers you need. Answers to questions like "how much revenue did we get from customers brought to us by the expensive marketing campaign from last fall?” or “what impact does weather have on our sales people’s performance?” Or whatever else comes to mind.

Keboola can do all of that pretty fast and practically without limitations. But that’s my topic for the next time.

If anything here doesn’t make sense to you, please ask! I’ll reply and explain better in the article.