Skip to main content

Supported Data Sources

Updated

A data source is the starting point for all you do in Harmoni. A source is a collection of data either in an imported file or a connected data store. Harmoni supports both imported and connected data sources. Learn about the file type options and connections available.

    Tags:
  • Project Owner
  • Creator


LightBulb_WhiteOnTealBG.svg

A project contains one or more data sources.

 

In this article

  1. Data Sources in Harmoni
  2. Imported Data Sources
  3. Direct Connections (APIs)

 

1. Data Sources in Harmoni

Harmoni is designed for market research data. It works best with record level data where it can count the records satisfying specific conditions. A record can represent anything, for example:

  • A respondent’s responses, where Harmoni counts the records that satisfy the conditions such as Gender = Female
  • A drinking occasion event, where Harmoni counts the records that satisfy a condition such as Brand = Lipton, Day = Saturday, etc.
  • An individual Item sold, where Harmoni counts the records that satisfy a condition such as Brand = Goodsole, Type: Sneaker, Size = 39, Channel = Department Store, etc.

Harmoni can report data whose records contain a value that needs to be summed or averaged when reported, requiring a measurement value to be chosen and applied as a measure.  For example,

  • A day of weather, where we may filter by variables such as Month, and sum values such as Rainfall
  • A retailer’s aggregated sales, where we may filter by variables such as Region, and sum the sales value or volume.

Harmoni can also report non-additive data, such as pre-calculated percentages like share of voice. Such data may typically have specific requirements and it is important to discuss this with your Harmoni representative.

Harmoni can use sources in any language, including languages requiring multi-byte storage (e.g., traditional Chinese).

Harmoni automatically maps source variables into Harmoni types when data sources contain an inherent dictionary. A dictionary contains meta-data to guide interpretation. Variables in sources without an inherent dictionary need to be defined. 

 

2. Imported Data Sources (Upload)

Files imported into Harmoni capture data for a moment in time. 

 

Source Type Description Source Dictionary

SPSS data
  • SPSS.sav format
  • Can be generated from a variety of data collection applications
  • Typically contain record-level data 
    with a record representing a respondent
Contains an inherent source dictionary

Excel files
  • XLSX – Excel files
  • Primarily created from Excel in Office 2007+
  • Files must be XLXS
 Needs to be defined

Comma-delimited
  • CSV files
  • Can be generated from a variety of systems
  • Do not have market research-specific structures
 Needs to be defined

Tab-delimited
  • TXT files.
  • Can be generated from a variety of systems.
  • Do not have market research-specific structures.
 Needs to be defined

Dimensions data
  • Dimensions .mdd and .ddf format.
  • Typically created by Dimensions.
  • Typically contain record-level data 
    with a record representing a respondent.
Contains an inherent source dictionary

 

3. Direct Connections to Harmoni (Connect)

Direct connections allow updated data to flow into Harmoni in real time.

  • Achieved using APIs (Application Programming Interface).
  • If an API is available in a data collection system, we can potentially develop a direct connection to Harmoni.

Harmoni currently supports direct connections to:

 

DirectConnection_17Nov23.png

 

Where to from here?

Up_Arrow.png

Related to

Related articles