4 Replies Latest reply on Oct 1, 2018 10:55 PM by Sakshi Kaul

# Need answers to some of the basic questions

1. Rank the US states based on ‘Revenue USD’ – we need to see the top 10. What % of the revenue do they represent?
2. Which Auditor has the highest market share in terms of # of companies based on the attached data set
3. What are the top three most profitable NAICS Codes by Gross Profit?
4. List the top 5 companies by revenue according to Year Founded (Column CZ) (Use Pivot Table)
5. Calculate the average square footage for each company using the “Square Footage” column. For example if the square foot is given as “10,000 - 19,999”, then average will be 15,000 SF. (Use text to column) Where the square is given as just a number, take it as is.
6. Populate column “Combined Address” by combining the address in column C, E F, G & H, each separate by a “, ” – example “702 SW 8th St, Bentonville, Arkansas, Benton, United States”
7. Fill in the “Sig Number” in column B for each company from the sheet Sig Number – use a formula to do so
8. What is the average revenue per headcount, based on ‘Revenue USD’ for each company. Ignore companies where head count is not given. Add this as a column between ‘Sig Number’ and ‘Address’
• ###### 1. Re: Need answers to some of the basic questions

Hello Sakshi,

• ###### 2. Re: Need answers to some of the basic questions

This appears to be someone's homework!  Also, are you sure this is Tableau related, and not Excel based?

• ###### 3. Re: Need answers to some of the basic questions

Hi

I am not able to attach the requires excel file. Please help me how to share the same

• ###### 4. Re: Need answers to some of the basic questions

Hi

It's  tableau based questions and as I am a fresher and want to learn this technology so need help