Invest SA

Team Name: 
CMUnity

Project brief

 

Invest SA is an info graphic portal for providing insights on latest export trends of South Australia.

Background

Australia has trade relations with over 100 different countries in the world. To facilitate trade and develop international relations several free trade agreements have been established. The agreements provide favorable conditions for import and export of various good. Australia is a very rich source of mineral, livestock and machinery. Using all the favorable conditions for trade, Australian GDP depicts a huge share from exports.

Objective

Using historical data over the last 6 years, the objective of this info site is to display trade sales figures showing the main goods exported and countries for trade.

Process

SA exports multitude of products including processed and unprocessed agriculture, meat, metals, fuels, machinery, wool, wine, pharmaceuticals and many more. Exports form a major part of the state’s annual revenue. This sector of economy forms a substantial amount of jobs too. Using different methods of analysis including regression analysis, sentiment analysis and modelling, we have created a info graphics site. This site will provide critical information for checking export statistics and new investment ventures. For new business owners who want to move to an international market, the analysis will provide a clear window of the best markets to set the business quickly. Analysis based on countries also helps the government better plan the countries for improving trade relations with. For a picture description of our project : https://www.youtube.com/watch?v=JdYCnDrJ1Dc (this is an extra informative video. Main project video is at the end.)

Datasets

The data sets include extensive sets from South Australian government open data, World Bank data, Australia Bureau of Statistics and Austrade. The following is the list of data sets used:

 

  1. International Exports, ABS customised data: https://data.sa.gov.au/data/dataset/international-exports-abs-customised-data

  2. Export Price index: http://data.gov.au/dataset/995d03a7-52f0-4762-ba37-dd7caf4f03db

  3. Directory.gov.au full data export: http://data.gov.au/dataset/9e1c31e6-278c-49d7-8c38-2886459570f7

  4. Trade as a % of GDP (sum of all trade): http://data.worldbank.org/indicator/NE.TRD.GNFS.ZS

  5. Ease of doing business ranking: http://www.doingbusiness.org/rankings

  6. FDI (Foreign Direct Investment), GDP, Inflation, Exchange rate, Tariff by GDP: http://data.worldbank.org/

  7. Export volume index: http://data.worldbank.org/indicator/TX.QTY.MRCH.XD.WD/countries

  8. Import Volume index: http://data.worldbank.org/indicator/TM.QTY.MRCH.XD.WD/countries

  9. Export Value index: http://data.worldbank.org/indicator/TX.VAL.MRCH.XD.WD/countries

  10. Import of goods and services as % of GDP: http://data.worldbank.org/indicator/NE.IMP.GNFS.ZS/countries

  11. Import Value Index (2000 = 100): http://data.worldbank.org/indicator/TM.VAL.MRCH.XD.WD/countries

  12. Logistics performance index (overall 1 low, 5 high): http://data.worldbank.org/indicator/LP.LPI.OVRL.XQ/countries

  13. Trade in services as % of GDP: http://data.worldbank.org/indicator/BG.GSR.NFSV.GD.ZS/countries

  14. Trade as a % of GDP (sum of all trade): http://data.worldbank.org/indicator/NE.TRD.GNFS.ZS  

Analysis methods

  1. Regression analysis

  2. Forecasting

  3. Predictive sales

  4. Sentimental analysis

  5. Market basket analysis

Output

  1. Our product is user-friendly, interactive, cross platform, has responsive design, and mobile enabled

  2. Our forecasting model can filter important factors that can predict future sales for any product using linear regression

  3. Our forecasting model can identify sentiments for each individual country, and make smart recommendations for other products to be exported suited for country according to product of interest

  4. Analyze real time news and ranking them to provide further analysis for informed decision making

  5. Analyze historical data to identify a) best export partners, b) high sales volume products, and c) high opportunity export countries

 

Dashboard Link

https://public.tableau.com/profile/jane5978#!/vizhome/InvestSA/AustraliaProfile

Github repository

https://github.com/sharinganGt/unleashed

https://github.com/HanweiShao/unleashed15.git

 

 

YOUTUBE

 

https://www.youtube.com/watch?v=81oCpkQvALY&feature=youtu.be

  Education institution: All the team memebers are students of Carnegie Mellon University-Australia. 

Datasets Used: 
International Exports, ABS customised data: https://data.sa.gov.au/data/dataset/international-exports-abs-customised-data Export Price index: http://data.gov.au/dataset/995d03a7-52f0-4762-ba37-dd7caf4f03db Directory.gov.au full data export: http://data.gov.au/dataset/9e1c31e6-278c-49d7-8c38-2886459570f7 Trade as a % of GDP (sum of all trade): http://data.worldbank.org/indicator/NE.TRD.GNFS.ZS Ease of doing business ranking: http://www.doingbusiness.org/rankings FDI (Foreign Direct Investment), GDP, Inflation, Exchange rate, Tariff by GDP: http://data.worldbank.org/ Export volume index: http://data.worldbank.org/indicator/TX.QTY.MRCH.XD.WD/countries Import Volume index: http://data.worldbank.org/indicator/TM.QTY.MRCH.XD.WD/countries Export Value index: http://data.worldbank.org/indicator/TX.VAL.MRCH.XD.WD/countries Import of goods and services as % of GDP: http://data.worldbank.org/indicator/NE.IMP.GNFS.ZS/countries Import Value Index (2000 = 100): http://data.worldbank.org/indicator/TM.VAL.MRCH.XD.WD/countries Logistics performance index (overall 1 low, 5 high): http://data.worldbank.org/indicator/LP.LPI.OVRL.XQ/countries Trade in services as % of GDP: http://data.worldbank.org/indicator/BG.GSR.NFSV.GD.ZS/countries Trade as a % of GDP (sum of all trade): http://data.worldbank.org/indicator/NE.TRD.GNFS.ZS

Local Event Location: