Excel Dashboard for Investments and Data collection in healthcare service and digital health -- 3

I have a fixed list of 30 investment opportunities that must be organized into a single Excel workbook with multiple sheet for each one and visualized through an interactive dashboard.

You must generate and collect the DATA from official market data online

The core data sheet has to capture, at minimum, the following for every opportunity:
• Market value – show both the exact figure (USD or SAR) and a short text explanation of how that value was reached.
• Country – all are in KSA, but still record the field for completeness.
• Confirmation of current business presence in KSA.
• An in-depth company overview (strategy, products, recent milestones, competitive position).
• Expected number of jobs the project will create within KSA.
• A detailed service or investment execution plan.
• Any local partner companies involved.

After the data sheet is complete, build a dashboard inside the same file that allows me to filter or segment by market value, sector, job-creation potential and KSA presence. Use slicers, pivot charts and clear, executive-level visuals so I can instantly see high-value or high-employment deals.

Deliverables
1. Excel workbook (.xlsx) containing:
– “Raw Data” tab with the 30 fully populated records.
– Clean table structure ready for future append.
2. “Dashboard” tab with dynamic charts, slicers and summary metrics refreshing off the data table.
3. Brief hand-off note explaining any formulas, pivot sources or Power Query steps used.

Acceptance criteria: all 30 rows completed with no empty mandatory fields; numeric values cross-checked for consistency with their descriptive notes; dashboard filters working without errors.

Each opportunities need estimated ~ 300 company from all over the world that i need to attract to invesment to KSA from USA, UK, Germany , europe and other high market value company.

I will supply the initial list of opportunities as soon as we start.