Thanks Walter
Here are a few tables I would like to be able to build at the OEC and DataUSA, which are two sites I know rather well. I am providing the goal of what we would like to have, but I understand that we may hit incomplete versions of this goal first. It is a rather ambitious goal. What I don't want is to have a false goal, because I've seen that sometimes at DW we stop at the first iteration, thinking that this is the end (and then we start reworking the software for that first step and never get to step 2).
At the OEC, I would love to be able to build the following tables
1.
Country | Year | ECI | GDP per capita | GDP per capita (Year + 10) | Population | Diversity | Total Exports | Growth of Exports Between Year and Year +10 | Natural Resource Exports
2.
Subnat 1 (E.g. autonomous communities in Spain, states in the US, Brazil. China, etc...) | Year | Product | ECI | PCI | Exports of subnat in that product-year | Exports of subnat in that product-year+10 | Relatedness of subnat in that product year | Relative relatedness of subnat in that product year | RCA of subnat in that product year
In DataUSA
County | Year | Obesity | Poverty | Income | Average Commute Times | Population Density | Average Age | Obesity (year + 5)
Let me know if these are clear.
From Cesar input:
Thanks Walter Here are a few tables I would like to be able to build at the OEC and DataUSA, which are two sites I know rather well. I am providing the goal of what we would like to have, but I understand that we may hit incomplete versions of this goal first. It is a rather ambitious goal. What I don't want is to have a false goal, because I've seen that sometimes at DW we stop at the first iteration, thinking that this is the end (and then we start reworking the software for that first step and never get to step 2). At the OEC, I would love to be able to build the following tables 1. Country | Year | ECI | GDP per capita | GDP per capita (Year + 10) | Population | Diversity | Total Exports | Growth of Exports Between Year and Year +10 | Natural Resource Exports 2. Subnat 1 (E.g. autonomous communities in Spain, states in the US, Brazil. China, etc...) | Year | Product | ECI | PCI | Exports of subnat in that product-year | Exports of subnat in that product-year+10 | Relatedness of subnat in that product year | Relative relatedness of subnat in that product year | RCA of subnat in that product year In DataUSA County | Year | Obesity | Poverty | Income | Average Commute Times | Population Density | Average Age | Obesity (year + 5) Let me know if these are clear.
Thanks!