Business Analysis Restaurants around the dock in Jakarta

Introduction

you can download this notebook on https://github.com/faoziaziz/Coursera_Capstone/blob/master/Week4indo.ipynb

Background 

Indonesia has many islands, this gives Indonesia many docks. But not all docks can be utilized properly. For entrepreneurs, this project can be a reference before you invest in various islands around Jakarta. by using the python toolset and data analysis we will analyze investment errors around the port of Jakarta.

Problem 

How do you determine the best investment, especially in restaurants on the island around Jakarta?

Interest 

This project will be a description of the best location to be used as a reference for investment. Data I used a dataset from the Indonesian Ministry of Transportation to get traffic data for people going in and out of the dock. Available data is only available for 2018 and is still enumerated every month. I use pandas from python to convert them to dataframes. I got the dataset from the following link https://data.jakarta.go.id/dataset/data-penumpang-kapal-dari-dan-ke-kepulauan-seribu-tahun-2018-kpi.

Data

Data Preprocessing amd Cleaning

I get data for each month in 2018 for that I try to combine data every month. Here is a sample of the data,

this image show the dataset from Ministry of Transportation

Methodology

1. I combine all the datasets every month to make it 2018 data.
2. I plot it to get a graph of the traffic of people on the dock.
3. I use the Foursquare API to be able to track the location of the nearest venue as a consideration for creating a business restaurant

this picture show the description of data after cleaning

table descriotion after cleaning

I also use the data from google like latitude and longitude to get parameter to pass on foursquare api

latituda and longitude dataset

after i create the dataset i also combine the dataset and the dataset from ministry of transportation. You can access on this link https://github.com/faoziaziz/Coursera_Capstone/blob/master/df_port_dict.csv

count graph

This graph shows that the kelapa harbor has a lower venue than the anke port.

but from the graph above port of Angke has a much lower traffic than kelapa ports

follium from muara anke port

The picture above is a picture showing the venue area for a map near the muara anke port. The picture above is an example of a port.

Discussion

 The aim of this project is to help investors to easily determine locations on various docks around Jakarta and the Thousand Islands. Using veneu analysis from Foursquare, we can determine a variety of competitors. Also with the restaurant opportunities that are not yet available in these places.

Conclusion 

This project will help investors to understand business opportunities around ports in the Thousand Islands. Comparison of traffic and the location of the nearest veneu from the pier will give a picture to investors.That from the comparison between Kelapa and Marina ports, there was an investment error.