ConnectPlus by Arbutus Analytics  

Simplify Advanced Analytics for Everyone 

 

ConnectPlus is an ODBC connectivity solution that seamlessly integrates the powerful capabilities of Arbutus with core business applications like Excel and Power BI .

It enables organizations to extend advanced analytics, data cleansing, and consolidation capabilities directly into the familiar tools users already know and rely on. By bridging the gap between sophisticated data analysis and everyday applications, ConnectPlus eliminates the steep learning curve typically associated with advanced analytics tools

Whether deployed on desktop or server environments, ConnectPlus makes it easy to load data from selected Arbutus projects and tables directly into Excel spreadsheets and Power BI dashboards, enhancing both accessibility and productivity across your organization.

Download ConnectPlus Overview PDF

 

Request a Trial

Who ConnectPlus Is Designed For?  

ConnectPlus serves four distinct user groups, each with unique needs. Excel users gain access to cleansed and consolidated data, advanced analytics results, and disparate or legacy data sources without leaving their familiar spreadsheet environment. Data consumers who work with Power BI or other dashboard applications can connect their visualizations to real-time refreshed results produced by Arbutus analytics workflows and procedures.

IT and data administrators benefit from an agile solution for supporting users and projects involving Excel and dashboards, with ConnectPlus also serving as a light ETL or prototyping option.

Business analysts can leverage the power of Arbutus advanced analytics while continuing to work in the applications they know best, eliminating the need to learn new tools.

Arbutus User Type

How ConnectPlus Works: Four Simple Steps

Implementing ConnectPlus follows a straightforward four-step process that gets you up and running quickly

  1. Set Up Data Sources: Generate your results using Arbutus, leveraging its advanced analytics and data consolidation capabilities.

  2. Map ConnectPlus: Link ConnectPlus to the Arbutus project containing your data through the ODBC Data Source Administrator.

  3. Configure Application: Access your data via ConnectPlus by selecting the appropriate data source and tables.

  4. Save and Deploy: Name your spreadsheet or dashboard, making it ready for ongoing use and refresh operations

This streamlined workflow enables rapid deployment and minimizes the time from installation to productive use. The refresh functionality ensures that updates made in Arbutus are automatically reflected in connected applications, maintaining data currency without manual intervention.

Try ConnectPlus - Download the UserGuide

How does Arbutus Connectplus work

Key Benefits That Set ConnectPlus Apart 

ConnectPlus delivers measurable value across multiple dimensions

  • Organizations achieve better data quality and results in existing reporting applications without requiring wholesale system replacements.

  • The cost-effective licensing structure makes it economical to deploy advanced analytics to larger user groups, democratizing access to sophisticated data analysis capabilities.

  • Administrators can easily set up and support data access for dedicated Excel users, reducing support burden and increasing user satisfaction.

  • Companies successfully support advanced analytics to much broader audiences without facing typical user adoption challenges, as employees don't need to learn new tools to benefit from better analytics.

  • ConnectPlus simplifies the resource-consuming challenge of adapting to the ever-changing needs of Excel and Power BI users

Technical Capabilities and Configuration  

ConnectPlus provides robust technical capabilities through ODBC connectivity, offering flexibility in deployment and configuration. The solution supports both 32-bit and 64-bit ODBC Data Source Administrator environments, ensuring compatibility across diverse system architectures.

Computed fields created in Arbutus tables are automatically made available when loading data into core applications, preserving analytical logic and calculations. Administrators can control field visibility by excluding specific fields from being loaded, maintaining data governance and security requirements.

The system supports auto-running procedures and workflows that automatically execute when tables are opened via ConnectPlus, enabling dynamic data refresh and regeneration before loading into applications. While ConnectPlus references one project at a time by default, organizations can establish separate instances of the ConnectPlus driver to access multiple Arbutus projects simultaneously, each pointed at unique project files.

From ODBC
 

What Users Say About ConnectPlus -

Organizations using ConnectPlus report better data quality in existing reporting applications, cost-effective deployment of advanced analytics to larger user groups

"We’ve expanded analytics access without increasing adoption challenges."
"We now have better data quality and results in our existing reporting applications"
"Our employees don’t need to learn a new tool to get better analytics."
"Simple administration that supports Excel users’ data access needs, encourages broad adoption with minimal user resistance, and requires no learning curve employees keep working in Excel while gaining stronger analytics."
"ConnectPlus brings Arbutus advanced analytics straight into the tools you already use, like Excel and Power BI, no new software to install, and no complex training required. Whether you are an Excel power user, data administrator, business analyst, or dashboard designer, ConnectPlus connects advanced analytics with your day-to-day work."

Ready to Elevate Your Data Analytics

For more information about how ConnectPlus can transform your organization's approach to data analytics and reporting, book a call or get in touch with us today!

Book a Call