Spend Tracing

Project Info

Team Members


Narayana Aditya Madineni , Siddhartha Ampolu and 2 other members with unpublished profiles.

Project Description


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


#spend tracing #spend insights #spend by agency #top n agencies #top n suppliers #spend by agency and supplier

Data Story


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/qrida
contract-disclosure-report-2019-20


Evidence of Work

Video

Homepage

Team DataSets

QRIDA_Contract Disclosure Report 2019-20

Description of Use QRIDA_Contract Disclosure Report 2019-20

Data Set

Department of QLD State Development DSDMIP Contract Disclosure December 2019

Description of Use Department of QLD State Development DSDMIP Contract Disclosure December 2019

Data Set

Department of Housing and Public Works Contract Disclosure

Description of Use Department of Housing and Public Works Contract Disclosure

Data Set

SQ Contracts

Description of Use Stadiums Queensland contracts >$10k

Data Set

Queensland Building and Construction Commission Contracts Disclosure

Description of Use Queensland Building and Construction Commission Contracts Disclosure

Data Set

Department of Transport and Main Roads Contract Disclosure

Description of Use ransport and Main Roads Contract Disclosure

Data Set

GCWA_Contract Disclosure Report 2019-20

Description of Use Gold Coast Waterways Authority Spend

Data Set

Queensland Rail Contract Disclosure FY2019-2020

Description of Use Rail Contract spend

Data Set

Challenges

Small Business and Tourism

Small business and the tourism industry need your help to survive! How can we get them back on track?

Go to Challenge | 6 teams have entered this challenge.

Identifying government investment for enhancing community safety

How can governments apply resources so as to proactively address social issues before they escalate and require reactive interventions (e.g. social work, law enforcement etc.)?

Go to Challenge | 16 teams have entered this challenge.

Government Spending

What can we learn from government spending data?

Go to Challenge | 2 teams have entered this challenge.