the below dashboard image to analyse the following audit planning

Part 1 Audit Planning For audit-planning purposes, you need to open the US Superstore data file and brainstorm ideas to develop various data visualisations or dashboards. Investigate what the data are telling you. For instance, what are some interesting facts about the data that might be of importance for the forthcoming audit? The partner on the engagement, Daniel Denali, has asked you to look into the location of sales, returns, discounts, and related-party transactions. There seem to be issues with the high number of returns for certain products and with discounts provided to customers. Required: 1. Prepare visualisations with one dimension and at least one dashboard (related dimensions) concerning these issues. Specically, develop visualisation for 1) Sales trends; 2) Returns by Customer and 3) Discounts to Customers. (Note: A dashboard consists of two or more related visualisations.) Also, attempt to identify from your dashboards any potential risk areas for the upcoming audit. 2. Discuss one of the dashboards in detail and explain its importance to the audit. 3. Identify the nancial statement assertions that need to be focused on in the upcoming audit for revenue transactions. Entire View go Dashboard Layout Sales Trend Default Phone Device Preview ize BOK Desktop Browser (1000 x 8... . OW o GOK Sheets Sales Sales Trend 40K 1 Returns by custom.. Discounts by custo... Location 20K Slow moving product ill Cutt-off OK di Related-party 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month of Order Date For lines (discrete) Returns by customers Discounts by customers 1 date Order Date Customer Name 0 or more Dimensi Product Name Order ID (Returns) 2014 Rick Wilson 1 or more Measure 1.7 Cubic Foot Com.. Null 9160 Mike Pelletier 3-ring staple pack Null 9 Brenda Bowman 3.6 Cubic Foot Cou.. Null 2,711 Thomas Seio 3D Systems Cube P.. Null 5,200 Noel Staavos 3D Systems Cube P.. Null 1,040 Keith Dawkins Objects 3M Hangers With .. Null 34 Tamara Willingham Web Page 156 Horizontal 3M Office Air Clea.. Null Dianna Wilson 3M Organizer Strips Null 64 Steve Chapman Vertical Blank 3M Polarizing Task.. Null 1,096 Jennifer Braxton Text Button 6" Cubicle Wall Clo.. Null 42 Damala Kotsonis Image Extension 9-3/4 Diameter Ro.. Null 165 Suzanne McNair 12 Colored Short P.. Null 8 Ricardo Sperren 12-1/2 Diameter R.. Null 256 - .. . Tiled Floating 14-7/8 x 11 Blue B.. Null 327 0.0 0.2 0.4 0.6 0.8 1.0 Show dashboard title Discount Data Source Sales Trend Returns by customers Discounts by customers Location # Q1 Dashboard Slow moving product Cutt-off Related-party