Tampa Bay Surf Shop’s graphic designer is Tom Brady. Tom  do…

Tampa Bay Surf Shop’s graphic designer is Tom Brady. Tom  doesn’t have any accounting experience, and the prior CFO, Yash Patel, just won the Power Ball Lottery and was last seen sailing away in the distance on the new sailboat, “Barometer Soup”… Tom sat there with a small tear in his eye, partly for missing his friend, and partly because he’s been tasked with preparing the financial reports for the board of directors. Relying on his certificate from the Ocala School of Design and the built-in tools from their accounting software “Trick Books”, Tom prepared the cash flow visualization below as the first part of his board packet. Please read the visualization below and state the potential risks with this visual, what you would change, and why.    

2. You are performing ETL on the vendor master table. The ta…

2. You are performing ETL on the vendor master table. The table has several data issues. The transformed table will be used to analyze spend by commodity and state.   Required:  Describe the types of data issues and how you would correct them.   Explain how failing to correct these issues would distort the spend-by-state and spend-by-commodity analysis.   VendorID Address State Commodity Telephone 20211 245 Fleet St, Rockville MA Cleaning Supplies 240.243.2400 20212 14 First St, Rockville Maryland Office Equipment; Office Supplies   20213 3403 Main St, Rochester NY Beverages; Kitchen Supplies 585-450-9910 20214 3306 Second St, Buffalo New York Toys; Clothing; Household Goods 2995229 20215 341 Liberty St, Springfield N/A Cleaning Equipment 241.233.4111 … … … … …