Visualize the data with Tableau Case Prompt: Pixystems recently hired a new CFO who is focused on improving the financial performance of Pixystems

Visualize the data with Tableau

Case Prompt:

Pixystems recently hired a new CFO who is focused on improving the financial performance of Pixystems and improving operational efficiency in AP, payroll, inventory, and sales. She has challenged each of the managers of these business processes to identify areas for improvement and quickly address errors. Internal audit has also been working closely with the CFO, managers, and external auditors to identify control gaps, areas of non-compliance, and operational efficiencies.

The CFO has also engaged you to review these business processes using Pixystems’ data and performing analytics. She would like you to make any necessary recommendations, identify data issues, and provide her and the managers with insights gained through your analytics. You will work to leverage the data provided by Pixystems (see the Data Overview above for a high-level explanation of data provided) and information obtained from the CFO to identify areas for financial and operational improvement, address issues and errors found in processing or data, and confirm the information that the CFO shared with you.

To do this you will be assigned one process and must create 3-5 analytics that will assess the validity of data and provide the insight the CFO is looking for. You may also conduct at least 2 additional analytics that will add additional insight or that you feel would be of interest to the CFO, managers, or auditors.

The CFO is expecting that you have Tableau visualizations representing the analytical procedures you performed and assumptions you made.

You will prepare a final report outlining the following:

Results of the analytics you performed along with your rationale for performing and assumptions made (control, data error, operational peformance, etc.)

Insight that the analytics provided management

Explanation of any analytics you decided not to perform (optional)

Recommendations you have for improving Pixystems’ processes

Overview of any other issues that Pixystems should follow-up on

Recommendations on system controls that could be put in place

Any other data you would like to have obtained from Pixystems

Report Requirements:

1. Prepare the final report (your slide presentation) and answer the questions / address the “asks” in the above

2. Include an executive summary

3. Include 5 analytics (3 which should have a Tableau visual)

4. 6-8 slides total.

Documents:

3-Data-Analytics-Toy Case-Assignment.pdf

4-Data-Analytics-Toy Case-Data.xlsxDownload 4-Data-Analytics-Toy Case-Data.xlsx

5-Data-Analytics-Toy Case-Checkpoint-Spreadsheet.xlsx

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

KRYSTEL BERGHER PROFILE Accomplished Customer Service Expert committed to the delivery of quality service. Professional and Ethical.

KRYSTEL BERGHER PROFILE Accomplished Customer Service Expert committed to the delivery of quality service. Professional and Ethical. Seeking to assist or help a new customer service department in creating and achieving the much-needed customer service goals. CONTACT ADDRESS: 15851 Southwest 139th Place, Miami FL 33177. PHONE: 305-992-6010 EMAIL: [email protected] om

Business Law BUS 3301 VII Question 12 The principal agent relationship, the employer-employee relationship, and the employer-independent contractor

Business Law BUS 3301 VII Question 12 The principal agent relationship, the employer-employee relationship, and the employer-independent contractor relationship are three types of agency relationships commonly found in business settings. Why is it important for business professionals to know what type of agency relationship they are forming?   Your response must

pfa TASK 1: By Tuesday Evening Reflection and Discussion Forum Week 3

pfa TASK 1: By Tuesday Evening Reflection and Discussion Forum Week 3 Assigned Readings: Chapter 8. Understanding Markets and Industry Changes. Chapter 9. Market Structure and Long-Run Equilibrium. Chapter 10. Strategy: The Quest to Keep Profit from Eroding. Initial Postings: Read and reflect on the assigned readings for the week.