5 - Analytics

-

This week's module and lab focused on creating an infographic map using  two normalized variablees from the 2018 County Health Rankings dataset. I used the variables excessive drinking and diabetes prevalence as I learned that somehow drinking alcohol in moderation could lower the risk of diabetes but when drinking greater amounts would be a different story. Most doctors don’t forbid their patients in consuming alcohol, like my uncle for example, but should be done in moderation. Some say alcohol can help decrease blood sugar level, but excessive drinking can also cause hypoglycemia which is high risk for people with type 1 diabetes. So, I wanted to use this opportunity to investigate these variables if excessive drinking is correlated to the risk of diabetes. In addition, both variables are normalized as they are calculated percentages of excessive drinkers and diabetics per county population.

Scatterplot

I used Power BI to create my scatter plot and most of my data visualizations. I made a box type scatter with x and y values in intervals of 5 so that the balance between point distances will look neat and it will adhere to how my bar charts look.


Bar Charts

To add some fun in my map, instead of using a plain horizontal chart I created an infographic bar chart so that I can change the bar icons into a can of beer for excessive drinking and food icon (burger) for diabetes. This helped me to create a more fun way to visualize the percentages differently. I chose to show the top 3 and bottom 3 states since the choropleth map showed more of a county percentage for my variables. And then I used the same colors as my legend in the map so that it's standardized across all visualization.


Data Visualization Techniques (Donut Chart)

I used a simple donut chart this time instead of creating an icon so that my map won’t be too crowded with too many icons. A simple donut chart would add simplicity to the map yet informative in explaining the average percentage of excessive drinking and diabetes prevalence in the US.


Final Layout

For my previous lab maps, I usually use a certain layout but this time a kept it simple with white background due to its infographic setup. I kept my colors standard for excessive drinking and diabetes prevalence for all visualizations. I used the same color scheme for my bar chart based on the colors I used in the map legend.  I then put all related information per side – left for excessive drinking and right for diabetes prevalence. Then I placed my scatter plot at the center indicating on creating a comparison between the 2 values. Lastly, if you’ll notice the visualizations are different across visuals: map – county level, bar chart – state level, donut chart – country level.


Comments

Post a Comment

Popular posts from this blog

M1 S4 - Suitability Analysis / Least Cost Path

-
Image
Scenario 4 lets you pretend to be a park ranger in the Coronado National Forest and is assigned to create a corridor between two protected areas for black bear movement. This will help us keep the area protected on different factors especially urbanization keeping away people and noise away from our black bears yet giving them the best suitable area to live. Below is the ArcGIS model I created for the said scenario. We are given 3 factors to consider (1) roads, (2) elevation and (3) land cover. I realized that besides these if we have data of rivers, and if lucky GPS tracks of black bears (if that's even possible) so we can get a glimpse of their movement as well. First, I applied Euclidean distance tool with the roads layer to transition it to raster and then reclassified all of them according to the suitability criteria given. The reclassified layer were then combined using Weighted overlay tool with the following weights: land cover (60%), elevation (20%) and roads (20%).  Moreo...
Read more

GIS Portfolio

-
For the last few weeks of my certification in UWF, I have been working on my GIS portfolio on WIX website. This GIS portfolio showcases an in-depth about myself and some of my GIS projects that I've worked as a student and as a GIS profession in our organization. I had a hard time digging up some of my works on the past years when I was just starting as a consultant. I realized that I have improved a lot in my skills and this is actually a good avenue to showcase some of it. Here's the link to my GIS portfolio . In addition, I also am preparing myself to apply for the Master's degree program in GIS Administration in UWF and continue my study. I hope that this portfolio will be helpful if needed be as a requirement in my application. I'm also sharing my LinkedIn here that contains some of my works and some of the articles I've written with some of my colleagues:  How to Protect Refugee Camps from Floods and Cyclones Using Geographic Information Systems Digitization ...
Read more

Module 4 - Geoprocessing

-
Image
Geoprocessing is a an importent component in GIS. Whether you're a new or advanced user it is an essential set of tools you will use for processing geographic and related data. It offers to perform simple spatial analysis to complex ones. It can also be modeled into a sequence of spatial relationship that will help the user to automatize tasks from one tool to the other and produces a whole new dataset you can use for decision making. Another component related to geogprocessing is the Model Builder, which I recently have used quite frequently this year. In one of the projects that I'm working on we had to run multiple tools from the input until the end result. And we need to do that everyday, instead of running 10+ tools daily, why not create a model wherein all you need to do is add the input parameters (daily) and run it. It will then publish the end result in my ArcGIS Online profile and there you go I now have an updated dataset I can publish daily. Model Builder is lik...
Read more