DEV Community

Naufan R. Faikar
Naufan R. Faikar

Posted on

I'm working on an FOSS alternative to Tableau and Power BI!

Eruo Data Studio

I know it's not the time to announce it, since it's still in the early stage of the development. But hey, I want to hear your opinion!

Let's do talk about a little background.

So, in my previous company, I work with some supervisors who were struggling working with a medium size of dataset. It's so easy for the Customer Journey Department to receive lots of survey data and customer feedback each day, especially when the customer base already pass 1 million of user active!

By medium size, I mean it's usually consisting of more than 1 million of rows (but not exceeding 2 millions). Something that wasn't possible to load the entire contents with Microsoft Excel. The temporary strategy is so obvious to handle the situation that it doesn't deserve a story here.

Doing my own research, it seems that some people really have the same problem on the internet, trying to figure out to open a medium size of dataset.

It doesn't make lots of sense to open it in Microsoft Excel though, since there's already Tableau and Power BI. But they don't offer similar workflow, and/or flexibility to be precise.

Modern technology has been supportive to handle such situation. But trying to teach people to learn Python is not that easy. I myself sometimes too lazy to code when wanting to do just some simple discovery or calculation. A GUI application in my opinion can make things easier.

I consider myself to be Python and Pandas user, but then I discovered Polars. With Polars, my mind go crazy instantly. I can think of lots of things by adopting this technology to the spreadsheet world! Today I found myself in the middle of working on a new project (it's been 40 days since the very beginning) for making it possible to work with medium size dataset (typically ranging from 1 million to 20 million of rows) on a laptop (targeting with 16 GB of RAM) by taking the workflow of spreadsheet apps.

But, it's not intended for spreadsheet replacement despite the plan to support many subset of their formulas and workflow. It's an alternative to Tableau and Power BI. Meaning it'll be a better suit for advance business analytics. There's lots of research going on and I hope by the end this project can make the way toward it.

As of now, it's not usable yet. Lots of basic functionality are still missing. Anyway, I've already written down the full roadmap (it's just not publicly available yet).

Here's the link to the project: https://github.com/naruaika/eruo-data-studio

Would love to hear your thoughts!

P.S. Some people thinks the prototype is beautiful!

First post about Eruo Data Studio on Reddit

Top comments (0)