We have an existing POS system that reliably writes financial data to an SQL database. The system is not particularly relevant to reporting, so we have implemented our own system. Simply put, we are denormalizing financial data into a large table. Then we connect the Excel pivot table table to this large table. We absorb data, use a pivot table to cut it into a cube and summarize the numbers. Then we create charts in Excel data. This works very well, and the diagrams have proven to be very useful.
We would like to make these diagrams available on our intranet website. Instead of everyone having to download a large spreadsheet and play with it, we just need graphs on several pages.
I am sure there are many ways to do this. Our contraindications:
- Raw data is in SQL Server 2005 (in MS Windows Server 2003). This is a production database connected to our POS-terminals, so we should not add significant load to it.
- Our intranet site is based on drupal, and we have some knowledge of PHP, so we can write the drupal module and use the PHP graphics library.
- We have knowledge of C # / Visual Studio.
- We have a good knowledge of SQL, so we can further manage data in SQL Server. This can be done as a batch job after hours to minimize server load.
- In general, we have limited development time and capabilities.
Given our contradictions, can I offer some suggestions regarding the simple implementation of the system design for displaying diagrams on our website. No need for details, just some pointers in the right direction for further research.
source
share