Building a dashboard for my operations

I would like to build a dashboard tha tdoes this :

1-) Collects all events from differen tsources : ( can be e-mail, API, ...etc);
2-) Upload these into some kind of dshboard database;
3-) HAve the dashboard built and sent on a daily basis;

For instance, I would like dash-board to be like this :

AIRBNB  ON 13/03/2018  : 
                  Total revenue ( 700 EUR)   - Expected revenue ( 1000)
                   Total cost      ( 300 EUR) :
                                                                   NET REVENUE = 400 
                                                                   MISSED REVENUE = 300 EUR
 
Crypto on 13/03/2018 :
                   Expected revenue: 250 EUR / Effective Revenue : 0 EUR
                  Total daily cost     : 250 EUR ;
                                                                   NET REVENUE : 200 EUR


OTHER SOURCES 
                  Same thing !

The question that remains is , which tool and which way is best to reach this result in a automated way. I would like to receive these information on a daily basis so to monitor it .

Where to start?

Solution 1 :        
          a. Use Zoho Reports ==> Limited to 100 000 records ; 
          b. Use php reports    ==> Just checked; 

I'll give a shot to the Zoho reports solution as a start.