Option 1: Propose and (with instructor approval) complete a project of equivalent complexity as specified in Option 2.
Option 2: Develop a Management Information System (MIS) to analyze the HIV (Links to an external site.) and PrEP (Links to an external site.) metrics for all 21 counties in New Jersey (NJ) using the following mandatory datasets:
AidsVu County PrEP data for 2012 (Links to an external site.), 2013 (Links to an external site.), 2014 (Links to an external site.), 2015 (Links to an external site.), 2016 (Links to an external site.), 2017 (Links to an external site.), 2018 (Links to an external site.), and 2019 (Links to an external site.)
DataPlanet-accessible HIV New Incidence data for 2008-2019 (Links to an external site.) (ref. datasheet (Links to an external site.))
+Census Population Estimates for 1990-2020 (Links to an external site.) (ref. datasheet (Links to an external site.))
Poverty Percentages data for 1997-2020 (Links to an external site.) (ref. datasheet (Links to an external site.))
Unemployment Rate data for 1990-2021 (Links to an external site.) (ref. datasheet (Links to an external site.))
Align and combine all datasets using SQL and/or Excel in your data warehouse;
Create dashboards with some Calculated Fields involving columns from different datasets in Tableau (Links to an external site.) and Excel (Links to an external site.)
Demonstrate your SQL skills by recreating some of the Excel PivotTables in SQL, and;
Provide some key managerial insights and recommendations.
Work as a team to create your tasklist and divide the tasks equitably among members to complete this project.
