SQL INTRO

SQL stands for Structured Query Language. As you Know,we are just consulting with DBMS(Database Management System). As the name suggests that DBMS is to manage the data in somewhat manner so that the End or other users can have easily access to each and every information of data of entire database.
How is it all done?
SQL
SQL tells about how to create ,delete ,modify,concatenation ,division ,altering, manipulating the database.
Let's illustrate the all the commands  one by one in detail in coming posts.

Therefore to know about all commands and reading material, Just go to the page:

SQL COMPLETE REFERENCE 

Go To Home: Home

Excel Comparison Dashboard

Excel Comparison Dashboard:

This dashboard for made to compare between two countries with respective to their continent wise and also give you to the flexibility to choose indicator of your wish and compare them.
Tell about also which country is leading or which one is slumping with respective to chosen Indicator name.

 

Excel Sheet given in my Previous Post

For further information :

gaurav_pundir@outlook.com

Excel Dashboard-4

Excel Dashboard:

Here I giving you to a link of my excel sheet.Download it try to analyses what i have done ..how i am going to reference the data into the dashboard from the raw data.

 Download Excel Sheet From Given Link:

Click on Download:     Download

Please Give your feedback in comment section.
If you have any problem or making any other excel project you can contact to me:

gaurav_pundir@outlook.com or ranagrv@gmail.com
  

Excel Dashboard-3

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

Excel DashBoard-2

Excel Dashboard:

I have done a Excel project Topic Name: Analysis of various Indicators of Various countries as i told to you in previous post and i have told to you how to make the dashboards in excel Its so easy!!!!

So let's get started!! I had allocated a project "Analysis of various Indicators of Various countries" .
In the raw of my project contains country name ,Indicators names such as: Population ,Population growth(%),GDP(Gross Domestic Product) and the sub-Indicators which reflect the GDP of country Such as Agriculture,Services,Industry,Import and Export of goods and lot more...and their values with respective to the years for each country.

  
I have arranged the data and filtered out and Make reference sheets for the making of my dashboard.

For getting This Sheet just mail to me :

gaurav_pundir@outlook.com or ranagrv@gmail.com

OR

it will uploaded shortly!!!!

To get More information Please check out my Next Post!!!

Excel DashBoard

Excel Dashboard :

Dashboard is something which contains lot things provides various fields to choose and perform act on same.It contains series of things that are interconnected , whenever you make some changes in any thing of your dashboard ,the entire dashboards reflects old values/calculations are eliminated and new ones added according to user needs.

Making dashboard in Excel is Just Simple thing!! You just have need to know of lots of functions used on excel calculations such as Look-UP functions,Indexing,Matching,Percentage calculations etc.Charts Knowledge in needed..how to choose select data and play with them and arrange the data row and column wise properly.

Therefore, Combine the Functions, Calculations and Charts so that if you change in one thing, It reflects On all things and makes changes dynamically.\

My Dashboard Preview:
 Topic: Analysis of various Indicators of Different Countries.

For Getting more details about Dashboard making go for the next post in MS-Excel Categories.
OR mail to me for making any Dashboard/Excel Project just mail to me:
gaurav_pundir@outlook.com or ranagrv@gmail.com

Arithmetic Mean In Excel

Arithmetic Mean is calculating of mean of the series of numbers.You have to add all the numbers and then divide the obtained sum by the total no.of the given series.
It is very common to measure the central tendency in Excel.

OR simply get the average of the series that is find out the average through AVERAGE function.
Through AVERAGE FUNCTION:

Through SUM FUNCTION:

To get more detail about Excel functions: Refer to Excel Categories.