Neoinventory
Overview
We built data analytics module for neoinventory erp this system includes many live data synchronization in form of different chart like bar, pie, line etc. the system had millions of records and based on the data fillteration we had to rendor a data into graphical forms we used chart js and d3 chart library to bind charts based on data.
Challenges
- Due to millions of records application taking too much time to rendor chart we optimized sql queries by implementing and creating indexis in sql server we used sql procedure to get data from different table based on fillterd criteria.
- Implementing D3 Chart library.
- Design compact UI/UX to show any length of a chart.
- Provide real-time filtering.
TECHNOLOGIES
- HTML 5
- CSS 3
- BOOTSTRAP 3
- ASP.NET CORE
- ANGULAR 5
- SQL SERVER
Our Solution
- Provide a bar chart to show comparisons between categories of data.
- Provide Pie chart to show percentage or proportional data.
- Provide a line chart for visualizing a trend in data over intervals of time.
- Use chartjs library.
Our Approach
- We have provided different invoice report like Invoice Day, Invoice Month, Invoice Year .
- Provided a different filter to calculate the data.
- Provided elaborate transaction detail with gross price, net price, and different add-on.
- Provided different sales reports like agent sales, client sales, and district/region sales.