Extract data from Mixpanel API

Athough I love Mixpanel, there are cases that you would like to extract data from it. Then load your data to a data warehouse like Amazon Redshift for further analysis. This post is a small overview off Mixpanel’s API and how to access and extract data from it. purpose of this guide is to help you define a process or pipeline .

About Mixpanel

For those that do not know Mixpanel, it helps you make your product better by measuring actions, instead of page views. Mixpanel gives you the ability to measure what people are doing in your app on iOS, Android, and web.

Extract data from Mixpanel

Mixpanel is an analytics as-a-service application. We usually think of it as place to see my data and not a place where I would get data from. Why? I may need to perform analysis that involves data from other sources.

Mixpanel collects data related to how your customers use your product. In case you need to have more sources you may:

  1. Enrich Mixpanel with data coming from other sources.
  2. Extract the data Mixpanel holds for you and load it on a data warehousing repository. This is what we are going to review here.

Continue reading

What I have to say about self-organizing teams

Great post about self-organizing teams from @tisquirrel. I like the bullets at the end of it, but I think somebody has to read the whole post from the beginning.

@tisquirrel

IMG_4911

Remember Agile manifesto? ‘The best architectures, requirements, and designs emerge from self-organizing teams’. But why self-organizing teams? How to build them? How do they emerge?

When I say “self-organizing teams” top managers usually think ‘teams which need no management’, ‘magic teams which work twice as much’. They behave as if we can just hire 10 nice people, put them in one room and tell them “And now you have to self-organize.’ We talk a lot about such teams, but rarely can we assemble one. Some of my colleagues even say that it is a luxury to have such teams and we just can’t afford them.

I tried to collect all my thoughts on the self-organizing teams in this post.

View original post 984 more words

How To Do A Damn Good Daily Standup Meeting

Please raise your hand if you’ve ever found yourself in a boring status meeting.
A manager with a task list at hand checks the general progress. All participants (usually in turn) will give a status update and then the deliberations begin: 5 minutes talking, 15 minutes talking, 30 minutes talking and the list goes on. In general, after 15 minutes, the average person’s mind starts wandering.

Daily standup meeting

Instead, Agile has the infamous “Daily Standup Meeting” (aka “Daily Scrum”). (Tweet This)

Continue reading

Retrospective Meetings: 4 Valuable Things Spock Needs You to Know

Star Trek… I’m afraid this post will give away my age but I’ll say it anyway; although I would not consider myself a “trekkie”, a startup is in many ways like a Star Trek season series. An episode starts with a happy bunch, travelling and exploring planets and space. Suddenly something unthinkable happens. Something that nobody could expect.

Startups

Continue reading