Difference between revisions of "Harmonized Data"

From dataZoa Wiki
Jump to: navigation, search
(Missing Values)
(Calculations)
Line 27: Line 27:
  
 
===== Calculations =====
 
===== Calculations =====
When
+
 
 +
In all [[calculations]], missing data has the highest precedence.  Specialized functions in the [[calculations|ComputeCloud]] can be used for specialized handling, such as carry-forward, etc.
  
 
===== Tables =====
 
===== Tables =====

Revision as of 12:13, 2 December 2016

Today's Web is filled with Open Data - hundreds of authoritative, original data sources, freely accessible to everyone.

Before dataZoa, the actual practice of using Open Data sources was time-consuming, messy and painful. A major portion of time was wasted on "data drudgery"; cleaning, aligning, pasting, re-typing and such. All before any real thought or analysis could begin.

As you bring data into dataZoa, it is harmonized (or "normalized") so that any series can work with any other. While we preserve all the original series documentation, we load the dates and values into an idealized time series. This automatically handles the specific nuances of time series data:

Date Handling

Frequency/Periodicity

http://docwiki.datazoa.com/Application_Conventions#Missing_Data_Values

Date Range

Gaps

Date Formats

Inputs
Outputs

Data Value Handling

Missing Values Handling

Calculations

In all calculations, missing data has the highest precedence. Specialized functions in the ComputeCloud can be used for specialized handling, such as carry-forward, etc.

Tables

By default, No Data (ND) formats as a blank, while NA, and NDD data are formatted with "NA" and "NDD", respectively. To fine tune these representations, see Displays.

Charts

Missing values are typically shown as gaps.

Look here for missing value formatting details.

Value Formatting