Analytics Connector
Get more from your data with our analytics package. Our ready-made connector helps you quickly export data from Clue to Power Query for advanced reporting and data analysis. Use our templates to get started faster.
Clue Analytics Connector
To facilitate data extraction from Clue, we have developed the Clue Analytics Connector. With this connector, you can easily pull data via the API from Clue into Power Query, without the need for expertise in APIs, JSON, or programming.
For each Clue instance, the Clue Analytics Connector grants up to 5 users access.
What is Power Query?
Microsoft Power Query is a powerful tool that enables you to access and reshape data from various sources to suit your requirements. Integrated within Excel and available in all Microsoft Excel desktop applications on Windows, Power Query allows you to connect to hundreds of data sources.
Clue does not own or license this tool – you can find out more from the Microsoft website, including how to put the data into other reporting databases or tools.
Get started quickly with our templates
We provide ready-made templates that utilise Power Query to export data for use in Power BI and Excel.
These templates cover a wide range of common use cases, including data from multiple registers, child lists, and links within Clue. By adapting these templates to your specific needs, you can significantly reduce the time required for reporting and data manipulation.
Ongoing support and updates
The Analytics Connector is continuously maintained and updated by Clue with each release, ensuring uninterrupted data flow in the future. Meanwhile, we are developing new templates to help you get more from your data quickly.
In case you encounter any issues or have questions regarding the supported features of the Analytics Connector, our dedicated support desk is readily available to assist you in getting your data into Power Query.
Is the Clue Analytics Connector right for you?
Use the table below to help you consider various options available for extracting reporting data from Clue based on your specific needs:
Setup and support
Quick setup
- Immediate availability of licences and configuration upon purchase.
- Clue can provide a one-hour setup walkthrough for Power Query familiarity, enabling you to use the templates and export data promptly.
Custom support
- For any additional training or assistance beyond the provided templates, custom support can be obtained through separate purchase as professional services days.
- The Analytics Connector does not support customer-created custom work or additional templates.
Talk to your Customer Success Manager to learn more about the Clue Analytics Connector, or email customer.success@cluesoftware.com
In the latest episode of Joining the Dots, safeguarding advisor and former Metropolitan Police Commander in charge of Operation Yewtree, Peter Spindler, revisits his career and the landmark investigation into Jimmy Savile's abuse allegations.