Is power bi + excel or sql best for my requirements?
In our organisation there are 6 departments (incl. HR & Admin). Each department's Manager prepare MIS - Management Information System monthly once and sends it to the Board for strategic decisions. Each department has MIS format in Excel and they fill it out every month and fields are almost similar for all depts. They consist details like value of services rendered & billed, collections against bills, individuals performance, any matters of client meetings that are important, learning sessions attended by members of dept. etc. Some are quantitative (billings, collection, performance ranks etc.) and others qualitative (comments, meetings minutes etc.) Now as obvious there are 6 MIS a month and it's become difficult to combine them and put it in clear one dashboard to use for the board. So to automate this I've been tasked to come up with a solution. I did some research and decided to provide a dashboard for the board in Power Bi using all 6 MIS. Is this an optimal & useful solution?