Project Description
I’m looking to turn a scattered set of rollout spreadsheets into one clear, interactive dashboard that lets me see exactly where every site sits in the life-cycle—from initial installation all the way to On-Air. I have no fixed preference on the platform, so feel free to build in either Excel (Power Query/Pivot, slicers, VBA if needed) or Power BI; choose whichever will let you structure the data model cleanly and keep future updates simple.
Core view I need
• Progress by site and phase: Installation → Integration → Testing → On Air, with automatic percentage-complete calculations.
• At-a-glance flags for any milestones slipping behind their target dates.
• Filters by region, vendor, tech (2G/3G/4G/5G) and project manager.
Nice-to-have layers
If you can easily weave them in, I’d like space for classic telecom KPIs—call volume trends, network performance scores and customer-satisfaction survey pulls—so the same dashboard can grow with us.
Deliverables
• The working dashboard file (Excel *.xlsx / *.pbix) fully linked to sample data tables.
• A short “read-me” or Loom walkthrough showing how to refresh or expand the data set.
• Clean, commented formulas/queries so another analyst can follow your logic.
I’ll supply the raw progress tracker sheets as soon as we start; just let me know your preferred column layout and any lookup tables you need me to prep.
Example Dashboard : https://app.powerbi.com/view?r=eyJrIjoiYzUxZDgzMmYtNTg0Yy00NjI4LThhY2UtOTY3ODgyYjIwMjc2IiwidCI6ImZjNzQzMDc1LTkzZWQtNGE1Yy04MmMwLWNhNWVhYzkxNDIyMCIsImMiOjEwfQ%3D%3D