Assessment Task

Using the “Excel File for Dashboard” on Moodle, you are required to carry out the tasks below and to create a dashboard that is the same as the screenshot provided, see figure 1.1 below.

i. Creation of table from dataset and named appropriately. Format the table appropriately, use attractive table style.

ii. Creation of SIX Pivot tables, named appropriately.

iii. Creation of Four Slicers and One Timeline.

i. Note 1: All slicers and timeline should affect all charts on the dashboard

ii. Note 2: The months should be done automatically from the date

The post B7IS113: Using the “Excel File for Dashboard” on Moodle, you are required to carry out the tasks below and to create a dashboard: Business Information Systems Assignment, DBS, Ireland appeared first on QQI Assignments.