​

Connect Valiyou to Power BI with API

​

Why Power BI Integration?

• 📊 Custom Dashboards: Build sponsor-facing dashboards with your branding
• ⚡ Real-Time Data: Auto-refresh keeps dashboards current
• 📈 Advanced Analytics: Combine Valiyou data with other sources
• 🎯 Self-Service: Sponsors can explore data without asking for reports
• 💰 Scalability: One dashboard template for all sponsors

​

Integration Architecture

​

Part 1: Create API Key in Valiyou

​

Step 1: Create Read-Only API Key

1. Click “Create API Key” button
2. Fill in form:
   • Key Name: Power BI Integration
   • Description: Read-only access for Power BI dashboards
   • Scopes: Select what data you need
     • ☑ Valuations (for metrics)
     • ☑ Player Sales (if tracking transfers)
     • ☑ Clubs (for organization info)
   • Operations: ☑ GET only (read-only)
3. Click “Create API Key”
4. IMPORTANT: Copy API key immediately
   • Format: vly_abc123def456...
   • Store in password manager
   • You cannot view it again!

​

Part 2: Configure Power BI Connection

​

Step 1: Open Power BI Desktop

1. Launch Power BI Desktop
2. Click Get Data (Home ribbon)
3. Search for “Web”
4. Select “Web” connector
5. Click Connect

​

Step 2: Enter API Endpoint URL

1. Select Advanced option (not Basic)
2. Enter API endpoint in URL parts:

https://valiyou.io/api/v1/valuations

3. Add URL Parameters:

• Skip URL parameters
• Click OK
• In next dialog, select “Web API” authentication
• Add custom header:
  • Key: Authorization
  • Value: Bearer vly_YOUR_API_KEY_HERE

• Add parameter: club_id = YOUR_CLUB_ID
• Add parameter: api_key = vly_YOUR_API_KEY_HERE
• Click OK

​

Step 3: Preview and Transform Data

1. You’ll see JSON data preview
2. Click “To Table” button (Transform ribbon)
3. Click “Expand” icon (double arrows) next to Column1 header
4. Select fields to include:
   • ☑ valuation_date
   • ☑ final_total_value
   • ☑ calculated_sales_value
   • ☑ calculated_media_value
   • ☑ tv_viewers
   • ☑ social_impressions
   • ☑ attendance
   • (select all fields you need)
5. Click OK

​

Part 3: Transform and Clean Data

​

Step 1: Set Data Types

1. For each numeric column:
   • Right-click column header
   • Change Type → Decimal Number (for valuations)
   • Change Type → Whole Number (for counts like viewers)
2. For date columns:
   • Right-click valuation_date
   • Change Type → Date

​

Step 2: Rename Columns

1. Double-click final_total_value header
2. Rename to: Total Valuation
3. Repeat for other columns:
   • calculated_sales_value → Sales Value
   • calculated_media_value → Media Value
   • tv_viewers → TV Viewers
   • social_impressions → Social Impressions

​

Step 3: Add Calculated Columns

1. Click Add Column ribbon
2. Click Custom Column
3. Enter formula:

= [Total Valuation] / 500000

4. Name column: ROI Multiple
5. Click OK

1. Click Add Column ribbon → Custom Column
2. Enter formula:

= "Q" & Number.ToText(Date.QuarterOfYear([valuation_date]))

3. Name: Quarter
4. Click OK

​

Part 4: Load Data to Power BI

1. Review all transformations in Applied Steps (right panel)
2. Click Close & Apply (Home ribbon)
3. Data loads into Power BI model
4. Wait for load to complete (status bar shows progress)

​

Part 5: Create Visualizations

​

Dashboard Layout Suggestions:

• Card: Total Valuation (latest quarter)
• Card: Quarter-over-Quarter Growth %
• Card: Total Reach (sum of all impressions)
• Card: ROI Multiple

• Line Chart: Valuation over time (X=Date, Y=Total Valuation)
• Stacked Bar Chart: Sales vs. Media Value by Quarter
• Area Chart: Social Impressions trend

