How and why I built Business Insight Dashboard - Tool
About me
I am a professional Java developer with more than 4 years of experience writing robust code.
The problem I wanted to solve
The problem statement was to develop an application which would fetch data froma huge dataset and plot the pattern in a multisheet excel file. Each sheet will contain different pattern and analysis.
What is Business Insight Dashboard - Tool?
Built an application which would fetch the data from db using Hibernate and populated that using Apache POI framework in Multiple sheets and in different pattern and calculations.
Tech stack
Java, Spring, Hibernate, Apache POI
The process of building Business Insight Dashboard - Tool
The process started with a basic archetectural design system of the application and database modelling.
Challenges I faced
Lot of challenges in terms of Excel generation, Data arrangement, Slow data fetching speed due to huge volume, Excel formula configuration, color coding, header generation and many more.
Key learnings
Apache POI framework, Indexing in Database, Excel report generation using Java