I recommend you do a little research on BI Open Source solutions. In your case I guess that Spago BI can fulfill your needs. For each new report you can create a query or a special kind of simple fact table with dates including all data that you would need in the future for…

From my point of view people new to Business Analytics and Business Intelligence are like newbies buying smartphones: shinning colors are attractive but not the professional base to decide about a professional use of an IT tool.  Having more than a decade of background on…