Clients/Projects  

Welcome/What's New

Products and Services                     
   Utility Customer Databases
   Other Data Products
   Models and Forecasting
         Energy
         Technologies
         Marketing/Sales
   Market Analysis
   Revenue & Cost Management
   Business Consulting

Industries
   Electric / Natural Gas
   Energy Technologies
   Energy Service (ESCO)

Other
   Jackson Associates
   Clients
   White Papers
   Demos
   Pricing/Orders
   e-mail

2007 Database Updates Now Available !

2007 commercial, industrial, and residential databases are now available. These updates include new information on utility customers in each utility service area, state and province. Extensions include:

  • Utility customer energy use and population characteristics as of January 1, 2007.

  • Additional optional commercial business detail

  • Updated 8760 hourly loads for each database record

  • Other Refinements based on new data sources

MAISY Utility Customer Databases

MAISY (Market Analysis and Information System) Databases have been developed from information on more than 1 million individual utility customers throughout the US and Canada, providing a representative sample of residential, commercial and industrial customers for utility service areas, states and provinces. Large customer samples within states and service areas maintain the diversity of actual customer populations, providing a more accurate analysis of customers, markets and market segments compared to "average" customer information. (for more information on this topic see MAISY Individual Customer-Based Hourly Loads Data Avoids Pitfalls Associated With Predefined Prototype and Average Segment Loads).

MAISY Utility Customer Databases include energy use, hourly loads, building, equipment, operating, occupant and other energy-related information for individual commercial , industrial and residential customers records including 8760 hourly loads for individual end uses.

MAISY Utility Customer Database Characteristics Summary

Individual Customer Data Geographic Detail
  • Industrial Customer Records
  • Commercial Customer Records
  • Residential Customer Records
Detailed Energy Use Information Customer Evaluation Options
  • Standard Customer Types
  • User-Specified Customer Types
  • User-Specified Customer Segments
Other Customer Data Market Evaluation Options
  • Industrial - SIC, Employees, Op Hours, etc.
  • Commercial - SIC, Business Type, Employees, Op Hours, etc.
  • Residential - Income, Demographics, Householder Age, etc.
  • Com & Res - Building Structure, Equipment Detail, etc.
  • Standard Market Segments
  • User-Specified Market Segments
Software Analysis and Data Access Capabilities
  • MAISY patented basic database graphical user interface software with point-and-click data evaluation and exploration

MAISY Customer Data

MAISY Utility Customer Databases have expanded considerably since their introduction in 1995. The first databases included survey data from 15,000 customers providing only regional detail and annual energy use characteristics. Current databases have been developed with information from more than one million individual utility customers records throughout the US and Canada providing geographic detail down to individual service areas and energy use detail to 8760 hourly loads with end use detail. Hundreds of data sources are used to develop the utility customer databases. MAISY Databases are widely recognized as the most authoritative source of utility customer energy use information available and have been used by utilities, energy service providers, energy service companies, equipment manufacturers, research organizations and other organizations interested in utility customer energy use. MAISY data have also been used to support appliance and equipment efficiency standards development undertaken for the US Department of Energy.

MAISY Databases provide up-to-date information on industrial, commercial and residential customers, customer segments and market segments in each state and utility service area market. Databases reflect information from hundreds of different customer and market data sources including onsite customer surveys, utility and fuel supplier billing data, government, association and proprietary data, and other sources including ongoing Jackson Associates customer data development. Databases are continuously updated to reflect important recent trends in the most important determinants of residential, commercial and industrial energy use.

MAISY Databases are scalable; that is, any subset of customer variables or geographic areas can be extracted from the full databases and provided to clients in customer database development.

Customer-detailed information includes energy use, 8760 hourly loads, building, equipment, operating, occupant, other energy-related information for each commercial , industrial and residential customers record. The following links document database variables included in the Commercial, Industrial and Residential MAISY databases in more detail:
List of Commercial Database Variables
List of Industrial Database Variables
List of Residential Database Variables

Accessing MAISY Customer Information

MAISY Databases Software applies a patented data exploration process to answer specific questions with mouse-clicks on charts and permit users to navigate state and utility databases, exploring customer characteristics and relationships. Information can be viewed in chart or table form at any level of aggregation ranging from an individual customer to all customers in a service area, state or province. MAISY provides detailed reports and exports data to other software systems. The software runs from desktop or network systems.

Exporting Customer and Hourly Load Data From MAISY

All customer and hourly load data can be exported from MAISY systems into into comma-delimited files (CSV) which can be read by Excel and nearly all other data-related software.

Be Sure to View Other MAISY Data Products

If you only need a subset of the data or are interested in products frequently requested by our clients and now provided as standard data products be sure to visit the Other Data Products part of our Web site.

Individual Customer Characteristics Versus "Prototype or Typical" Load Profiles

The MAISY system permits users to select individual customers or customer segments based on dozens or even on hundreds of customer characteristics. Pick any combination of business type, floor space, operating schedules, space heating fuel, year of construction and many other variables to zero in on a specific customer type or market segment.

What about other load-profiling systems that offer 12, 36 , 75 or some other limited number of fixed customer segments? To represent 13 commercial business types; electric, gas and oil heat; small, medium and large buildings requires 117 prototypes or "typical" buildings. Add in age categories and more than 200 "fixed prototypes" would be required, well beyond the scope of these "fixed" systems. With MAISY, customer and segment selections provide hundreds of possible definitions with nearly unlimited choices of customer characteristics. Only MAISY provides the detail and flexibility required to reflect the extensive customer and segment detail required in competitive markets.

Relying on "prototype and typical" is similar to analyzing a "typical" family which consists of two adults and 0.6 children - it may reflect an average but it may also provide misleading results when used to understand customers, to develop programs to fit the needs of individual customer segments or to evaluate the profitability of serving these customers.

Sources of load profile data which rely on fixed customer segments (e.g. large, medium and small offices) typically develop hourly load data with engineering models (e.g., DOE2) of a single "prototype" building. The aggregate nature of these representations misses the variation that exists among individual buildings within these segments, hiding important market information. For instance, a particular electric rate structure may provide a competitive profit based on an entire segment's single prototype load profile; however, analysis of subsets of the segment (which can be performed with MAISY but not with the "prototype or typical" load profile approach) may reveal significant diversity in profit levels across customer sub-segments such that some customers are provided power at a loss while profit margins on other customers result in cream-skimming targets for other suppliers.

(For more information on this topic see MAISY Individual Customer-Based Hourly Loads Data Avoids Pitfalls Associated With Predefined Prototype and Average Segment Loads)

(c) 2007 Jerry Jackson. All rights reserved.