I currently have macros set up to automate all my reports. However, some of my macros can take up to 5-10 minutes due to the size of my data. 
I have been moving away from Excel/VBA to Python/pandas for data analysis and manipulation. I still use excel for data visualization (i.e., pivot tables). 
I would like to know how other people use python to automate their reports? What do you guys do? Any tips on how I can start the process? 
Majority of my macros do the following actions - 

Import text file(s)
Paste the raw data into a table that's linked to pivot tables / charts.
Refresh workbook 
Save as new
When using python to automate reports I fully converted the report from Excel to Pandas. I use pd.read_csv or pd.read_excel to read in the data, and export the fully formatted pivot tables into excel for viewing. doing the 'paste into a table and refresh' is not handled well by python in my experience, and will likely still need macros to handle properly ie, export a csv with the formatted data from python then run a short macro to copy and paste.
if you have any more specific questions please ask, i have done a decent bit of this
Python - pandas / openpyxl: Tips on Automating Reports (Moving Away from VBA).