Introduction: ·Brief explanation of what CNL/CNLR is - focus of our work. ·Why we choose Esri's Business Analyst to begin our newly formed GIS Dept ·Basics of what we do with the product and how the functionality in Business Analyst is used in essentially all project work that we conduct. In Depth Examples: ·Bed Bath and Beyond Challenge: Bed Bath and Beyond (BBB) wanted to enter new markets. Our challenge was to identify those markets and find sites. Procedure: 1. Identify all existing BBB locations in the US. 2. Intersect these locations with an MSA coverage to easily determine where they were and were not. 3. Of the top 25 MSAs, BBB was not in two markets so we focused our attention on finding suitable sites in those markets - Milwaukee and Cincinnati. 4. We knew that BBB liked to be located near a major mall and that they had two base demographic requirements. Therefore we mapped the major malls in these markets and generated a 5 mile ring around each to determine the most likely candidates based on the two demos. 5. It was clear that some trade areas were more suitable than others and this is where the field team concentrated it's efforts to find sites. ·TENBOT "Ten" - refers to the potential tenants and "Bot" is a reference to the automated routines imbedded in this application. The product operates as follows: 1. An electronic file (dbase, Excel) of potential sites (or vacant sites in search of users) is geocoded into the system using the Business Analyst store setup. The file must contain address information including street, city, state and zip. 2. The Business Analyst wizard guides the user through the creation of 3 and 10 mile rings around each site and demographics are extracted. A 3 mile ring is used to represent convenience markets such as Autozone, Costco, Grocery, and Pep Boys. A 10 mile ring is used to represent destination markets such Barnes & Noble, Bed Bath and Beyond, Best Buy, Home Depot, Michaels, Pier 1, etc. 3. The Business Analyst report function is used to generate a new ArcView table for the demographics contained within the 3 and 10 mile ring for each site 4. The ArcView table in dbase format is then brought into excel and the model is run. 5. The model results are reported in excel and include a yes/no answer as to whether or not the site can support a Barnes & Noble, Autozone, etc and then reports the closest analog store if the specified concept received a "yes" answer. The "yes/no" is based on a set of primary demographic variables (Pop, households, pop growth, household growth, ages, and income). The median was calculated for each of these variables on a sample of 100 stores for each concept. A threshold was set at roughly on-half the median. A new site has to meet the threshold for all variables to receive a "yes". 6. This is where the next phase of the model comes in. We anticipate using ArcView Business Analyst further to identify and include competition, existing store locations and traffic counts to further refine the model. ·Eckerd Orlando Challenge: Identify trade areas for Eckerd development. (I am currently working on this project but it would go as follows) 1. Identify the location of all Eckerds and Walgreens in the Orlando MSA 2. Identify the intersections of all primary and secondary roads 3. Generate a 1 mile ring around each intersection (using Business Analyst) - determine if and Eckerd or Walgreen already exists within this market - if so, exclude. 4. Intersect each 1 mile ring with traffic count layer to determine if traffic counts surrounding proposed area would meet Eckerd standards - if not, exclude. 5. Look at demographics of all remaining intersections - if they meet Eckerd requirements determine if local area zoning is suitable - also view aerial photo. If intersection meets all requirements suggest for field analysis. 6. I also will generate Theissen polygons around each Eckerd and Walgreen in an attempt to determine under-served trade areas. ·Own Orlando Challenge: Collect as much data as possible and work to understand the Orlando market. This is another on-going project. We have collected county data, to some degree city data, aerials, malls, traffic counts, major intersections, etc. for all of Orlando. I could briefly talk about this project and how we hope to use public data sources (zoning/landuse/imagery) as a catalyst for Business (where to look, etc.)