GTG POWER BI & ANALYTICS EXAMPLE / PUBLIC SAMPLE PLAYGROUND
One Set of KPIs. A Report You Can Trace.
Explore a fictional service-business dashboard. Filter the period and region, switch between revenue and gross margin, and trace every total to its source and measure definition.
Explore This Workflow
Select a step, change its settings, then run the example to see what changes. The workflow follows a fixed sequence. No login is needed. Changes reset when you reload or leave this page.
This public playground uses fictional data. Your changes affect this fictional example only.
Showing the result for the current connections and settings.
THE STARTING POINT
GTG Helps a Fictional Services Team Agree on Performance
Northstar’s leadership wants revenue and gross margin to use the same source records and filters.
- Business
- Northstar Field Services (fictional)
- Period
- January–March
- Region
- Central + West
- Situation
- Six monthly regional actual-and-target records.
Illustrative GTG workflow with fictional data. Nothing is sent to GTG, a CRM, an email service, or a calendar.
Select a step to explore its role and settings. This walkthrough follows a fixed sequence.
ACTUAL VS TARGET / SELECTED CONTEXT
Build Dashboard
Compare revenue or gross margin against a selected target and inspect the monthly movement.
Revenue uses the original plan target. Change the metric or target to compare the result.
Configure Build Dashboard
These settings apply to fictional sample data. Run the configured sample after a change.
Revenue is $675,000 against $675,000 (100% of target). Every selected source row is included once.
- Source records
- 6
- Months in scope
- 3
- Regions in scope
- 2
- Reconciliation differences
- 0
THE BUSINESS OUTPUT
Northstar Performance Dashboard — Example
- Revenue
- $675,000
- Gross margin
- $240,000 · 35.6% of revenue
- Revenue vs plan target
- $0 variance · 100% attainment
- Implementation context
- Browser-local reporting example. This demonstrates analytics behavior GTG can implement; it is not a live or embedded Microsoft Power BI report.
Illustrative USD measures from fixed fictional data. No Power BI tenant, credentials, refresh, licensing, or row-level security is connected.
Revenue by Month
Revenue in USD. Actual and target use the same reporting filters.
ActualTarget
Source Records in the Current Filter
Scroll horizontally to see all columns. Keyboard: focus the table, then use the arrow keys.
| Source row | Month / region | Revenue | Direct cost | Revenue plan |
|---|---|---|---|---|
| JAN-C | January / central | $120,000 | $78,000 | $125,000 |
| JAN-W | January / west | $80,000 | $56,000 | $85,000 |
| FEB-C | February / central | $135,000 | $85,000 | $130,000 |
| FEB-W | February / west | $90,000 | $61,000 | $90,000 |
| MAR-C | March / central | $150,000 | $90,000 | $145,000 |
| MAR-W | March / west | $100,000 | $65,000 | $100,000 |
Measure Definitions
Scroll horizontally to see all columns. Keyboard: focus the table, then use the arrow keys.
| Measure | Rule |
|---|---|
| Revenue | SUM(revenue), filtered by period and region |
| Gross margin | SUM(revenue) − SUM(direct cost) |
| Margin rate | Total gross margin / total revenue; not an average of row percentages |
| Target | SUM(selected measure’s plan), within the same filter |
Bring your own business problem, systems, and constraints into a GTG discovery conversation.
Build Your Discovery Brief