Our core application has a C# business layer and a MySQL data layer. We have some reporting requirements that take literally hours to run as they require lots and lots of aggregation. We also foresee a use for pre-analyised data for dashboard type reporting. Thus we think it's time we introduce a datamart which pre-calculates the answers to our questions in real time such that we can simply return them as needed rather than calculate them as needed.
The assignment is therefore to build a set of cubes in a datamart using opensource software (perhaps Mondrian but open to other ideas). The sample report we provide (which is already built on top of MySQL but takes ages to run) should run near instantly.
This is sort of open-ended work so we are willing to pay by the hour. If the solution you develop works effectively, is well documented, well structured and highly maintainable then we will likely have a great deal of ongoing work available for you.
The source code is however our entire IP so you will not be able to download it to your own environment. You will instead be given Remote Desktop access to a server which contains the source code you'll work with and the development tools you'll need. You will only have keyboard and mouse access to the machine, you will not have any clipboard or mapped drive access in order to protect our IP. This matter is non-negotiable so please be aware of it upfront.
Attaching a copy of the sample report. As you can see the report is very much just aggregated data which could easily be pre-calculated.