In today's business landscape, technological companies often outsource aspects of their workforce, such as sales, support, and operations, to external firms known as vendor partners to scale up operations.

Deciding where to open a new office or where to move your operations can include multiple key decisive factors into the equation like costs, connection, political stability, etc.

However, with the environment worsening, factors like air quality and pollution are definitely good decision-making points to take into account when opening new offices or business locations.

This script allows you to analyze Air Quality data for different locations, aiding decisions about office locations.

Here's what you can do:

1. Analyze Air Quality: Investigate the historic or current air quality of existing offices.
2. Explore New Locations: Input city details to assess air quality for potential new offices.
3. Make Informed Decisions: Utilize air quality insights to decide on office locations.
4. Country Insights: Obtain key country metrics such as Minimum Wage, Unemployment or Education rate.
5. Geographical Details: Retrieve cities' longitude and latitude coordinates for air quality consultation.

In this study, we are assessing a specific scenario to simulate a study of deciding where to open a new office. The information we have for this case is:

Where we are currently operating:

• 🇮🇳 India: Gurugram, Hyderabad
• 🇵🇭 Philippines: Manila

• Investigate the current air quality of our operating locations.
• Explore potential new locations with similar costs and better air quality.

The air quality in our current cities (Gurugram, Hyderabad, and Manila) is unhealthy or dangerous. Exploring new locations with better air quality is a good idea.

We can discover new locations to open offices that offer better air quality than our current sites (India and the Philippines) with similar labor costs, so we don't have to sacrifice much budget.

We reviewed the Air quality status of the current locations we operate and the results of Air Quality are:

1. First we assesed a sample of 141 countries, sorting Minimum wage & Unemployment from (Low to High) and Education (High to Low) to identify potential hotspots (in red) and this is the result:

2. Secondly we reduced that sample focusing in the followinf filters:

• Minimum wage($) [0-2]

• Unemployment rate (%) [0-5]

• Gross primary education enrollment (%) > 110

  We identified a sample of 11 potential locations and created a Scatter Plot to visualize the data:

3. Finally we ran the Air quality API for the four finalist locations and got the following results:

• Two-thirds of our current locations are unhealthy 😷, and one-third is dangerous ☠️ in terms of Air Quality.

• If air quality is a crucial factor for our next location, exploring new places is worthwhile.

• Overall African countries 🌍 look like a good alternative 🔄 to explore, offering better air quality ♻️ while keeping costs 💰comparable to the Asian locations.

• Potenatial good candidates are: Guinea-Bissau, Madagascar and Togo, Madagascar ⭐ being the favourite for highest % education compared to ther other two.

• Air quality and labor costs (minimum wage, unemployment rate, and education) are not the only factors to consider when deciding new locations.

• This study is not definitive or final. Other factors, such as political stability, conflicts, or resources, could significantly influence the decision-making process when exploring new locations in Africa.