Ask HN: How to build your own reporting tool?

1 points by oscarteg 8 years ago | 3 comments

For my thesis I'm going to build a Proof of Concept of a reporting engine but I don't know where to start. I have read about business intelligence tools a bit and that is the direction that I need to search but those all refer to existing tools. What I have in mind is a reporting tools like google analytics based on dimensions and metric to extract aggregated data from the database.

Any recommendations on literature about how reporting tools work? Or some talks about it on YouTube?

mtmail 8 years ago |

Have a look at the author https://en.wikipedia.org/wiki/Ralph_Kimball

oscarteg 8 years ago | |

Thank you! I have just bought the book 'The Data Warehouse Toolkit'. This was just what I was looking for.

mtmail 8 years ago | | |

That gives you understanding of data modeling, dimensions vs facts and how to structure database tables (or other data stores). Next read up on ETL system (how to get data into databases) and Hadoop (aggregating data among dimensions). At least for Hadoop there should be many online presentations and youtube videos. Lastly data visualization.