Difference between revisions of "Group06 Proposal"
| Line 70: | Line 70: | ||
| '''Timeseries Charts''' | | '''Timeseries Charts''' | ||
Timeseries charts will draw out seasonality patterns in the tenders awarded. | Timeseries charts will draw out seasonality patterns in the tenders awarded. | ||
| − | [[File:Data Preparation Timeseries Chart.png| | + | [[File:Data Preparation Timeseries Chart.png|700px|left]] |
|- | |- | ||
| − | | [[File:Storyboard Timeseries.png| | + | | [[File:Storyboard Timeseries.png|700px|left]] |
|- | |- | ||
| '''Treemap''' | | '''Treemap''' | ||
A treemap will breakdown the spend by each ministry into the relevant agencies and then the suppliers. | A treemap will breakdown the spend by each ministry into the relevant agencies and then the suppliers. | ||
| − | [[File:Data Preparation Treemap.png| | + | [[File:Data Preparation Treemap.png|330px|left]] |
|- | |- | ||
| − | | [[File:Storyboard Treemap 1.png| | + | | [[File:Storyboard Treemap 1.png|700px|left]] |
|- | |- | ||
| '''Boxplot''' | | '''Boxplot''' | ||
A boxplot will display the tenders of the top 10 most influential suppliers. | A boxplot will display the tenders of the top 10 most influential suppliers. | ||
| − | [[File:Data Preparation Boxplot.png| | + | [[File:Data Preparation Boxplot.png|525px|left]] |
|- | |- | ||
| − | | [[File:Storyboard Boxplot.png| | + | | [[File:Storyboard Boxplot.png|700px|left]] |
|- | |- | ||
| '''Network Graph''' | | '''Network Graph''' | ||
A network graph will be used to visualize the size of transactions between government agencies and suppliers. | A network graph will be used to visualize the size of transactions between government agencies and suppliers. | ||
| − | [[File:Data Preparation Network Graph.png| | + | [[File:Data Preparation Network Graph.png|875px|left]] |
|- | |- | ||
| [[File:Storyboard Network Graph.png|500px|left]] | | [[File:Storyboard Network Graph.png|500px|left]] | ||
Revision as of 13:15, 26 November 2018
Gee-Whiz: Singapore and the suppliers that make her tick
A visual exploration of relationships between government agencies and suppliers.
|
|
|
|
|
|
Contents
Project Overview
Set up in June 2000, the Government Electronic Business (GeBIZ) Portal is an integrated portal for use by all Singapore government agencies to conduct business electronically with their suppliers. As a one-stop center for suppliers to have access to all procurement opportunities in the public sector and to trade electronically with the government, GeBIZ creates an entry point for businesses to access ‘government-to-business’ services.
There are more than S$10 billion worth of business opportunities published annually to 30,000 suppliers registered with GeBIZ. Over the years, GeBIZ has accumulated a knowledge base of procurement data and this massive amount of data can be harnessed as a valuable source of market knowledge.
We will be exploring ways to help visualize the relationships between government agencies and their suppliers, increasing the ability to gain valuable insights. Primarily, we will be exploring network graphs using a R shiny application to help visualize the relationships between the Ministries, Agencies and Suppliers together with other supplementary visualizations.
Goals
Through our exploration of this dataset, below are some of the questions we intend to answer:
- How is government budget currently being spent? Are there certain Ministries with a much higher expenditure than others? Is this consistent or are there large one-off purchases being made?
- Is there any observable trend in terms of government expenditure? (Upward or downward over time for certain ministries?)
- Are there suppliers which are awarded tenders from multiple agencies?
- Which suppliers are more influential in terms of dollar value of contracts awarded? Are these from large one-off contracts from a single agency or from multiple smaller contracts via different agencies?
Aside from our inquiry regarding the dataset, this project also aims to explore R and R packages as a tool for visual analytics. We aim to understand the functionality that is currently available and also to critically evaluate the capacity for future extensibility of the packages used.
Dataset & Preparation
The dataset we will use for our application is sourced from Data.gov.sg
This dataset contains information on successful tenders from January 2015 to December 2017. The structure of the dataset is as seen below:
The process diagram below illustrates our approach to data preparation. The existing dataset only contains agency information. There are no details regarding which ministries these agencies belong to. We will supplement the original data with externally sources information on the mapping. Furthermore, our dataset contains rows for tenders which were not awarded to any supplier. This information is not of interest for our project and will be filtered away. Subsequently, the dataset can be used for preparing the visualizations discussed in the next section.
Visualization Storyboard
| Timeseries Charts
Timeseries charts will draw out seasonality patterns in the tenders awarded.  |
 |
| Treemap
A treemap will breakdown the spend by each ministry into the relevant agencies and then the suppliers.  |
 |
| Boxplot
A boxplot will display the tenders of the top 10 most influential suppliers.  |
 |
| Network Graph
A network graph will be used to visualize the size of transactions between government agencies and suppliers.  |
 |
Tools and Packages Used
We primarily intend to use the various R packages below:
- dplyr
- ggplot2
- lubridate
- tidyr
- tibble
- tidyverse
- treemap
- d3treeR
- tidygraph
- igraph
- ggraph
- visNetwork
- shiny
- shinydashboard
