WEDUCARE: Proposal

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
WEDUCARE.png



PROBLEM & MOTIVATION

GeBIZ is a Singapore Government’s one-stop e-procurement portal which facilitates the entire procurement lifecycle and revenue tender activities between Singapore government and local and overseas supplies electronically since June 2000. The purpose of the portal is to be transparency, encourage fair and open competition and to generate demands / quotations. With this portal, more companies are tendering for projects hence increasing the competitiveness.

We aim to create a visualisation which benefits businesses in crafting bidding prices and increasing their chances in winning the government contracts and tender. In addition, we hope to give an overview and identify interesting patterns of government spending.


OBJECTIVES

In this project, we are creating a visualisation that is able to show the following:

  • Government investment analysis
  • The tender distribution of projects to different type of business
  • Identify the price range when bidding for projects



SELECTED DATASET

The dataset for analysis will be retrieved from database or done by web scaping, as elaborated below:

Dataset/Source Data Attributes Rationale of Usage
Government Procurement Data (https://data.gov.sg/dataset/government-procurement)
  • Tender No
  • Agency
  • Tender Description
  • Award Date
  • Tender Detail Status
  • Supplier Name
  • Awarded Amount
To gain information on government procurement such as tender description, amount and supplier information
Company Information (Will be done by web scraping)
  • Company Name
  • Sector
  • Number of Employees
To understand the nature of the awarded suppliers


ADDRESSING KEY TECHNICAL CHALLENGES

The following are some of the key technical challenges that we may face throughout the course of the project:

Key Challenges Mitigation Plan
Unfamiliarity with Javascript Rshiny libraries )
  • Attend R Shiny Workshop
  • Independent learning via online resources
  • Ask team mates for help
Unfamiliarity with R Libraries for Machine Learning and Selenium
  • Independent learning via online resources
  • Clean, transform and analyse data together
Data Cleaning and Transformation
  • Need to crawl data on website to obtain company information
  • Clean, transform the data together


TOOLS / TECHNOLOGY USED

The following are some of the tools and technologies that we will be utilizing during the project:

  • ggplot2
  • plotly
  • R shiny
  • Rstudio
  • JMP Pro 12
  • Python
  • Jupyter Notebook
  • Selenium
  • Visual Studio Code
  • Github



REFERENCES


COMMENTS

Feel free to comment on our project