Tableau Analysis

wrangle_v2.py

Research Assistant Work

For my research assistant work under Professor Jin Wang with the Management Science and Information Systems (MSIS) departments at Rutgers, I was requested to clean and transform mortality and population data queried from The Official Site of the State of New Jersey's New Jersey State Health Assessment Data using Python script.

Professor Wang trusted code more than manual work. After working with him, I started to feel the same way. The code on the left transformed the data. The code below calculated the monthly crude death rates based on the cleaned and wrangled data. The timeseries csv below is the final result and was ultimately used to make a Tableau timeseries plot.

timeseries.py

timeseriesdata.csv

Business Data Management Individual Project

This practice was a graded assignment from college as part of my Business Data Management course during my junior year, which ended with an A grade. The course covered SQL and databases.

The purpose was to analyze the bee data with given guideline questions.

bee.sql

bee_colonies.sql

ExtraCredit.mp4

MIS Final Project

This practice was a graded assignment from college as part of my Management Information Systems course during my sophomore year, which ended with an A grade. The entire course covered Excel, SQL, Tableau, and dashboards.

The purpose was to analyze the given real estate data and make corresponding dashboards in Excel, Tableau, and (a makeshift one in) SQL. I had to work with another classmate to work on it. We had 2-3 weeks to complete it before the final exam.

The entire project was divided into four milestones. They included cleaning and manipulating datasets 1-3 and 4-7, then using visualizations to analyze the data and appropriately placing the visualizations in dashboards.

Management Information Systems Final Analysis Project.mp4

Page updated

Google Sites

Report abuse