Hello,
During my years as a big four consultant, I did several projects including database reports. For instance, to one cellfone co. here in Brazil,I did an KPI report (dashboard) that uses 7 differents databases sources, including Tableou, xls, and CSV.
My type of work is to, by the end of the day, delivery a report (could be a file) to checking and feedback, so on the next day I could do the proper corrections and adjustments.
To create graphs, probably I’ll use some dynamic cells, or even a MACRO. For the validation data, I believe that only formulas could solve it.
Hope to work with you soon,
Regards
HFava