Would anyone provide assistance with the tableau assignment data to get the following answers?
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. Note 2: A concern in data analytics is whether the data need to be cleansed or scrubbed. Such cleansing or scrubbing of an entity's data might be required before the data can be analysed. For example, a data le might include elds or cells that have no data but should contain data, or data entries that include spelling errors. To analyse a le with missing or incorrect data oen results in unreliable results. For the US Superstore case, the data have been scrubbed and all cells or elds contain the proper data to be analysed. Part 2 - Substantive Testing of the Revenue (Order to Cash) Cycle As revenue is considered a high-risk area for most audit engagements, you will utilize Tableau to create data visualisations and dashboards for various aspects of the audit of US Superstore's revenue (order to cash) cycle and related accounts. Required: Your engagement partner provided the following initial substantive testing issues to your team that need to be evaluated: 1. Are there any indicators of slow-moving product? 2- Are there any indications of cut-o' issues? 3- Are there any indicators of related-party transactions? 4. Which customers should receive conrmations? 5- Are there any issues or concerns with discounts and cash receipts? 6. What is the Accounts Receivable (AIR) 1281 (31 December) balance for each year? Are there concerns as to the quality of US Superstore's accounts receivable? Are there any indicators that inventory might be overvalued? What are shipping costs per region or product? 53?\" For the above issues, rst, brainstorm to develop questions that you need to evaluate with Tableau, and second, prepare the necessary data visualisations related to the issues and discuss them in your report to the partner