How To: Obtain the total sales for businesses with a set amount of employees in the Business Analyst Web App
The business and facilities search in the Business Analyst Web App allow users to refine results according to their specifications to obtain specific businesses names, facilities, or types. The business and facilities search can also be used by businesses to obtain the total sales with a set amount of employees for a particular location.
This example describes the steps to obtain the sales volume for businesses with a set amount of employees by county.
Click the Maps tab.
Click Create Project to create a new project, or select an existing project.
In the Maps tab, click Define Areas for Reports > Select Geography > Select From Full List > Counties, and click Next.
Under Select State > Counties, click the Select drop-down arrow to select the desired state.
Check the box for the desired county and click Next > Done.
Go to the Maps tab again, click Create Maps from Data > Business and Facilities Search.
Type the desired business name, the business type, or both, in the Enter business/facility name or type box. Click More options.
In business and facilities search, users can type the NAICS-base code or SIC code if the name of the business name or type of business is unavailable or not known.
Under Search extent, click the Current map extent drop-down arrow and select the previously chosen desired county. Click Go.
Other settings can be changed as desired.
In the results window, scroll to the end and change the Number of Employees by dragging the arrows left and right to define the desired range. Click Next.
Change the drawing style by clicking the drop-down arrow to the desired drawing style. Click Save > Continue > Export to Excel > Done. The table containing all the required businesses data can be viewed in Microsoft Excel.