What is Management Information Systems ?

What is MIS?

MIS is short for management information system or management information services.

Management information system, or MIS, broadly refers to a computer-based system that provides managers with the tools to organize, evaluate and efficiently manage departments within an organization. In order to provide past, present and prediction information, a management information system can include software that helps in decision making, data resources such as databases, the hardware resources of a system, decision support systems, people management and project management applications, and any computerized processes that enable the department to run efficiently.

Management Information System Managers

The role of the management information system (MIS) manager is to focus on the organization’s information and technology systems. The MIS manager typically analyzes business problems and then designs and maintains computer applications to solve the organization’s problems.

(http://www.webopedia.com/TERM/M/MIS.html)

Try R CA 2 Data Management & Analytics

 Introduction

According to (http://www.revolcutionanalytics.com/what-r) R is hot!!

This assignment, aims to back up this statement, by examining the reasons why the programming tool is so appealing. By providing some information on R & it’s functions.

During the last decade, the momentum coming from both academia and industry has lifted the R programming language to become the single most important tool for computational statistics, visualization and data science.

Code School

To begin, we were asked to complete the R Programming course on tryr.codeschool.com; this course provided an excellent introduction to the world of R & some of its commands & functionality.

Code school - R completion

Case Study

In order to get an understanding of R studio, I decided to analyze a data file, containing data on nutritional food content & used R to run some basic functions.

Process steps

  1. I created a folder & saved it to my desktop, I renamed the folder R
  2. Within the folder I included a .csv file, which included a breakdown of food components ( file sourced from Moodle)
  3. I saved the .csv file to the R folder & loaded this as my workspace into R Studio
  4. I opened R, & set my working directory to the R folder I created on my desktop
  5. The first command was asking R to read the file from the Working Directory

Reading the data

A: Get the current directory

Command = getwd()

B: Read the csv file

Command = read.csv(“USDA.csv”)

C: Structure of data

Command = str(USDA)

 Results

Image 1

D: Summarise dataset

Command = summary(USDA)

Screenshot of some of the commands run

Image 2

E: If I wanted to find which product contained the max amount of sodium, I would use the next command

Command = which.max(USDA$Sodium)

R Graphics

Plots

The article I read on (http://www.revolutionanalytics.com/what-r) emphases that R is known for creating “beautiful and unique data visualization”, to put that to the test, I went on to run some plotting commands

F: I wanted to look at the protein & total fat content

Command = plot(USDA$Protein, USDA$TotalFat)

image 3

G: I used the next command to compare the protein to fat content & added in some colour to make the graph more appealing to the eye

Command = plot(USDA$Protein, USDA$TotalFat, xlab=”Protein”, ylab = “Fat”, main = “Protein vs Fat”, col = “red”)

Image 4

 

Boxplots

H: The boxplot command was used next to show the sugar content

Command: boxplot(USDA$Sugar, ylab = “Sugar (g)”, main = “Boxplot of Sugar”)

I: The final command used was to find out how many products have a higher than average fat & sodium content?

Command = table(USDA$HighSodium, USDA$HighFat)

Image 5

Conclusion

On completion of the above tasks using R Studio, I surmise that R is a great tool, for data visualisation, accuracy & speed in terms of getting the results you want faster & more efficiently.

 

Google Fusion CA 1 Data Management & Analytics

Question 1:

A) A chart that breaks down population by Gender

Image 1

B) A chart/table that shows population by province

Image 2

C) Use a pivot table to find out what % of the population does each county account for in 2011.

Row Labels Sum of Total Persons percentage
Carlow 54612 1.190257205
Cavan 73183 1.595008295
Clare 117196 2.554262495
Cork 519032 11.31219471
Donegal 161137 3.511947469
Dublin 1273069 27.74627462
Galway 250653 5.462930109
Kerry 145502 3.17118589
Kildare 210312 4.583706388
Kilkenny 95419 2.0796373
Laois 80559 1.755766684
Leitrim 31798 0.69303081
Limerick 191809 4.180437343
Longford 39000 0.849996905
Louth 122897 2.678514606
Mayo 130638 2.847228095
Meath 184135 4.013184106
Monaghan 60483 1.318214431
Offaly 76687 1.671377248
Roscommon 64065 1.396283378
Sligo 65393 1.425226862
Tipp 158754 3.460010479
Waterford 113795 2.480138406
Westmeath 86164 1.877926496
Wexford 145320 3.167219237
Wicklow 136640 2.978040439
Grand Total 4588252  

 

 

Question 2:

Image 1

Map 1

Image 2

Map 2

Image 3

Map 3

 

Question 3:

As part of our assignment on the Irish Census Data for 2011, we were ask to use Google’s Fusion Tables to create a Heat map, this was done by cleansing the data file provided, extracting the information that was required for the Heatmap.  I didn’t have a Gmail account set up, so the first step was to create an account, one set up, I logged into Google Drive & selected Fusion Tables.  The first file I loaded was the clean map KML file which was uploaded to Moodle, I repeated the same steps to load the cleansed census data I had manipulated. Once loaded, selected File, Merge from the dropdown.

I updated the county column on both files to ensure they had the same naming convention, once completed I used this column to merge the data together.

Next a pop up appeared to select the columns to be used on the heat map, I deselected males, females & description & hit view table.

Once I navigated to the map of geometry tab, my first map appeared- as shown above ref: Image 1.

When feature map was selected the map appears as shown in image 2.

Fusion Tables allows you to present your data in a visual, interactive way. This data was collated after importing into fusion table and merged on the County attribute to obtain the total population and male and female population heat maps as required.

The map aims to reflect the population data from the 26 counties in ROI.

The benefits of data visualization to a business/decision maker are to collate & understand the data more easily. In addition it helps to determine & spot patterns & trends in business operations.

It is quite apparent from the image 3 that within the heat map, Dublin & Cork are jumping out above the other 24 counties, for a business this information helps, decision makers identify to abnormalities or highlights immediately. In this case Both Dublin & Cork are the most densely populated counties, & visual synopsis’s such as this would can prove to be very useful for fast moving businesses who need to spot trends & risks as quickly as possible.