Accounting Question

Overview

1. Review Lab 2-1 Request Data from IT – Slainte: Lab 2-1 is a conceptual lab. Share how you identify data that seemed likely to have been held back when their data request was fulfilled to answer the questions in part 2 of the lab. Share how you plan to use the knowledge you gain from this lab at your work/study. Lab 2-1 Data Request Form
2. Review Lab 2-2 Prepare Data for Analysis – Slainte: Lab 2-2 is an applied lab which provides you an opportunity to work with data stored across multiple tables in Excel. Lab 2-2 Slainte Dataset
   Part 1 prepare a data model:
   • • use Power Query in Excel to transform the data then load it to the Excel workbook. Share your results, experience and how you plan to use the knowledge gained at work/study.
   Part 2 validate the data:
   • • Create a PivotTable using the workbook’s data model to display the total number of each item sold each month between January and April 2020. Share your results, experience and how you plan to use the knowledge gained at work/study.