Database contains 6 tables. 1 main table with 6 millions rows and 12 columns of data about each row. 2 smaller tables with actions logged later linked by id. 3 other tables are just name labels linked by id.
Need to be able to drill down on the data by groups, subgroups, multiple date ranges, and the other columns of data. There are 3 timestamps from different actions that the data needs to be examined from.
Visably display cost vs return through purchases over time for groups, subgroups.
On going more detailed reports to find profitable and non profitable groups or subgroups.
More details will be sent if interested in job.