Customer Demographic Comparison Report (Business Analyst)

Summary

Compares the demographic profiles of two customer files and reports on the differences.

Usage

Syntax

CustomerDemographicComparisonReport_ba (CustomerLayer, InputBoundaryLayer, InputGeographyLayer, InputFieldsToProfile, ReportTitle, OutputFolder, UseSelectedCustomers, {UseSecondCustomerLayer}, {SecondCustomerLayer}, {UseSelectedCustomersSelectedLayer}, {ReportStyle}, {ReportFormats})
ParameterExplanationData Type
CustomerLayer

Select the primary customer layer to analyze.

Feature Layer
InputBoundaryLayer

The boundary file that defines the extent of the customers to be analyzed.

Feature Layer
InputGeographyLayer

The input feature layer that contains the data that can be selected to be compared in the report. This will commonly be the Block Groups.

Feature Layer
InputFieldsToProfile
[InputFieldsToProfile,...]

Select from a list of available variables to compare. These variables are typically demographic variables.

Field
ReportTitle

Enter the name of the report.

String
OutputFolder

The file folder output path.

Folder
UseSelectedCustomers

Select this option to compare the first Customer Layer against selected features of that same layer in the report.

  • TRUESelected features of the first Customer Layer are used in the comparison report.
  • FALSESelected features of the first Customer Layer will be not be used in the comparison report. A second customer layer will be selected and used for the comparison. tThis is the default.
Boolean
UseSecondCustomerLayer
(Optional)

Select this option to compare the first Customer Layer with this layer in the report.

  • TRUEA second customer layer is used in the comparison report.
  • FALSESelected features of the first Customer Layer will be used in the comparison report. This is the default.
Boolean
SecondCustomerLayer
(Optional)

The second customer layer used in the comparison report.

Feature Layer
UseSelectedCustomersSelectedLayer
(Optional)

Select this option to compare the first Customer Layer with selected features of the second Customer Layer in the report.

  • TRUESelected features of the second Customer Layer are used in the comparison report against the first Customer Layer.
  • FALSESelected features of the second Customer Layer will be not be used in the comparison report. The entire second customer layer will be used for the comparison. This is the default.
Boolean
ReportStyle
(Optional)

The report style for your reports.

  • ScreenThis report format will display a modern look and feel using a more visually pleasing format.
  • PaperThis report format will display a classic look and feel using a more generic style.
String
ReportFormats
(Optional)

Select the desired report output format.

  • Simple XML
  • PDF
  • HTML
  • CSV
  • ZIP
  • XLSV
  • Stripped XLSX
String

Code Sample

CustomerDemographicComparisonReport Example (Stand-alone Script)
# Name: CustomerDemographicComparisonReport.py
# Description: Compares the current year total population and future year total population on selected customers from the San Francisco customer layer against the balance of that customer layer.
# Author: ESRI

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox("C:\Program Files\ArcGIS\Desktop10.0\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
# Acquire extension license 
arcpy.CheckOutExtension("Business") 
     
# Define input and output parameters for the Customer Demographic Comparison Report tool
Cust1 = "C:/My Output Data/Projects/Default Project/CustLayers/sf_custs/CustomerLayer1.shp"
Extent = "C:/My Output Data/Projects/Default Project/TradeAreas/Customer_Derived_TradeAreas.shp"
Geog = "C:/Program Files/ArcGIS/Business Analyst/Data/BDS/esri_bg.bds"   
Vars = "TOTPOP_CY;TOTPOP_FY"
ReportName = "Customer_Demo_Report"
ReportDir = "C:/My Output Data/Projects/Default Project/Reports/Customer Demographic Comparison Report"
   
	   	   
# Create the Customer Demographic Comparison Report
arcpy.CustomerDemographicComparisonReport_ba(sCust, false, true, #, sExtent, sGeog, sVars, sReportName, sReportDir)
 
# Release extension license 
arcpy.CheckInExtension("Business")
 
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments

Related Topics

Licensing Information

ArcView: Requires Business Analyst
ArcEditor: Requires Business Analyst
ArcInfo: Requires Business Analyst

11/8/2010