MARKET ANALYSIS
PROJECTS / ISP PRICING
Project Overview
Local ISP Value-for-Money Analysis – evaluating local ISP packages to find which business plans offer the best value per Mbps. The supporting dashboard and two Excel worksheets include dedicated metrics counters and visual summaries for these performance indicators.
Project Details
Tools & Methods
Excel engine; data gathered from public ISP package pages; dual-sheet structure (ISPs and Packages); removed empty columns; calculated cost_per_mbps and best_value_flag for optimization.
Data Cleaning & Preparation
Removed unnecessary columns; standardized package naming conventions; verified speed and pricing accuracy; synchronized ISP IDs across worksheets for relational integrity.
Calculations & Findings
Analyzed cost per Mbps efficiency; utilized best_value_flag to highlight internal cheapest plans; observed that premium speeds do not always scale linearly with value metrics.
Conclusion
The finalized analysis enables local businesses to perform rapid plan comparisons and select high-performing internet packages based on the best value per Mbps.
Note: The interactive dashboard and Excel worksheets feature counters and visual summaries for these core performance metrics.