🧠 Texas IT Contract Awards Analysis

This project analyzes two years of IT contract awards across Texas state agencies using public data from Texas SmartBuy and DIR Vendor Awards. The goal is to identify trends, top vendors, most active agencies, and strategic bidding opportunities for a tech company seeking contracts in:

• IT Staffing
• Cloud Services
• Cybersecurity
• Unified Communications
• Workforce Development

---

📂 Repo Structure

TS_Project/
├── data/
│   ├── raw/                  # Original exported Excel files
│   ├── processed/            # Cleaned and consolidated master tracker
│   └── analysis/             # Python scripts, insights, and summary files
├── charts/                   # Generated visualizations
├── README.md                 # ← You are here
└── analysis_checklist.md     # Full checklist of Analyze phase outputs

---

📊 What You'll Learn

• Which agencies award the most IT contracts
• Who the top vendors are
• What services are in demand
• Which contracts offer the best strategic fit

---

🧪 How to Run the Analysis (Python)

This project was built and run using a Python virtual environment (venv) with the following tools:

• pandas
• matplotlib
• openpyxl

You can run scripts by activating your environment:

cd TS_Project
.venv\Scripts\activate
python path/to/script.py

---

📁 Access the Full Project Data

You can view the complete dataset, cleaned trackers, and charts used in this analysis via the link below:

🔗 Open Texas IT Contract Analysis Data Folder

All strategic deliverables (PDFs) including the executive summary, action checklist, and analysis log are available here:

🔗 Texas IT Docs Folder (OneDrive)

📊 Download Stakeholder Slide Deck (PPTX)

---

📋 Analyze Phase Summary

For a detailed breakdown of all steps completed in the analysis phase, see:

👉 analysis_checklist.md

---

🛠️ Author

Kent Ward
Built as part of a strategic initiative to help position a tech company for government IT contracting opportunities.