Request and wrangling HTML using two of the most popular Python libraries for web scraping: requests and BeautifulSoup.
Configure Task Scheduler to carry out the maintenance jobs you might forget, by following our step-by-step guide.
Since we needed to keep reporting in Excel, and there was no budget for a BI tool, we decided to use Python to do all of the heavy lifting and let Excel take care of displaying the data. So with the help of Python and Windows Task Scheduler, we automated the entire process of gathering our data, cleaning it, saving the results, and refreshing the Excel reports.