DataViva / dataviva-etl

Extract / Transform / Load Scripts for databases used in Dataviva Project
24 stars 10 forks source link

Check Data Secex 4: Dataviva x Dataviva #5

Closed mariohmol closed 10 years ago

mariohmol commented 10 years ago

Process to check data from Dataviva to Dataviva, that means, all desagregated values are matching the agregated values?

We were calling this process as "sanity check"

Define process, develop script and make a documentation.

mariohmol commented 10 years ago

Elton, please check the analysis about the indicators.

We are making some docs in https://github.com/DataViva/datavivaetl/wiki/Exportacao

eltonfreitas commented 10 years ago

Mol,

ECI: for all exports regions and all years; (-...;+...) in general, (-3;+3)

Diversity (HS / WLD / BRA): too for Ocupations (CBO) and ISIC; >=0

Val_usd: for all HS; >= 0

Growth's: for val_usd, number of employes, wage; (-...,+...)

RCA: For all HS and all locations; >=0

Distance: For all HS and all locations; (0;1)

Opportunity: For all HS and all locations; (-...;+...) in general, (-3;+3)

PCI: For all HS; (-...;+...) in general, (-3;+3)

mariohmol commented 10 years ago

Scripts done and first report after running: