Compensation Analytics

1 Load Compensation Data Upload an Excel file to build the cube

📊

Drop your Excel file here, or click to browse

Supports .xlsx · Columns auto-mapped to canonical schema. Review before ingesting.

Column Mapping Review

Source Column	Canonical Field	Tier	Confidence	Reason

2 Cube Viewer Browse aggregated segments · click headers to sort

3 Query in Plain English Translated to SQL and executed against the cube

Total comp cost by SBU for FY2024 Attrition rate by job band Average base salary by job family Pay vs P50 market benchmark by SBU Headcount trend by fiscal year Top 10 highest paid job roles Merit increase % by performance rating Which SBU has the highest attrition?

Results

Generated SQL

4 What-If Scenario Analysis Simulate compensation adjustments and compare against baseline

Salary Increase

Bonus Adjustment

Headcount Change

Attrition Change

LTI Adjustment

Financial Intelligence

CFO- and CHRO-grade affordability, scenario, and goal-seek analytics — built directly on top of the compensation cube.

1 Financial Inputs Enter annual figures for each fiscal year present in the cube

Fiscal Year	Revenue (₹)	Operating Margin %	Approved Comp Budget (₹)	Headcount	Workforce Cost (₹)

2 Multi-Year Trends & YoY Side-by-side fiscal-year view with year-over-year deltas

Save financial inputs for at least one fiscal year to see trends.

3 Derived Financial Metrics — Single Year

Save financial inputs to see derived metrics.

4 Scenario Planner Plan workforce decisions for an upcoming fiscal year — see cashflow impact and test affordability against targets

Workforce Plan Assumptions

Salary Increment % — applied to prev year cost per employee

Headcount Growth % — net change over prev year headcount

Attrition Rate % — expected annual attrition

Goal-Seek

Goal-seek reverse-engineers the lever value that hits your financial target, independent of the scenario levers on the left.

5 Conversational Financial Intelligence Use the chat assistant — it now understands financial questions

Open the chat assistant (💬 button) and ask questions like:

What is our compensation cost as a percentage of revenue for FY2025? Show revenue per employee by business unit for FY2025 Which business unit has the highest workforce cost per employee? Compare cost-per-employee across fiscal years

Intelligence Studio

Prompt-driven orchestration — intent detection, analytical decomposition, RAG-enhanced reasoning, and deterministic validation. LLM is the planner; all numbers are computed directly from the cube.

Session Turn 0 FY — SBU — Intent —

✦ Ask a Strategic Compensation Question

Context override:

Can we afford a 12% salary increment for FY2026 and still maintain 20% operating margin? What is driving the high attrition in the Engineering job family? Which SBUs are overpaying vs market benchmark? What workforce cost reduction is needed to hit 22% margin next year? Simulate the impact of 15% headcount reduction across all SBUs What is the attrition cost exposure for high-performers leaving this year? Compare our compensation policy to what the uploaded policy document says

📚 Policy Documents Upload compensation policies, guidelines, or benchmarks for retrieval-augmented analysis

📄

Drop policy documents here, or click to browse

Supports .pdf · .txt · .md — indexed locally with TF-IDF, no external API

No documents indexed yet. Upload a policy document to enable RAG-enhanced answers.