Help: Weekly Report - OLAP Cube refresh use dynamic slicers, export to xlsx file to add comments

I have an xlsx workbook with a OLAP Cube Query that gets refreshed weekly in a manual process.   I need to reinvent this to be cloud based and automated. Need guidance on architecture to get this w...