Jamal Qamar

The  2017 Census of Pakistan  was a detailed enumeration of the  Pakistani  population which began on 15 March 2017 and ended on 25 May 2017. The census was conducted by the  Pakistan Bureau of Statistics  for the first time in 21st century, after 19 years.   Initial estimates put the population at 20 crore (210–220 million).   The results showed a total population of Pakistan including of that of  Gilgit Baltistan  and  Azad Kashmir  at 212,742,631 million. Yearly population movement can also be seen since 1950. CAGR is also worked on and it is showing that as compare to last census (1998), population grew by 2.54% on an yearly basis. Punjab population share is 53% whereas sindh share is 23%.

The sport of  soccer  (called football in most of the world) is considered to be the world's most popular sport.  It is played by 250 million players in over 200 countries and dependencies, making it the world's most popular sport. In the first page of my blog, I showed the winners with relevant years and runners. You can use the options available in page 1 and see the behavior of the graph. You can see in the linear graph , radial graph, spiral graph and with different scales and layouts.  However, in page 2 there is a list of team which will play FIFA Russia 2018, all the groups are there and you can also see that which country belongs to which continent. The map will make it more interesting, I also incorporate the GDP size of the country with all the teams. You can see the size of the bubble on the map based on the $GDP. 

Profit and Loss statement analysis: This is very good for financial analysis of the different business units, here we can see the current month financial vs. same month last year with the %change. I am also covering here Year to date (YTD) financial with same period last year. The picture is showing a very simple ERD which i used among the tables. Please see the table given below, this is based on embed code. All the visuals are interactive, you just need to select the business unit and the month, all the visuals will update accordingly. CAGR i.e. compound annual growth rate is also worked on which vary with changes in the year.  You can also check profitability trend and cost trend.

World Economy I used Power BI tool to demonstrate the world economy and comparative analysis. In this blog, one can see the country wise GDP in $, YoY GDP growth, Debt to GDP ratio, inflation rate, interest rate, budget deficit and current account etc. All these indicators are very useful for the analyst and economist. It tells all about the economy performance and based on this one can also do the predictive and perspective analysis. Moreover, on a right side of the table given below, there is a slicer from which you can select the county and with click on Ctrl key one can select multiple countries and make a comparative analysis. The blog is also very useful for students since they can see the location of a country which will increase their knowledge. Please see the table given below showing that all visuals are interactive. When u select any country in the visual, all the relevant indicators will appear.

Economy and Social Performance Regime Wise: In this post, I applied the utilization of Drill-through , Text Filter and Box & Whisker chart . To analyze the economy and social performance of the different regime of Pakistan, these tools helped me a lot. You just need to right click on the name of the authority person, drill-through will appear and then click on the summary as per instruction given below:    One can easily analyze the performance of the authority. Since there is a huge number of indicators over there, you can use the text filter to search your relevant indicators and then can easily see its trend and impact on the table. There are around 1500 indicators in the slicer, as per your requirement you can incorporate it in the analysis. Box & Whisker chart is a very power full tool which I used as a custom visual, it concludes the performance of a particular indicator in a single bar. I used here three indicators: Current Account b...