Business Intelligence Application was a high profile intranet software that was created for a firm. This was a software that was made with the purpose of streamlining huge amounts of data so that it could be viewed, edited, updated and searched through easily and quickly. This software was also used to create detailed sales reports with insights into sales trends and analytics, so that future sales could be planned accordingly. It acted as an efficient management tool.
Due to the fierce competition in the field of product management and information settlement, the client wanted a very specific intranet software that would make it easy and convenient for all employees to access it at all times and work on it, without any time lag or glitches. This intranet software was also to act as a means to get sales reports and detailed insights into the financial transactions and the profit/loss encountered by the company.
After much deliberation over the intricate specifics that were demanded by the client, we opted for the open source Cake PHP framework. Considering the huge amount of data that needed to be organized, this was the most preferred framework that we could use as this is a framework well known for its sturdiness and for the ease with which developer s could use it. Another major advantage that this framework offered is that considering the amount of data that was constantly being updated by the firm, Cake PHP framework allowed us to add module after module onto its original structure even after deployment. An added bonus was that MySQL, another open-source SQL database, supported the Cake PHP framework. Also, Adobe's FLEX action script was used to facilitate easy accounting and calculative tasks..
Among the modules developed were:
This long and ambitious project lasted a good two years. After the completion, the client was happy and satisfied with the results of the software created that aided in easing the usage and calculation of the enormous amount of data that the company had. In most probability, it is currently still being used and proved to be a huge success in every sense of the word.