google app script, javascript

We want to develop google sheet as dashboard which contain all type of reports like sales, stock, payments, collections and any other reports which arise according to necessity. We have a MIS person who can develop the supporting datas but inorder to compelte it javascript writer is required.