Excel Dashboard:
As you have seen my dashboard in my previous posts.Now i have completed my project ..and i going to upload that...before uploading i am telling what the major things i have done in my project.
1) Filtering: As i told to you that my project ,contains RAW data of various indicators of different countries with respective to their years(200-2012) . Therefore,I have divided my data into various fields,firstly countries are divided into continent wise such as Asia, Europe, Africa, Australia, America. The buttons are provided on the above of the dashboard you can go specific continent and choose the country that comes under into the respective continent. Data will fetched automatically from reference sheet and all the previously data will be eliminate and new data will insert into the dashboard and various charts will be created.
2) Prediction: So prediction has been done through the various formulas.As i have given with only data till 2012.So i going to calculate for 3 upcoming years. Lets see how did I calculated this:
let I have two values of last two years of any indicator.
Let In 2011--value1 and 2012--value2
so value in 2013=((((value2-value1) /value1)*value2)+value2)
Similarly, for next coming two years same formula will be applied .....and .....value will be calculated.
3) Profit Calculations: For example, GDP is most important component of every country and is refleted by some factors like services ,industry import and export of goods .So which is better of a country is calculated.
As you can see in above picture, we are in Australia continent and in Turkey country,through calculations we have figure out that in Turkey services gives the maximum GDP.
For Download this file go to my next POST: check out MS-Excel categories.
For any Excel project Contact: gaurav_pundir@outlook.com
As you have seen my dashboard in my previous posts.Now i have completed my project ..and i going to upload that...before uploading i am telling what the major things i have done in my project.
1) Filtering: As i told to you that my project ,contains RAW data of various indicators of different countries with respective to their years(200-2012) . Therefore,I have divided my data into various fields,firstly countries are divided into continent wise such as Asia, Europe, Africa, Australia, America. The buttons are provided on the above of the dashboard you can go specific continent and choose the country that comes under into the respective continent. Data will fetched automatically from reference sheet and all the previously data will be eliminate and new data will insert into the dashboard and various charts will be created.
2) Prediction: So prediction has been done through the various formulas.As i have given with only data till 2012.So i going to calculate for 3 upcoming years. Lets see how did I calculated this:
let I have two values of last two years of any indicator.
Let In 2011--value1 and 2012--value2
so value in 2013=((((value2-value1) /value1)*value2)+value2)
Similarly, for next coming two years same formula will be applied .....and .....value will be calculated.
3) Profit Calculations: For example, GDP is most important component of every country and is refleted by some factors like services ,industry import and export of goods .So which is better of a country is calculated.
For Download this file go to my next POST: check out MS-Excel categories.
For any Excel project Contact: gaurav_pundir@outlook.com
No comments:
Post a Comment