Description

• Using the 2 csv files you have been provided, complete data transformations and visualizations in PowerBI using the below instructions.

PowerBI Code Test

1. Add step(s) to remove all blank values from the NAISC CODES dataset
2. Add step(s) to only keep data in the NAISC CODES table where the CODE is 2 characters
3. Remove these entries in the NAICS DATA table for the ENTERPRISE EMPLOYMENT SIZE:
   1. 01: Total
   2. 05: <20
   3. 08: <500
4. Setup an inner join between the NAISC CODES.CODE and NAISC DATA.NAICS CODE columns
5. Create visualizations/KPIs however you would like in order to answer the following questions. Consider what you would create knowing that you would have to present this report tab to a client.
   1. Who are the top 5 states with largest number of firms?
   2. What is the average annual payroll for all states?
   3. Which NAICS DESCRIPTION has the most number of establishments?
   4. Order the ratio of the number of establishments to the number of firms descending in a horizontal bar chart by state.
   5. Group the count of the number of states by the employment noise flag in a visualization that is the easiest to read.
   6. Create a visualization and filter on ANNUAL PAYROLL NOISE FLAG only including values = H, showing information that based on your analysis would be useful to a stakeholder.
   7. Create a visualization using state data, showing information that based on your analysis would be useful to a stakeholder.