|
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.
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.
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)
|