Forum Discussion
Best Way?
Hi, I am creating a workbook which will live in SharePoint and will be used as a register to hold sales data etc. I need to create a couple of additional workbooks which will be dashboards t...
IMHO, the best way is to connect and transform data using Power Query, add some measures in data model using Power Pivot and finally pivot into Excel dashboard. Even more better to publish dashboards on Power BI services.
However, that requires to invest some time in learning of above tools if you are not familiar with them.