Dataset.docx655dda974b5c914220

docx

School

Mount Kenya University *

*We aren’t endorsed by this school

Course

240

Subject

Management

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by mmakau2016

Dataset - CanadaBuys Contract History for the year 2022 - 2023 https://open.canada.ca/data/en/dataset/4fe645a1-ffcd-40c1-9385-2c771be956a4 Teamwork Rubric - https://learningspace.myucw.ca/d2l/le/content/11449/viewContent/331037/View Student Project Assignment Rubric - https://learningspace.myucw.ca/d2l/le/content/11449/viewContent/331037/View Business Analytics Course Assignment: Canada Contract History Analysis using Tableau Introduction Welcome to the Business Analytics course assignment! In this project, you will work in teams to analyze the Canada Contract History dataset. The dataset includes information about various government contracts, and your task is to clean the data, perform exploratory data analysis (EDA) using Tableau, and perform regression/ML analysis on questions of your choice to derive meaningful insights. Dataset Description The dataset comprises the following columns: contract-number award_date gsin gsin-description_en competitive-tender_en supplier-standardized-name supplier-address-city supplier-address-prov-state

supplier-address-postal-code supplier-address-country organization-employee-count_en total-contract-value end-user-entity_en contracting-entity-office-name_en contracting-address-street-1 contracting-address-street-2 contracting-address-city contracting-address-prov-state contracting-address-postal-code contracting-address-country Instructions 1. Data Cleaning Your first task is to clean the dataset. Perform the following steps: Remove duplicate rows from the dataset. Check for missing values and handle them appropriately. Ensure consistency and accuracy in data entries. 2. Exploratory Data Analysis (EDA) using Tableau Use Tableau to create insightful visualizations that provide a comprehensive understanding of the dataset. Some hints below but I expect groups to be creative and perform various types of analysis. Example Analysis (These are just hints.. you can do much more): Distribution of contract values.

Geographic distribution of suppliers and contracting entities. Trends over time in contract awards. Perform Machine Learning based analysis. Forecasting for a company of your choice. Submission Guidelines Prepare a comprehensive report. Ensure that your report is well-organized, clearly written, and includes visualizations where necessary and in APA format.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

SECTION C.docx

NEW PPT (1).pptx

BUAD2000_TAREA_4-1_Page_5.png

Destructive Leader Behaviour Scale.docx

Group 51.docx

The history and origins of strategic planning is intrinsically tied to military history.docx

requirement..docx

Ethical Case Analysis of Current Events Topic.docx

W06 Quiz TA 115.docx

Personal Characteristics Essay.pdf

GABRIEL CIRPACI MP2 (new).docx

Cap 225.docx

Recommended textbooks for you

Management, Loose-Leaf Version

Management

ISBN:9781305969308

Author:Richard L. Daft

Publisher:South-Western College Pub

MARKETING 2018

Marketing

ISBN:9780357033753

Author:Pride

Publisher:CENGAGE L

Principles of Management

Management

ISBN:9780998625768

Author:OpenStax

Publisher:OpenStax College

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

Foundations of Business (MindTap Course List)

Marketing

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

Foundations of Business - Standalone book (MindTa...

Marketing

ISBN:9781285193946

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Management, Loose-Leaf Version
Management
ISBN:9781305969308
Author:Richard L. Daft
Publisher:South-Western College Pub
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Foundations of Business - Standalone book (MindTa...
Marketing
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning