Mauritius through Data

When I was in college and studying economics, I learnt something very interesting which is that “our government collect data on the population”. After all, how would we know whether as a nation we are heading in the right or wrong direction? Thus we have Statistics Mauritius, which operates under the aegis of the ministry of Finance and economic development. It allows to constantly monitor the country which should consequently help its leader in the decision-making process.

If you’ve had assignments, you must have stumbled across the site during research. Most of the time the data are in the traditional tabular format; which would make a very boring and lifeless blog if I simply copy pasted the information here. But having access to information like these and being able to understand it is important for every citizen. It allows us to make decisions rationally based on facts and see where we are heading. It can allow businesses to be proactive and make more armed decisions or identify opportunities or threats well in advance. So the following is my attempt to bring some life into explaining the already existing data and a guide for anyone who wishes to easily extract the same information and visualise it for an assignment or report.

I am going to use PowerBI because I am familiar with it, have used it extensively in the past, it has cool features and also beautiful visuals. However you are free, you can choose IBM Watson, Excel, SPSS, Tableau or any other tool which suits you.

 

EMPLOYMENT

Sectoral Employment

Most of our workforce is operating in the service sector. The secondary sector has been slowly decreasing while the primary sector is at a consistent minimum of 8%.

Unemployement rate

A slight decrease in the unemployment rate can be observed for the past recorded year.

unployed fml

We consistently have more unemployed female than male. Is that a “thing” in the country? Are the women less proactive in searching/applying for jobs or are they facing discrimination?

 

POPULATION BY AGE

POP Age

We have quite a healthy population for now with a significant proportion of the population working and keep the economy running. However if our under 15 years old does not improve, in the long run, we might have a huge issue and shortage of manpower with an aging population that surpasses the working population.

Life Expectancy

For some reason and according to the prediction, it seems females, in general, will outlive man by 7 years.

death and birth rate

Birth rate had been on a gradual decrease around 2014 till 2015, with the government even encouraging couples to have more children at a certain point. While on the other hand, it seems death rate, in general, is on the rise. Is it the accidents, is it a decreasing quality of life?

 

TOURISM

Tourism

The tourism industry is an important one for our little island and contributes to a major portion of our economy’s revenue. In 2016 alone the country recorded a revenue of Rs. 56 thousand million. On average, tourists generate around Rs. 44 thousand each.

Tourist arrival and Pop

We are reputed for being hospital maybe that’s why tourist like it here so much along with the scenery, water, and other facilities. Tourism is still a growing industry right now as it can be seen from the growth figures. 2016 was different from the past years with tourist arrival for a year even surpassing the population size. Crazy isn’t it? In an island with a population of 1.26 million, we welcomed in a year 1.28 million tourists.

 

ENERGY USAGE

energy

Our energy consumption is beyond any doubt on the rise. It seems we are in a deadlock between wanting a sustainable and green Mauritius while at the same time experiencing an increasing appetite for energy consumption.

 

INFLATION

Inflation

We keep hearing that inflation is bad times and times again but with a 1% inflation, we should be more concerned with a further decrease of the inflation than an increase. The federal bank recommends maintaining inflation at 2%.

PHONES & THE INTERNET

Tel Com

Are phones saturated, I thought so until I saw the figures. It seems people are no longer satisfied with a single phone. For every 1000 persons, we had 1436 phones in 2016. How about I put it like that “We have more phones than people in the country”.  Internet subscription also shows a continuous increase. More and more are getting connected in this country. Does this mean more and more people will be able to read my blog now?

 

EDUCATION

 

 

male eduction
Male Enrollment
femal education
Female Enrollment

Both male and female enrollment shows that even if education is free not everyone is having access to it. There is always a 2-4 % who have not attended primary school. As we climb to secondary up till tertiary education, the number of enrollment keeps on decreasing. In general, females have a better rate of enrolment in primary, secondary and tertiary schools than boys, suggesting that they may be better academically than boys.

 

teachr pupil ratio

Teachers on average seemed to have a slightly lesser amount of students to handle in 2016 compared to the previous years.

 

I hope you enjoyed, you found it interesting and constructive. Below I have tried to very briefly describe the steps should you want to try something similar.

 

STEP 1

Open PowerBI desktop and get data from the webpage that contains the source of your information.  (Any website with the right data works, I once tried with EPL and Champions League data from Wikipedia and confirm it works).

step 1

STEP 2

I opened the site on my browser and used information that the following page contains by copy pasting the link and clicking ok.   http://statsmauritius.govmu.org/English/Tableau%20de%20Bord/Pages/default.aspx

STEP 3

It involves cleaning up the data which is important in order to have accurate representations. Have a look at this guide if you want to know how that is done in general.

STEP 4

Visualise your data by selecting your visuals and data from the two panels on your right named visualization and fields.

STEP 5

Once done save your work. You can also hit the publish button and access it online and embed it on websites should you want to. However, using the online version does require a work email or even a university email. My university one worked perfectly fine.

acc

Note:

I tried my best in a limited time to extrapolate, clean up and visualise the data while keeping it closest to actual figures. Due to changing of formatting and data types, some errors might be present, so view the data with a critical eye and you can always head to http://statsmauritius.govmu.org/English/Tableau%20de%20Bord/Pages/default.aspx to verify from the source.

This is a personal project so I would be grateful if you could inform me of any discrepancies you can notice or any critics on how I can improve. Also if you know someone who would benefit and appreciate the information, please share with them.

3 thoughts on “Mauritius through Data

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.