We are looking for migration of excel sheet based tool ( which takes inputs from two/three sheets, perform a lot of formulas, do a lot of calculations by taking inputs from those two-three spreadsheets and gives output in one of the spreadsheet).
Currently, we do have Microsoft sequel server as an option to use for database.
We needs slides that showcase comparison among the best BI tools and suggestion on which tool which be best suitable for the below mentioned requirement.
Requirement that needs to be fulfilled ( must 😞
- Each User should be able to select some options based on which different formulae will be applied to arrive at final cost.
- Each user should be able to enter some manual overhead cost which will be taken in formula.
We will need to customize tool to take inputs from User and then generate report.
Will power BI will be able to take macros defined in different spreadsheets of an excel , do lot of calculations/ use lot of formulas and generate output in another table/spreadsheet ??
Right now, I am trying to use Power BI desktop and the tables are appearing in feeble manner/ less vibrant.
An excel sheet has a better look and feel than a Power BI desktop ( when I opened the same excel sheet in the PBI desktop)
Can you help me resolve both the issues?
