I have several tables in a database for an online rewards program for game players. The tables are thing like a typical "users" table that holds account information, a table for rewards given out to users, a table for affiliates who refer players, and other information like ip address logons..
I need to visualize this data in charts like and answer question like "how many users are created each day", "what percentage of players are referred by affiliates vs. not", "how much money has been made from players who were referred by affiliates", "what are the peak times of player activity", etc...
Need recommendation on tools to generate reports and someone to write the queries.
I can provide the database.