Difference between revisions of "WEDUCARE: Proposal"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(Created page with "center|230px <p></p><br/> <!--Sub Header Start--> {| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing...")
 
Line 28: Line 28:
 
<!--PROBLEM AND MOTIVATION START-->
 
<!--PROBLEM AND MOTIVATION START-->
 
<div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div>
 
<div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div>
−
''' Problem '''
+
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 and identify interesting patterns about government patterns.
  
 
<!--PROBLEM AND MOTIVATION END  -->
 
<!--PROBLEM AND MOTIVATION END  -->
 
<!--OBJECTIVE START-->
 
<!--OBJECTIVE START-->
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OBJECTIVES</font></div>
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OBJECTIVES</font></div>
 +
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
  
  
Line 38: Line 44:
 
<!--DATASET START-->
 
<!--DATASET START-->
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SELECTED DATASET</font></div>
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SELECTED DATASET</font></div>
−
 
+
The dataset for analysis will be retrieved from database or done by web scaping, as elaborated below:
 +
{| class="wikitable"
 +
|-
 +
! 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
 +
|}
 
<!--DATASET END-->
 
<!--DATASET END-->
−
<!--BACKGROUND SURVEY START-->
 
  
−
 
−
<!--BACKGROUND SURVEY END-->
 
−
<!--STORYBOARD START-->
 
−
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROPOSED STORYBOARD</font></div>
 
−
 
−
 
−
<!--STORYBOARD END-->
 
 
<!--KEY CHALLENGE START-->
 
<!--KEY CHALLENGE START-->
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">ADDRESSING KEY TECHNICAL CHALLENGES</font></div>
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">ADDRESSING KEY TECHNICAL CHALLENGES</font></div>
−
 
+
The following are some of the key technical challenges that we may face throughout the course of the project:
 +
{| class="wikitable"
 +
|-
 +
! 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
 +
|-
 +
|}
 
<!--KEY CHALLENGE END-->
 
<!--KEY CHALLENGE END-->
  
−
<!--TIMELINE START-->
 
−
 
−
<!--TIMELINE END-->
 
 
<!--TOOL USED START-->
 
<!--TOOL USED START-->
 +
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">TOOLS / TECHNOLOGY USED</font></div>
 +
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
  
 
<!--TOOL USED END-->
 
<!--TOOL USED END-->
Line 63: Line 116:
 
<!--REFERENCE START-->
 
<!--REFERENCE START-->
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
−
 
+
* https://www.straitstimes.com/business/price-quality-method-to-be-used-to-evaluate-tenders-for-government-contracts-chee-hong-tat
 +
* https://www.centreforpublicimpact.org/case-study/government-e-procurement-system-singapore/
 +
* https://www.mof.gov.sg/Newsroom/Press-Releases/Tender-bids-can-now-be-submitted-online---Over-$7-5B-worth-of-business-opportunities-accessible-via-GeBIZ
 
<!--REFERENCE END-->
 
<!--REFERENCE END-->
  
−
<!--BRAINSTORM START-->
 
−
 
−
<!--BRAINSTORM END-->
 
 
<!--COMMENT START-->
 
<!--COMMENT START-->
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
<br/><div style="background: #3E646D; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
 
<p>Feel free to comment on our project</p>
 
<p>Feel free to comment on our project</p>
 
<!--COMMENT END-->
 
<!--COMMENT END-->

Revision as of 22:42, 14 October 2018

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 and identify interesting patterns about government patterns.


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

Retrieved from ‘https://wiki.smu.edu.sg/18191is428g1/index.php?title=WEDUCARE:_Proposal&oldid=1226’