Community Platform
PRO PROGRAM

Interests
Not Available
This Year
No Points
Total
No Points
MIS Badge

Click here
to validate the recipient

MIS Projects

Data Analytics Challenge

 1. Data Analytics Challenge:

A classmate and I completed the Merck Challenge titled, “Understanding a Corporate Move’s Impact” using big data. The set up of our challenge can be found below.

By clicking on the visual to the left, you will find an enlarged copy of our finished product with zoom-in and zoom-out capabilities.

Problem

When a corporation decides to move the location of a major site, the impact on employees is not always completely understood. Often the total impact on the quality of life and commute time for employees to travel to a new location is not always taken into consideration.

Merck recently decided to move its corporate headquarters from Whitehouse Station, New Jersey to Kenilworth, New Jersey. Leadership wanted to understand the impact on the commute experience for the over 2,400 employees who worked at that site and whether certain organizations were more affected than others. Beyond this, there are also larger environmental impacts of such a change, caused by shifts in driving patterns, increased traffic at the new location, and potential impacts on public transit.

Your challenge is to characterize, quantify, and visualize the impact of a change of location for those 2,400 Merck employees to a new location. Specifically, your analysis should address one or more of the following questions:

        • What was the impact of relocating from Whitehouse Station, NJ to Kenilworth, NJ?
        • How does this compare to the impact of relocating instead to West Point, PA?
        • For either option, are certain organizations more negatively impacted than others?
        • If the commute experience were the only factor in making a decision and Merck could move anywhere, is there a different location that would be ideal for most employees? For the surrounding communities?

Data and Resources

        • An anonymized list of 2,453 employees that currently commute to the Whitehouse Station site. The data set includes their divisions, their home zip codes, and the organization code in which the employee works.
        • A list of valid US zip codes, including a tool embedded in the sheet that allows you to compute the distance between two zip codes.
        • The zip code of Whitehouse Station, NJ is 08889.
        • The zip code of Kenilworth, NJ is 07033.
        • The zip code of West Point, PA is 19486.

 

Skip to toolbar