I am thinking of experimenting on building a model that leverages the use of Power Pivot, Power View and Modano by :
- loading detailed transation data from a database into Power Pivot
- building a data model and adding metrics using DAX formulas
- visualizing the data and metrics using Power View to generate business insights (that will be valuable when preparing projection assumptions)
- building a strategic planning model on the same Excel file (I may have to build the model first using Modano and then add the BI part on free form sheets)
I am wondering if anyone of you have tried this. If you have, please share your experience. What kind of challenges did you have to deal with?
Purwadi
Hi Purwadi,
I have not personally done anything like this, but I am excited to see how it would/could work.
From a technical perspective, your suggested approach of incorporating freeform sheets, and thereby creating hybrid modular workbook with freeform components, is definitely the right approach.
Keep us posted and let us know if you hit any road blocks along the way.
M.