Case Study: Yukon Government Awarded Contracts Analysis

Part 05

Analysis

After performing all the steps explained in previous posts, it is time to analyze.

Important Details

Data Insights | Contracts

In the EDA, we noticed that the contracts were subdivided by a category named “change order number.”

This variable states whether a contract is original or renewed several times. For the simplicity and accuracy of the rest of the analysis, we decided to use only the original contracts.

Remember that the historical data obtained is from the fiscal years 2021-22 to 2023-24. (The fiscal years begin in April and end in March of the following year.)

You should already know what you want to know about the data. Establishing key questions to guide your analysis will help you optimize your time and computational resources throughout the process.

However, sometimes, to answer your initial questions, you will probably have to ask yourself more questions, do extra calculations, and link all the information you are obtaining to answer your initial question.

It is like being a detective, finding and joining the pieces needed to solve the puzzle!

Questions to Explore in this Post

What is the total number of contracts?

What is the total amount ($) of all the contracts?

What is the percentage of Yukon Businesses by number of contracts?

Whitehorse is in the top three work communities?

Tools

Data Insights | Analysis Tools

For the analysis, you can use SQL queries and programming tools like Python, Power BI, or even Excel!

Answers

There are 15,830 total contracts.

The total amount is $1,687,234,334.

There are 77.21% of Yukon Businesses registered.

Yes, Whitehorse is the work community with more contracts.

How to Dive Deeper?

You can use variables as filters to unlock more possibilities. For example, to make a comparison between small and large businesses you can filter by the total contracts amount. It is known that small businesses commonly do not get granted big contracts (above $50k), so you can use this number to find out the average number of small businesses, separate them by Yukon or Non-Yukon Business, identify the top acquisition method, tender class or even contract type.

Another option is to identify patterns using the contract start dates. Are the number of contracts given each fiscal year the same or different? Which months have more contracts started? How many contracts does a specific department have? And so much more. Your imagination and curiosity are the limit.

In the next and final post, we will talk about reports and dashboards … stay tunned!

Transform your data into winning strategies with our Business Intelligence services

At Bizont, we pride ourselves on offering innovative web and application development solutions and empowering our clients with advanced Business Intelligence: Data Analytics, and Business Analysis services.

With a team of highly skilled professionals, we are prepared to transform complex data into actionable insights that drive strategic decisions and improve operational efficiency. If you want to maximize the value of your data and gain a competitive advantage in the marketplace, we invite you to discover how our solutions can help you achieve your goals.

Contact us today, and we will take your business to the next level together!

Transform your data into winning strategies with our Business Intelligence services

At Bizont, we pride ourselves on offering innovative web and application development solutions and empowering our clients with advanced Business Intelligence: Data Analytics, and Business Analysis services.

With a team of highly skilled professionals, we are prepared to transform complex data into actionable insights that drive strategic decisions and improve operational efficiency. If you want to maximize the value of your data and gain a competitive advantage in the marketplace, we invite you to discover how our solutions can help you achieve your goals.

Contact us today, and we will take your business to the next level together!