by Sooria Jeyaraman
By now I’m sure you must have explored the new comparison reports in Business Analyst Online, if not I would strongly urge you to do so. It is one of our marquee features that some of our users are craving for. I will let you know some more tricks in the feature that will make your job easier. Hypothetical scenario – I am interested in a couple of locations near Mira mesa, San Diego. I want to know about the demographics of people living in 5, 10, 15 minute drive time of this location. I also want to know how these locations fare in comparison with its ZIP code, County and also benchmark it against my successful location in Redlands.
Hmmm.. how could I do this? Do I need to create all these as separate sites and get reports and add them manually in excel to compare!! No that’s when our new comparison reports come to your rescue. Let’s first create the two drive time sites.
Now go to “Get Reports” tab, click “Create Comparison Reports” and these two sites will be automatically selected in the site panel, add your successful Redlands site to it. These three sites will be shown in step 1 as sites selected.

On step 2 open the ZIP code dropdown, now that lists all the ZIP codes that your sites belong too (sweet huh!), select your desired ZIP code and now move on to the County dropdown which will list all the counties that your sites belong too, pick your interested county.
Now move on to step 3, an option to pick your benchmark. Open the dropdown and you can see all the sites selected, its respective geographies and not just that you have options to benchmark it against the “Average” and “Median” of your selected sites. Now for our walkthrough let’s pick your successful Redlands site.
On step 4 let’s say we are interested to look at the Income variables, go ahead and click the “Income” button. Here’s what you would get once you click the button in step 4.

You get an UI with the graphs with the benchmarked site as the first site and your selected sites with the ZIP code and county of your selection. It’ll be better if I explain each of the elements on this page one by one with highlights.
1. View toggle button lets you switch between this graph view and a tabular view where you can just look at the sites and variables in plain numbers in a table format.
2. Variables dropdown lets you select/deselect the variables you would like to be displayed in the graph/table.
3. Graph legend represents each variable and the bar color associated with it
4. Year toggle lets you see our five year projection for the selected variables.
5. Dropdowns below each site name lets you change the individual drive time to be displayed in the graph.
6. Finally you can also print and save the information in excel for further reference.
On the top you have tabs to switch between our other popular variables “Population” “Households” “Housing” and the last tab “Customize” lets you create your own set of variables – more on that in my next blog on the same subject, watch out.
Before you go, I would also suggest you to visit our friend and fellow blogger Kyle’s scribbling in his blog post about benchmark report in Business Analyst Desktop.
http://blogs.esri.com/Dev/blogs/businessanalyst/archive/2009/09/29/The-Fabulous-Benchmark-Report.aspx
Happy Comparing!
- SJ