Small Business and Tourism
Small business and the tourism industry need your help to survive! How can we get them back on track?
Eligibility: Must use data from data.qld.gov.au.
Go to Challenge | 6 teams have entered this challenge.
Gold Coast Hackers
Our project aims to trace spend by the Queensland Government and its impact on Industry, small business and communities.
Solution It involves three steps
(1) Normalise datasets - We took 9 out of the available 66 datasets for contracts granted by government agencies to suppliers, combined the datasets, cleaned and normalised them.
(2) Visualise spend - We created three tableau dashboards
a. Spend insights dashboard shows total spend by Government across all agencies, the number of distinct agencies, suppliers, agencies and the corresponding number of suppliers engaged, top agencies by money spent, and top suppliers by contracts granted across Queensland
b. Spend Insights Deepdive dashboard - Shows a circle bubble with all suppliers and agencies and their corresponding total contract values. It also allows to use one agency and look for all suppliers and their corresponding contract values. This helps visualise where the money is being spent and identify opportunities for the next step.
c. Spend insights Drill down dashboard - Once we find a specific agency and supplier from deep dive dashboard, this dashboard allows drilling down to the specifics of what are the exact contracts between the supplier and agency. This will help highlight efficiencies and consider savings.
(3) Recommend Savings/Highlight efficiencies. - Based on the observations from the dashboards, the following can be performed
a. Improve cross-portfolio savings. By tracing spending by agency and supplier, same supplier can be used across portfolios or best practices can be shared to increase savings.
b. Encourage supplier diversity- Based on the findings, Alternative local suppliers or inclusive suppliers (women led or Torrest Islander led suppliers) may be considered for offering contracts
c. Optimise suppliers - Based on the finding, suppliers can be consolidated and volume based savings may be negotiated
Datasets used
Queensland Rail Contract Disclosure FY2019-2020
https://www.data.qld.gov.au/dataset/queensland-rail-contract-disclosure-fy2019-2020
GCWA Contract Disclosure 2019-20
https://www.data.qld.gov.au/dataset/gcwa_contract-disclosure-report-2019-20
Department of Transport and Main Roads Contract Disclosure
https://www.data.qld.gov.au/dataset/tmr-contract-disclosure
QBCC Constract Disclosure 2019-20
https://www.data.qld.gov.au/dataset/queensland-building-and-construction-commission-contracts-disclosure
Stadiums Queensland Contract Disclosure
https://www.data.qld.gov.au/dataset/sq-contracts
Department of Housing and Public Works Contract Disclosure
https://www.data.qld.gov.au/dataset/department-of-housing-and-public-works-contract-disclosure
Queensland Government contracts directory—awarded contracts
https://www.data.qld.gov.au/dataset/queensland-government-contracts-directory-awarded-contracts
Department of QLD State Development DSDMIP Contract Disclosure December 2019
https://www.data.qld.gov.au/dataset/contract-disclosure-reports/resource/194a252e-c7a0-48bc-8bf4-6ec432aa56f8
QRIDAContract Disclosure Report 2019-20
https://www.data.qld.gov.au/dataset/qridacontract-disclosure-report-2019-20
Description of Use QRIDA_Contract Disclosure Report 2019-20
Description of Use Department of QLD State Development DSDMIP Contract Disclosure December 2019
Description of Use Department of Housing and Public Works Contract Disclosure
Description of Use Stadiums Queensland contracts >$10k
Description of Use Queensland Building and Construction Commission Contracts Disclosure
Description of Use ransport and Main Roads Contract Disclosure
Description of Use Gold Coast Waterways Authority Spend
Description of Use Rail Contract spend
Eligibility: Must use data from data.qld.gov.au.
Go to Challenge | 6 teams have entered this challenge.
Go to Challenge | 16 teams have entered this challenge.
Eligibility: Must use awarded contract disclosure data from data.qld.gov.au.
Go to Challenge | 2 teams have entered this challenge.