SkillsGuide.in
Lab 04
25 mins

BI Dashboard Design Lab

Mission Briefing

Create an executive view from 3 prepared sales tables. Choose relationship keys, define measure templates, and configure linked charts.

Success Criteria
  • Complete scenario tasks and verify feedback.
Interactive Sandbox Guardrails
Relationship CanvasDAX/Measure BuilderGrid LayoutCross-Filter Engine

Deterministic browser simulation with server-authoritative scoring. Zero setup required.

Total Sales Measure₹45,000Sum(Sales[Revenue])
Profit Margin %36%₹16,200 Gross Profit
Distinct Customers4DistinctCount(CustID)
Model Relationship1:Many Star SchemaClean single-direction filter

1. Semantic Model Relationship Keys

Star-Schema Model
Customers (Dimension) → Sales (Fact Table) Cardinality:
Cross-Filtering Category Slicer:

Sales Fact Table Records (5 Rows)

Order IDCustomer IDCategoryRevenueCost
S-01C-01Enterprise₹12,000₹8,000
S-02C-02Mid-Market₹5,000₹3,500
S-03C-01Enterprise₹9,000₹5,000
S-04C-03Enterprise₹15,000₹9,500
S-05C-04SMB₹4,000₹2,800

2. Measure Template Builder

Intelligent Adaptive Discovery

Indian Career Compass & Transition Blueprint

Personalized specifically for your domain background (CA, Law, Pharmacy, Teaching, Tech, Engineering & Commerce). Questions dynamically adapt so you are evaluated on relevant skills — never forced into mismatched generic questions.

Adaptive 30-Signal EngineDomain-Specific Competency MatchingZero Unwanted Generic Coding for Non-Tech5 Adaptive Steps
STEP 1 OF 50 / 30 signals captured

Your Starting Point

Every educational background has specific high-leverage advantages. Let’s map yours.

💡 Your background unlocks specific accelerated career pathways without starting from scratch.

💡 Optional. Used to prevent suggesting career pathways with a negative pay delta.

💡 Used to benchmark local hiring clusters in your regional market.

🔒 Complete client-side privacy. Answers stay in your browser and are never uploaded without permission. Export your blueprint below to save a copy.