Name: Banu Boopalan MSDA 607 Final Project: My final goal is to complete both below as I am not sure if I have covered all expected outcomes (checklist) by the professors from the Final Project PDF document posted in the Blackboard.
Goal1: I would like to use the lessons learned in this course to put together a final project and work to combine US Labor force Statistics time series data around unemployment (https://www.bls.gov/data/) in the Local area unemployment section, clean these datasets and put together visualizations and show map visualization on states by year and other aggregate analysis. I would also like to design my database with few tables with the cleaned results from R coding and create the tables and host in Azure SQL database tables and try to connect to my tables in Azure from R to update my Azure tables back through R on any further analysis done in R. If I have problems connecting to Azure, I will host my database in AWS as I have not worked with this so far.
[optional] – I would like to change my tables above to NOSQL and create MongoDB to host it on there and connect to it from R successfully. I would also like to create a static visualization dashboard in Tableau using Azure backend tables and Mongo DB tables if possible.
Goal2: I would like to analyze data from NYTIMES API on Article search and present some analysis/visualizations after cleaning this data and reporting my findings. What type of articles are being shared by age, and topics that are most concerned about or shared through NYTIMES? What is the current sentiment in the past 3 months based on what people are sharing through NYTIMES? What type of articles were shared in the 3-month period before that and how is this reflected by the sentiment analysis? How has it changed for the same periods in 2018 (was the sentiment different then?) I need to perform some more research on the statistical analysis and graphic to validate my analysis above.
Data Sources: https://www.bls.gov/lau/lauov.htm; Local Area Unemployment Statistics (LAUS) Data Sources: https://developer.nytimes.com/docs/articlesearch-product/1/overview