Tutorial: Sales report automation
In this tutorial, you will impersonate the role of a business analyst working for a UK-based online retailer, selling all-occasion gifts. You are intrigued by data analytics and are reading a few (good) books about its potential. You have set for yourself the ambition of progressively amplifying the role of data analytics in the company by leveraging your new skills. You decide to start from something relatively simple: automate and improve the reporting of sales data. By doing so, you want to make a quick and visible impact and instill an appetite for more advanced analytics in your colleagues and managers, unlocking interest and investments.
The company you work for has grown quickly and didn't have the opportunity to adopt a sustainable business intelligence solution. The regular reporting is managed manually using Excel. The poor finance analyst responsible for it pulls data from the company website every Friday and, after a couple of hours...
