Provide a description of the relationship you expected to observe in the data, along with screenshots of the visualization results. Clearly identify the part of the visualization that leads you to believe that a specific location/day is an anomaly.

Project 1: Memo Template I

Souper Bowl Inc.—December 31, 2016 Disaggregated Revenue Analytics

Purpose: The purpose of this memo is to document
[Provide the purpose of the memo]

Data: We obtained a listing of daily sales by location from the client’s IT system. We tested the details for mathematical accuracy, as summarized in the table below:
[Present Table(s)/Graph(s)]

Procedures: Based on our risk assessment process, we identified the following assertions as significant risks related to revenues/sales:
[Create a bulleted list of assertions]
[Provide support for the assertions in the bullet list]

The analytics that we performed are as follows:

• Visualization Analysis #1: Title: [Provide a title]
• [Provide a description of the relationship you expected to observe in the data, along with screenshots of the visualization results. Clearly identify (using circles, arrows, etc.) the part of the visualization that leads you to believe that a specific location/day is an anomaly. Ensure that all tables and graphics are properly labeled (x axis, y axis, etc.)]
• Results:
• [In each of the “Results” sections, include a brief summary of your findings so that your manager can see (in words) the way that you interpret the visualization screenshots.]

• Visualization Analysis #2: Title: [Provide a title]
• Results:
• [The number of analyses that you perform is up to you. Remember that you want to impress your manager, but you also know that the manager’s time is valuable. Therefore, each analysis that you report should offer new information and conclusions (e.g., avoid repeating the same type of analysis with different coloring, shapes, etc., if the conclusions drawn are the same.)]

Conclusion: Based on the procedures described above, the audit team will pull supporting sales information to substantively test transactions from the following
locations and days:
• [This section of the memo can be achieved by using lists or tables, but regardless of the style of presentation, it should clearly describe which item(s) you are recommending that the audit team look into further (based on all the analyses above). For each item, you should reference which analysis # the item comes from. The item should be a specific location on a specific day, or a sample of certain days from a set of observations that exhibit the same unusual trend based on your analyses above (e.g., if you identify an unusual relationship for Q4 for location #1001, but you cannot identify one specific day or set of days that is driving the unusual relationship, you may choose to sample from Q4 instead). Remember that it takes time and resources to test
each selection, so be strategic in your selections and include justification for your decisions in this section of the memo.]