Yippee! This is my second post, and as I care a lot about my descendants, I think that it’s important to know if after centuries some countries will be crowded with people, and if my descendants will have a place to live on earth and especially in Russia, that why I chose to write an article about Russian population projection for 300 years.
I didn't have a chance to live in Russia, and to see the Kremlin, but I think that some of my descendants will live there, that why I chose Russia for this article :)
To do the projection, I used the data mining engine that is encompassed in SQL Server Analysis Services, I used the Time Series algorithm to do the forecasting.
To train the data mining model, I used only some few data that I listed below, I know that is not enough in order to have accurate results, but I didn’t find raw data that are ready to use (like a csv file).
I didn't have a chance to live in Russia, and to see the Kremlin, but I think that some of my descendants will live there, that why I chose Russia for this article :)
To do the projection, I used the data mining engine that is encompassed in SQL Server Analysis Services, I used the Time Series algorithm to do the forecasting.
To train the data mining model, I used only some few data that I listed below, I know that is not enough in order to have accurate results, but I didn’t find raw data that are ready to use (like a csv file).
Russian population:
1965 - 126.74 Million
1970 - 130.40 Million
1975 - 134.20 Million
1980 - 139.01 Million
1985 - 143.85 Million
1990 - 148.29 Million
1995 - 148.14 Million
2000 - 146.30 Million
2005 - 143.15 Million
2010 - 141.92 Million
As result, in 2314 the Russia population will be 225 Million, this is a good news, for such a big country like Russia, a population of 225 Millions is acceptable.
This is just an article that could help some developers to use the Time Series algorithm, I'm sure that after 300 years the Russian population will not be 225 Millions, because I didn't take in consideration external factors like climate changes, economy,...
Here you can find the DMX script that I used BI4Fun_RussiaPopulationForecasting.dmx, and below a screenshot of the output I got in SSMS.
This is just an article that could help some developers to use the Time Series algorithm, I'm sure that after 300 years the Russian population will not be 225 Millions, because I didn't take in consideration external factors like climate changes, economy,...
Here you can find the DMX script that I used BI4Fun_RussiaPopulationForecasting.dmx, and below a screenshot of the output I got in SSMS.
No comments:
Post a Comment