Skip to Main Content
← Our Work

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.

Step 5 of 5

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.

Garcia Technology GroupGTG POWER BI & ANALYTICS EXAMPLE

Select a step to explore its role and settings. This walkthrough follows a fixed sequence.

100%

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

  • January

    Actual$200,000
    Target$210,000
  • February

    Actual$225,000
    Target$220,000
  • March

    Actual$250,000
    Target$245,000

Source Records in the Current Filter

Scroll horizontally to see all columns. Keyboard: focus the table, then use the arrow keys.

Source Records in the Current Filter
Source rowMonth / regionRevenueDirect costRevenue plan
JAN-CJanuary / central$120,000$78,000$125,000
JAN-WJanuary / west$80,000$56,000$85,000
FEB-CFebruary / central$135,000$85,000$130,000
FEB-WFebruary / west$90,000$61,000$90,000
MAR-CMarch / central$150,000$90,000$145,000
MAR-WMarch / 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 Definitions
MeasureRule
RevenueSUM(revenue), filtered by period and region
Gross marginSUM(revenue) − SUM(direct cost)
Margin rateTotal gross margin / total revenue; not an average of row percentages
TargetSUM(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