h. Identify the financial statement assertions that need to be focused on in the upcoming audit forrevenue transactions (Refer to the discussion in Chapter 7, page 276). In your analysis, you willneed...

h. Identify the financial statement assertions that need to be focused on in the upcoming audit forrevenue transactions (Refer to the discussion in Chapter 7, page 276). In your analysis, you willneed to join the three files. To combine data files in Tableau, the data files must have the sameunique primary key; for example, in the US Superstore data, one primary key is ‘‘Region’’ that willlink the ‘‘Orders’’ data file with ‘‘People.’’ Appendix B (How to Import Data to Tableau) providesadditional details. 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 analyzed.For example, a data file might include fields or cells that have no data but should contain data, ordata entries that include spelling errors. To analyze a file with missing or incorrect data often resultsin unreliable results. For the US Superstore case, the data have been scrubbed and all cells or fieldscontain the proper data to be analyzed.


Part 3—Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-riskarea for most audit engagements (PCAOB 2014), you will utilize Tableau to create data visualizations anddashboards for various aspects of the audit of US Superstore’s revenue (order to cash) cycle and relatedaccounts. For the following issues, first, brainstorm in your group to develop questions that you need toevaluate with Tableau, and second, prepare the necessary data visualizations related to the following issuesand questions you developed. (Refer to Chapter 7, Revenue and Collection Cycle). Your engagementpartner 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-off issues?(3) Are there any indicators of related-party transactions?


Those are the only question that I need answer from