This is Part 2 of your group assignment, which consists of three sections.
Section 1: 2% of total grade (submit individually through a separate link on eClass)
After you have completed the short videos. Go to the York U website: https://lil.info.yorku.ca and click on the icon LinkedInLearning. You will need your passport account to sign in. Once you are in the LinkedIn training website, use the Browse function to search for ‘‘Tableau Essential Training 2021’’. You will see the course by Curt Frye. June 2021.
Review the following videos, answer the related questions, and provide copies of the requested screenshots
Questions/Screenshots:
Chapter 1: Introduction to Tableau
“Introduce Tableau File Types”
Q1: What are the five key Tableau file types discussed in this video and what does each file do?
Chapter 2: Managing Data Sources and Visualization
‘‘Connect to a data sources’’
Q2: What are the key steps discussed in this video to connect to an excel spreadsheet?
S1: Screenshot: Sales by job title visualization
‘‘Joining Related Data Sources’’
Q3: What are the key steps discussed in this video to bring data from related tables in Tableau and connect those tables using fields they have in common?
S2: Screenshot: Customers, Orders, and Products (Join Examples) before the speaker moves onto sheet 1
“Present data using the story line feature”
Q4: What are the key steps discussed in this video to create and navigate in story points?
S3: Screenshot: January 2021 Summary Storyline , showing the visualization of monthly sales since January 2019
‘‘Reorder Fields in a Visualization’’
Q5: What are the steps to reorder and reorganize the fields within your visualization?
S4: Screenshot: table showing by Product name and by Sales region
‘‘Change the Summary Operation’’ —for example, to get daily/weekly/monthly/etc. and averages vs. totals
Q6: What are the steps to change a visualization summary operation?
S5: Screenshot: Average sales by product and sales region.
Chapter 4 Creating Custom Calculations and Fields
“Create a Calculated Field”
Q7: What are the steps to create a new calculated field?
S6: Screenshot - Average Sales by Sales Region
You are to submit a word file individually through a separate link provided on eClass.
Section # 2 and #3 (Group Submission) 11% of total course grade
Section 2:
TechWear case continued:
Assume that one year has passed and it is now time to begin the 2016 audit. TechWear’s business has continued to expand. Our initial analysis of 2016 data indicates a much greater risk in accounts receivable (compared with 2015). When the audit team discussed this with company management, we were reminded that last year’s accounts receivable proved to be fully collectible, and we were assured that this year accounts receivable would also prove to be fully collectible as well. Management indicated that, similar to 2015, there have been no product returns or accounts written off in 2016.
The senior has asked you to assist with planning the 2016 audit, beginning with the order-to-cash cycle, by focusing on accounts receivable and sales. In particular, she has provided you with the following key audit assertions that need to be addressed:
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
