Trusted Viewpoint Spectrum analytics, without the build.
QuickLaunch Analytics delivers a pre-built semantic model for Viewpoint Spectrum, in Power BI or Databricks, covering job cost, accounts payable, accounts receivable, equipment and the general ledger on the same governed lakehouse our Vista customers run.
Ask Microsoft 365 Copilot, Claude or Databricks Genie for unbilled revenue by job this month, and the answer comes from the same governed Spectrum definitions your reports use.
Your jobs and financials, ready to analyze
The QuickLaunch Spectrum Application Pack covers Trimble Viewpoint Spectrum, the cloud construction ERP, down to the job: jobs, sub-jobs, phases and cost types, with WIP and over and under billings by job. Finance and your project managers read job cost from one set of definitions, so a job reads the same in the PM's report as it does at month-end.
Close the gap between Spectrum and the answers you need
Where most Spectrum teams are
- Reports pulled by hand from each module
- Construction financials stitched together in Excel
- Native reporting limited by your configuration
- Job and sub-job results hard to roll up
- Multi-company reporting done by hand
- Project managers and finance with different numbers
Where QuickLaunch takes you
- Ready-made reports across five modules
- Construction financials in one semantic model
- Jobs, sub-jobs, phases and cost types rolled up
- WIP and over and under billings by job
- Multi-company reporting in one place
- Finance and project managers on the same numbers
Automated data replication
Pipelines copy your Spectrum data into a governed lakehouse, automatically.
Analytics-ready foundation
Your Spectrum data is centralized with the rest of your enterprise data in one governed lakehouse, transformed for analytics.
Spectrum semantic model
Relationships, hierarchies and construction measures, in Power BI or Databricks.
Reporting and AI answers
Reports and dashboards for every module, plus AI answers in Microsoft 365 Copilot, Claude or Databricks Genie from the same trusted definitions.
Construction know-how, built in
We call this application intelligence: the Spectrum and construction expertise QuickLaunch builds into the pack, so your data arrives in business terms with the job-level math worked out. Your BI team starts from the Spectrum job-level logic instead of rebuilding it, and owns and extends it from there.
Decoding and transformation
Spectrum data, shaped around the job.
- Cost types (labor, material, equipment, subcontract) separated across job, phase and cost type
- Your job structure mapped: jobs, sub-jobs, phases and cost types, with billing read through accounts receivable against the job and customer
- Cross-module questions answered in one place: job cost against open AP, or job revenue with open AR for job and customer profitability
Enrichment and business logic
The construction math, settled once.
- Earned revenue and over and under billings calculated the same way everywhere
- WIP schedule logic at the job level
- Job, sub-job, phase and GL hierarchies set up during implementation, for summary and drill-down reporting
Governance and scale
Secure and consistent as you grow.
- Row-level security so people see only the data they're authorized to see
- Multi-company consolidation across your Spectrum companies
- Fiscal and job calendars set up during implementation, including weekly and biweekly cycles
Chat with your Spectrum data. Trust the answer.
AI reads Spectrum tables fine. What it lacks is your business logic.
- Microsoft 365 Copilot and Claude answer from the same Spectrum measures as your reports, and each answer shows the measure and filters behind it. On Databricks, the same definitions can live as Unity Catalog metric views, so Databricks Genie answers from them too.
- Your row-level security carries into Microsoft 365 Copilot.
- The Spectrum business logic is written once in the semantic model: earned revenue on percent complete, over and under billings, and cost types by job and phase. Your reports, your analysts and your AI all work from the same trusted definitions.
Microsoft 365 CopilotClaudeDatabricks GenieMicrosoft 365 CopilotSpectrum Job Cost and AR4 jobs hold most of this month's unbilled revenue, $682K in total:
| Job | Earned to date | Unbilled |
|---|---|---|
| 3120-04 Eastside Water Treatment | $1,916,000 | $286,000 |
| 3087-02 Mesa Ridge Grading | $1,204,000 | $185,000 |
| 3142-01 Canyon Road Widening | $862,000 | $123,000 |
| 3109-03 Harbor Lift Station | $540,000 | $88,000 |
Unbilled revenue is earned revenue (percent complete on cost) less billed to date, as defined in the semantic model.
Cost to date rose $256,000 this month, mostly from subcontract invoices posted in payables:
Insight: the job moved from 52% to 63% complete, but nothing has been billed since last month. Including this work in the month-end progress billing closes most of the $286,000 gap.
5 Spectrum modules, the financial and job-level core
Every module comes with ready-made Power BI reports on the Spectrum semantic model. Pick a module to see its reports and the KPIs they cover.
General Ledger
Finance · 1 perspective
Gives finance a complete view of company financial health by analyzing balances and activity on the general ledger, including both actuals and budgets.
Key KPIs and reporting use cases
- Generate financial statements
- Analyze balances and activity by fiscal year and period
- Conduct budget vs. actual analysis
Accounts Payable
Finance · 1 perspective
Improve cash flow and strengthen vendor relationships with a clear view of all AP invoice and payment activity.
Key KPIs and reporting use cases
- Track invoice and payment amounts
- Monitor aging and cash flow
- Analyze spend by vendor and job
Accounts Receivable
Finance · 1 perspective
Improve your cash position and manage customer credit by analyzing billing and receipt activity against the job and the customer.
Key KPIs and reporting use cases
- Track invoice and receipt amounts by job and customer
- Analyze aging and Days Sales Outstanding (DSO)
- Monitor customer payment performance
Job Cost
Projects · 1 perspective
Protect project profitability with a complete financial picture of every job and sub-job, from budgeted and actual cost by phase and cost type through billings and earned revenue.
Key KPIs and reporting use cases
- Analyze budget vs. actual cost and revenue by job, sub-job, phase and cost type
- Monitor gross margin and profitability by job
- Work in progress (WIP) reporting and over and under billing analysis
Equipment
Equipment · 1 perspective
Get more from your heavy equipment by analyzing summary amounts and equipment usage costs by year and month.
Key KPIs and reporting use cases
- Track revenue, cost and usage hours for each piece of equipment
- Analyze maintenance costs and cost recovery
Reports shown with example data.
Spectrum reporting: why cloud ERP still runs through Excel
Spectrum runs in the cloud, but most of the reporting built on it still runs through spreadsheets. Why that happens, and what closes the gap.
Read the articleAI makes getting answers easy. We make them right.
Pointing AI at Spectrum gets you an answer in days. Making it right for the whole business still takes real work: defining the business logic, validating the numbers against your books and keeping it current through every Spectrum upgrade. QuickLaunch has done that work across 250+ implementations, so your team starts from a tested foundation instead of a first draft.
| Build it yourself, with AI or a partner | QuickLaunch Spectrum Application Pack | |
|---|---|---|
| Getting it right | Your finance and IT teams define and validate the logic, then redo it every time Spectrum changes. | Built and tested across 250+ implementations; your team validates it against your data instead of writing it from scratch. |
| First answer | Fast: point AI at the Spectrum tables | Fast too, from tested definitions |
| One definition for every team and AI tool? | Each team, analyst and AI tool defines job cost its own way | One definition for reports, analysts and AI |
| Cost of a wrong answer | Decisions made on numbers no one can trace | Every number traces back to Spectrum |
| When the builder leaves | The know-how leaves with them | Your team extends it, and we keep it current through Spectrum upgrades |
Granite Construction started on JD Edwards with QuickLaunch, then added Vista and is adding OneStream on the same foundation after an acquisition. A Spectrum Application Pack fits on a foundation the same way.
Contractors that run on QuickLaunch
On Viewpoint Vista “Our president was blown away by the new dashboards, and that was even before they were complete. This is clearly the future of reporting for the construction industry.”Steve Moua, Assistant Controller, Sukut Construction Read the Sukut case study →
Runs the QuickLaunch Spectrum Application Pack.
The Spectrum Application Pack runs on the Foundation Pack
Spectrum Application Pack
The Spectrum construction logic, the semantic model and the reports, in Power BI or Databricks.
Salesforce
OneStream
Foundation Pack
Automated pipelines from Spectrum and a governed lakehouse on Databricks or Microsoft Fabric, in your own cloud tenant.
Live in weeks
Planning and kickoff
- Customer Success readiness and planning
- Technical readiness
- Project kickoff
Foundation setup
- Data replication planning
- Lakehouse networking and setup
- Pipeline and connectivity validation
Configuration and validation
- Requirement sessions: security, account hierarchy, financial reports
- Configuration and internal validation
- Your team's validation and sign-off
Knowledge transfer and close
- Knowledge transfer sessions
- Production deployment and go-live support
- Handoff to Customer Success and support
After go-live
QuickLaunch Training
Role-based courses for business users, report designers and administrators.
See the courses →QuickLaunch Community
Release notes, known issues, education sessions and support for customers.
Visit the Community →QuickLaunch Support
Submit and track support tickets in the QuickLaunch Community.
Get support →Spectrum Application Pack: FAQ
What is the QuickLaunch Spectrum Application Pack?
A pre-built semantic model for Trimble Viewpoint Spectrum, the cloud construction ERP, delivered in Power BI or Databricks. It covers five modules: general ledger, job cost, accounts payable, accounts receivable and equipment, with WIP and over and under billings at the job level. It runs on the QuickLaunch Foundation Pack.
How is this different from building our own Power BI reports?
You start from a pre-built semantic model instead of a project you have to scope, build and maintain. Most teams are production-ready in weeks, built right the first time, and your team doesn't need deep knowledge of Spectrum's data structures.
How does the pack connect to Spectrum?
Your Spectrum data is copied into your governed lakehouse, on Databricks or Microsoft Fabric, and the Application Pack builds the semantic model on top of it.
What Viewpoint Spectrum reporting does the pack cover?
Reporting across five modules: general ledger, job cost, accounts payable, accounts receivable and equipment. Job cost analysis follows your job and sub-job structure by phase and cost type, and includes work in progress and over and under billings against the job.
Can we report across Spectrum and our other systems?
Yes. The Spectrum Application Pack runs on the same Foundation Pack lakehouse as the Vista and JD Edwards packs, so companies that run more than one system, often after an acquisition, can report across all of them from one foundation.
Do we need the QuickLaunch Foundation Pack?
Yes. The Foundation Pack provides the pipelines, the governed lakehouse and the analytics layer. The Spectrum Application Pack adds what is specific to Spectrum: the construction logic, the semantic model and the reports.
Can AI tools use the Spectrum semantic model?
Yes. Microsoft 365 Copilot with Fabric data agents works from the same Power BI semantic model as your reports, and your security rules carry into Microsoft 365 Copilot. Claude connects to the semantic model through Microsoft's native MCP, with each person's own sign-in, so people can only open semantic models they already have access to. On Databricks, the same definitions can live as Unity Catalog metric views, so Databricks Genie answers from them too.
What Power BI licensing do we need?
The pack works with Power BI Premium Per User. For larger semantic models and heavier use, we recommend a Microsoft Fabric capacity. AI features such as Copilot need a paid Fabric capacity of F2 or larger.
See Spectrum analytics in a live demo
Walk through the five module reports on demo data, then ask Microsoft 365 Copilot a job cost question and see the measures it used.
Job Cost
Microsoft 365 Copilot