Production % Complete - Based on Actual Cost Vs Baseline Cost - Displayed in Visual Report

Hi John, I always appreciate your quick and detailed responses, thank you very much!
I understand what all I am asking is a lot to ask of MSP (Desktop). I had to ask the question to verify if it was possible or not, but I had the feeling that the functionality within MSP (Desktop) just won’t be able to give me what I am looking for.
My first thought was using VBA to take the pivot table data, arrange it in a database raw data type format on the next sheet, then recreate new pivot tables or a layout on the next available sheet and have the full functionality of Excel to be able to do the calculations I am looking to achieve. My VBA knowledge is zero and I would need to teach myself how to do this, but if I can achieve this, the type of templates I can create, and detailed reporting would add a lot more value to the existing data within the project schedule.
I had searched for BI solutions and like RFromm suggested and came across Power BI which I see would only work on the online/web versions. My first job was financial reporting, using some locally designed software that would interrogate the database and by using certain parameters, dump the data from the database in Sheet 1 of Excel (RAW DATA) and thereafter, multiple sheets could use this data to display informative reports.
Many thanks for your response once again.