We are looking to modernize our Data & Analytics landscape. We have SAP BW & BusinessObjects(BO)/Analysis for Office(AO) now and planning to move lake house based technology for DW and Power BI reporting. How was your experience in terms if 1. Analysis for office(AO) replacement? 2.Overall change Management?
SAP Analysis for Office is not something I would recommend after using it for five years. It is clunky. The Azure storage/ Azure Data Factory/Power BI is perhaps the way to go. You can easily convert your SAP BO SQL to direct query method in PBI.
I am looking for insights and best practices from those who have successfully tackled data management challenges within their organizations. Our team is developing a comprehensive strategy for managing both structured and unstructured data assets across their lifecycle. I have two key questions I'd like to open for discussion: 1) How are you approaching the overall strategy for data archival and retention management for both structured and unstructured data? 2) How are you systematically implementing and enforcing defined retention schedules within your technical systems for both structured and unstructured data?
SAP Analysis for Office is not something I would recommend after using it for five years. It is clunky. The Azure storage/ Azure Data Factory/Power BI is perhaps the way to go. You can easily convert your SAP BO SQL to direct query method in PBI.