How I built an automated reporting system using Python for a real business.
Speaker: Tobie Nortje
It is only when one has to solve a real-world business problem that the true power and flexibility of Python is asserted.
The need was identified to automatically produce more than 20 daily reports. These reports had to be available in HTML as well as PDF formats. Reports had to be mailed to different users depending on the user. The whole process had to be automated and require minimal human interaction once completed.
Talk contents and focus
In this talk, we will discuss how Python can be used to solve the many small problems that had to be solved in the development of the reporting pipeline.
Some of the problems that had to be overcame and their solutions include:
interacting with various database types
combining and analysis of many different and large energy consumption data sources
generating and embedding static plots
designing a template system that can output to HTML as well as PDF formats
report distribution via email and HTML
automation of the pipeline
There were also some lessons learned which will be discussed.