Question: You should start and save a new Tableau file for each Chapter's assignment. Roger Company's files can be downloaded from Connect in Excel format. For

You should start and save a new Tableau file for each Chapter's assignment. Roger Company's files can be downloaded from Connect in Excel format. For Chapter 11, you will import the Roger Company accounts payable file. See Chapter 4 for instructions on how to import Excel files to Tableau. 1. Using the accounts payable file, name the first worksheet (tab) Vendor Balance. Add Invoice Amount and Vendor number to the plot, then sort in descending order. What vendor number has the largest AP balance? 2. Using your Vendor Balance analysis, click on Show Me to see how different formats can also provide clear takeaways. For example, click on the "treemap" format option. What color is vendor 10348400 and what does that mean (Hint: to see the treemap legend you may need to hide Show Me drop down screen)? 3. Using your Vendor Balance analysis: Try at least one more format in the Show Me tab and say which format you prefer the most
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