• Pie Chart: Media Value by Channel
• Table: Detailed metrics by date
• Gauge: YoY Growth %

​

Example: Create Valuation Trend Line Chart

1. Click Line Chart icon (Visualizations panel)
2. Drag fields:
   • X-Axis: valuation_date
   • Y-Axis: Total Valuation
   • Legend: Quarter (optional)
3. Format chart:
   • Click Format (paint brush icon)
   • Set title: “Sponsorship Valuation Trend”
   • Enable data labels
   • Adjust colors to match branding

​

Example: Create Media Breakdown Pie Chart

1. Click Pie Chart icon
2. Drag fields:
   • Values: Media Value
   • Legend: Create calculated column for channel
3. Show percentages in labels

​

Part 6: Set Up Scheduled Refresh

​

Option A: Power BI Service (Cloud)

1. Click Publish (Home ribbon)
2. Select workspace (or “My Workspace”)
3. Click Publish
4. Open browser to Power BI Service
5. Find your report in workspace
6. Click ⋯ (ellipsis) next to dataset
7. Select Settings
8. Configure Scheduled refresh:
   • Frequency: Daily or Hourly
   • Time: Set refresh times (e.g., 9 AM daily)
   • Send failure notification: Enable
9. Click Apply

​

Option B: Manual Refresh

1. In Power BI Desktop: Click Refresh (Home ribbon)
2. Data updates from API
3. Republish to Power BI Service
4. Share updated dashboard

​

Part 7: Share Dashboard with Sponsors

​

Method 1: Embed in Web Page

1. Publish dashboard to Power BI Service
2. Click File → Embed → Publish to Web
3. Copy embed code
4. Add to sponsor portal website
5. Dashboard updates automatically with scheduled refresh

​

Method 2: Direct Share Link

1. In Power BI Service, open dashboard
2. Click Share button (top right)
3. Enter sponsor email addresses
4. Set permissions:
   • ☑ Allow recipients to view (read-only)
   • ☐ Don’t allow resharing
5. Click Share

​

Method 3: Export PDF

1. Open dashboard in Power BI Service
2. Click File → Export → PDF
3. PDF downloads with current data
4. Email to sponsor

​

Advanced Tips

​

Combine Multiple Endpoints

1. In Power Query, click New Source → Web
2. Enter URL: https://valiyou.io/api/v1/player-sales?api_key=...&club_id=...
3. Transform and load
4. Create relationships between tables:
   • Valuations table: valuation_id
   • Player Sales table: valuation_id
5. Build cross-table visuals

​

Parameter for Club ID

1. In Power Query: Manage Parameters
2. Create new parameter:
   • Name: ClubID
   • Type: Text
   • Current Value: your-club-id
3. Reference in API URL:
   Copy

   = "https://valiyou.io/api/v1/valuations?club_id=" & ClubID & "&api_key=..."
   
4. Duplicate dashboard, change parameter for different club

​

Add Benchmarks

1. Create manual table with benchmark data
2. Enter data → New Table
3. Input:
   Copy

   Benchmarks = DATATABLE(
       "Metric", STRING,
       "Benchmark", DECIMAL,
       {
           {"TV CPM", 30},
           {"Social Impressions", 10000000},
           {"Attendance", 75000}
       }
   )
   
4. Use in visuals to compare actual vs. benchmark

​

Troubleshooting

​

Dashboard Examples

• KPIs: Total Valuation, ROI, Reach
• Trend: Valuation line chart (quarterly)
• Breakdown: Media channels pie chart
• Table: Detailed metrics

• Cards: Current quarter valuation
• Gauge: YoY growth %
• Map: Geographic reach (if data available)
• Waterfall: Sales + Media = Total

• Line: Impressions trend
• Bar: Engagement by platform
• Table: Top posts (requires social API integration)

​

Next Steps

​

Related Guides

• Quarterly Sponsor Report - Manual reporting process
• API Keys Management - Full API documentation
• Close First Sponsorship - End-to-end deal flow

​

Need Help?