In this case, the students help automate the creation of sales reports for Pure Guitar Inc. The case requirements include the completion of the overview case first. We strongly suggest this, although the case can be completed without this requirement. This case does not require the completion of the billing and tax form preparation cases, although the skills learned in those cases will be beneficial to complete this case. Students are required to generate this report in Microsoft Word with the information segregated by employee and by quarter and displayed using an Excel bar chart. Students will use the data from two .csv files and an Access database. Students will also be encouraged to utilize two additional UiPath packages to make the automation tasks easier (interaction with Microsoft Word (UiPath.Word.Activities) and the creation of a bar chart in Excel (BalaReva.Excel.Activities)).

Suitable courses: AIS, Data Analytics

Link to download files (requires login)