Platform
Overview
Connectors
Universal MCP Server
Managed Warehouse
Automation API
Partner Program
Security
Pricing
Resources
Knowledge base
Our blog
Services store
Case studies
Youtube
Reddit
Contact
About
About us
Our story
Meet the team
Charity
Testimonials
Sign in
Book a demo
Free trial
Welcome to our
Lightspeed X-Series
blog series
Articles & insights to
supercharge your Lightspeed X-Series data
using
SYNC
HUB
All sections
Data Accessibility
Features
Insights
Reporting
Lightspeed X-Series
Blog
The Lightspeed X-Series MCP and reporting services are good...but you (probably) still need SYNCHUB
Data Accessibility
As Lightspeed X-Series expands its own MCP and reporting services, you may find you no longer have a requirement for
SYNC
HUB. And
that's absolutely fine
...just read this first.
Our new Lightspeed X-Series connector for Slack brings your data to your favourite collaboration platform
Features
See how we can
supercharge
your collaboration and workflows by bring your Lightspeed X-Series data to your
fingertips
.
Using Insights to take historical snapshots of your Lightspeed X-Series data
Insights
A common limitation of 3rd-party APIs is that they serve only
current
data. But what if you want to
retain the history
of your data as it changes over time?
Aggregating multiple Lightspeed X-Series accounts into a single BI report
Reporting
The existing Lightspeed X-Series reporting tools are numerous and comprehensive. But if you're running multiple accounts and need to consolidate data across your entire organization, things get a
little more difficult
.
How to query your Lightspeed X-Series data from Microsoft Excel
Reporting
Still exporting CSVs and rebuilding the same pivot tables every month? Point
Microsoft Excel
at a live copy of your Lightspeed X-Series data instead - your formulas and charts stay put, and updating them becomes
a single click
.
How to query your Lightspeed X-Series data from Power BI
Reporting
Querying the Lightspeed X-Series API directly from
Power BI
is slow and fragile. Stage your data in a relational database first, then build
interactive dashboards
that combine Lightspeed X-Series with the rest of your business.
How to query your Lightspeed X-Series data from Google Sheets
Reporting
Google Sheets
is where many teams already share their numbers. With a few lines of Apps Script, you can query your Lightspeed X-Series data straight into a sheet and give everyone
one shared, up-to-date view
.
How to query your Lightspeed X-Series data from Google Data Studio
Reporting
Need a dashboard you can share with a link, without paying for BI licences? Connect
Looker Studio
(formerly Google Data Studio) to your Lightspeed X-Series data using its built-in SQL Server connector -
no exports, no plugins
.
Need more?
Check the
SYNC
HUB blog
Our regular blog includes plenty of other helpful articles