Hi all, it’s been a while since my last post for sure. I have been struggling to keep up with the pace in my current workplace and looks like it has taken its toll. This post is dedicated on explaining why I took this hard decision to leave the company. Hint: health is the most important thing, please maintain it well so we can enjoy our life not from hospital bed.

Disclaimer: all of the content here are my own opinion and does not reflect the whole company situation.

Hi guys, sorry I don’t write much recently. I guess Covid really takes its toll because it’s still showing increasing trend in Indonesia while some other countries also see what we called a second wave. As you all may know, my current company Moka was acquired by Gojek around April 2020. Without Covid, I guess the acquisition itself already impact in many aspects. Now that we are doing it during Covid, I think this provides me with the unique experience which worth to share to many of you. Read on to know more about both opportunities and challenges I face nowadays.

This post is part of my speak back in 10 June 2020. I will describe the chunk of this session bit by bit in the next few articles. If you want to check the deck directly, you can download it below. This part will focus on the definition of AI itself which somehow getting popular in recent years. Read on for more details.

Intro

Now that we have the data at hand, rhe next question will be: what’s inside it? In this post, I will explain about some basic terms to get basic understanding of numerical data. Example in real life can be exam results, and everything with a price tag on it like house, car, or stock. Let’s go dig deeper on that.

After we can get the raw data, the next step an analyst do is usually to check for some statistics of it. Using SQL we can do that in straightforward manner as follows.

The most efficient way to get our data is by having a direct access to the database. And fortunately, the most analyzed data is still in structured format so far. This post will assume that we have a database and a client app installed in our laptop. We can choose to install an open source database like Postgre or MySQL. As client app, we can use DBeaver or the equivalent. After connecting the client app to rhe database, we can start to roll. There are three commands as baseline pattern for a query. Keep reading to know more!

This role deals a lot with handling data requests and past performance analysis. The first required understanding on how the data is generated and where to find them. Still straightforward if we deal with 10 or 20 tables. But what if the tables reaches 100, 200 or more? The second is even more complex. After we get the data, how we can be confident with the data at our disposal? Is it clean enough, as in no testing data or outliers inside? To overcome these challenges, these are three most important skill for data analysts.

Introduction

With a wide and variety of work, to understand data and provide business with recommendations, we will need a strong team with multiple roles interact with each other. This team also needs to live in two distinctive and different worlds. One is emerged from business point of view, where what is important is either increasing company’s revenue, or reducing the cost. The other one is from engineering where we need to understand where to get the data, how to clean, explore, train and implement our scripts such that we can make the code work and alert us with minimum supervision. In general, we need a team which covers three roles. There are new roles emerged, of course. But the root came from the original three. Read on to read what are those three.