Business Analytics for Alvia Systems Inc

Project scope
Categories
Data visualization Data analysis Customer segmentation Market expansion Data scienceSkills
stakeholder engagement jupyter notebook business analytics python (programming language) project files coordinate systems scripting spatial analysis workflow automation data ingestionThe main objective of this project is to equip students with advanced geospatial intelligence and business‐driven spatial analytics skills by integrating provided wildfire maps with oil and gas pipeline datasets to identify high‑risk segments and their owning companies. Leveraging these insights, students will design targeted customer‑acquisition strategies for pipeline operators—using proximity‑based market segmentation and value‑proposition modeling—to drive proactive stakeholder engagement and market expansion. Students will collect and preprocess GIS data, execute spatial overlays and buffer analyses in QGIS/ArcGIS, automate workflows with Python scripts, and synthesize their findings into annotated risk maps and a concise, stakeholder‑ready assessment report.
Project Outcomes and Deliverables
Students will complete the following tasks and produce these deliverables to meet the project goal:
- Data Preparation
- Acquire and preprocess provided wildfire maps and publicly‑available oil and gas pipeline shapefiles.
- Clean and standardize attribute tables, ensuring coordinate systems match.
- Spatial Analysis
- Perform spatial overlay and buffer analyses in QGIS/ArcGIS to identify pipeline segments within defined proximity thresholds of active fire perimeters.
- Join buffer results to company ownership data to tag each high‑risk segment with its operator.
- Automation & Scripting
- Develop a Python script (or Jupyter Notebook) that automates data ingestion, spatial joins, buffer calculations, and map exports.
- Visualization & Reporting
- Generate annotated static maps (QGIS/ArcGIS) highlighting high‑risk segments, buffer zones, and ownership labels.
- Final Deliverables
- Comprehensive Analysis Report detailing data sources, methodology, results, insights, and actionable recommendations.
- GIS Data Package including cleaned shapefiles, project files, and the Python automation script(s).
- Annotated Map Exports (PDF/PNG) of risk zones with ownership callouts.
- Interactive Dashboard Prototype with basic filtering and risk‑visualization capabilities.
- 10–15 Minute Presentation (PowerPoint or PDF) summarizing key findings, maps, and suggested mitigation strategies.
Providing specialized, in-depth knowledge and general industry insights for a comprehensive understanding.
Sharing knowledge in specific technical skills, techniques, methodologies required for the project.
Direct involvement in project tasks, offering guidance, and demonstrating techniques.
Providing access to necessary tools, software, and resources required for project completion.
Scheduled check-ins to discuss progress, address challenges, and provide feedback.
Supported causes
The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.
About the company
Alvia Systems is a climate mitigation company dedicated to enhancing climate risk transparency and enabling site-level resilience to natural disasters. We specialize in utilizing advanced drone technology and ML-driven analysis to provide precise, comprehensive climate risk assessments for properties, aiding in informed decision-making and proactive disaster preparedness.
Portals

