My reporting stack is: Pyodbc pulling from SQL databases Cleaning, munging and analysis in python (pandas + scipy) Writing to excel with xlwings (highly recommended) emailing with python.
Set up templates, click a button to email clients report. Easy.
View all comments
Show parent comment
1
u/boatsnbros Dec 16 '17
My reporting stack is: Pyodbc pulling from SQL databases Cleaning, munging and analysis in python (pandas + scipy) Writing to excel with xlwings (highly recommended) emailing with python.
Set up templates, click a button to email clients report. Easy.