fbpx

Your Business Data to Power BI, Excel, Google Sheets and more. Perfectly done.


Automate your Business data and empower your staff in real-time.

Try it FREE
BOOK A DEMO
Connectors & Integrations

Automate your Business Dashboards reporting in 3 easy steps

A world-class technology platform & real people to listen and guide you to 100% automated reporting

P

Connect your business data to YourDataHub

Z

Excel, Power BI & GSheets automated

We are on hand, every step of the way

Want to see it in action?

Try it FREE, or book a chat with our founder

How to connect Excel, Power BI, Google Sheets, SAP or a 3PL

Automate your Business Dashboards data to Excel, Power BI, Google Sheets or any other system

Connect your business data to Microsoft Excel

Connect your business data to Power BI

Connect your business data to Google Sheets

Connect your business data to SAP, 3PL and other systems

Discovery sessions to find out they reporting why, and explain the dataSights way

We take the time to understand your business and to objectively explain your options

Your businesses systems and the way you use it are unique. Your staff that use the systems have processes which are unique. Only by understanding all of the pieces can we put together a full picture
If there wasn’t an issue, you wouldn’t be calling us. That’s OK, we can help! Whether it’s efficiency, growth, profitability, customer experience or simply to reduce painpoints. We are uniquely positioned to address your problems.
Our only goal is to help you run a better business, every, single day. Your goals will change, but that’s OK they are meant to, we want them to! As your business grows or becomes more efficient or both we need to adjust our service to match your goals. And this is what we are brilliant at.

Data gathering second to none

No matter where your data lives, we will get you access to it

Your data isn’t all in the cloud. We know this. You either have a crazy old legacy system that can only e-mail us data and/or a part-time bookkeeper that’s been there since the Triassic. If we need that data, you will get it, beautifully automated.
Each clients mix of data is unique. How often they want to see it and where they want to see it is unique too. Our flexbile, bespoke data platform can pull & push data on a schedule (or on-demand) which meets the criteria to create a true value-add.
While other out-of-the-box products exist, they are limited to providing cookie cutter insights to standard metrics. The ability to get all of our clients’ data into a single database means we can manipulate and analyse data as necessary. This single data pool allows us to service clients with varying business models and tech stacks from within one platform efficiently, and therefore profitably.
Lisa Barham

Director, Effigy Consulting

Dashboard’s, reports & emails that help you manage your business

Reports don’t have to be PowerBI, we use the right tool for the job. What reports need to be is used. Reports are only used if they are accurate and provide value, every, single, day.
Using accurate reports, we create tailored dashboards that keep a specific audience on track. Only by making dashboards visible will you gain the desired behaviour change in order to help your business along the intended path to a happier place.
Some clients hate computers. That’s OK. We have our moments too. If you need exception based reporting, delivered automagically on a schedule to the people that really need it, then, absolutely we make this happen. In fact, don’t tell anyone, it’s our favorite way to deliver beautiful data

Custom Excel Add Ins & data automations

Take the manual processes you have, invoice automation, aggregated group sales reporting to holding companies, moving data to other systems, all of the can be automated with Excel Add Ins and Add Ons. Or fully automated as a seamless service. Get in touch and we can explain now.
dataSights builds custom Excel Add Ins
Over the past 18 months dataSights has helped us with an array of data solutions. Combining sales data from our 17 Pos systems to wholesale data from our inhouse legacy system and then with our large Xero file. We use the automated reporting and Excel based solutions every single day in our organisation, saving our backoffice hours per day in what used to be manual effort.
Peter Winlaw

CEO, UMS

Pricing options for every business

We have a plan to suit your organisation

Sync frequency
Select number of connectors


Select max number of entities per connector


1 Connectors
1 Entities per connector
$53 / month

On Demand

  • Number of connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     1
    Cin7 Core & Accelo (+$33 per month)
  •  
  • Entity consolidation
    This is the number of entities per connector you can consolidate. So Xero counts as one connector, but if you are consolidating 15 Xero entities, then this counts as 15 entity consolidations.
     1
  • Sync frequency
    On Demand = Trigger your own refresh manually. Daily = scheduled refresh once per day. Real-time = as often as API limitations will allow, each API is different and different endpoints within each API differ. Rest assured we will do what we can to customise our syncs to match your needs
     On Demand
  • Microsoft Cloud Database
  • Data Alerts
    Data Alerts are scheduled emails, delivered to inboxes of your choice, with CSV data attached, which can be any data that you or we create with SQL or AI Data Query
  • Upload to Xero and Cin7 Core
  • AI Data Query - ChatGPT
  • BI & SQL Templates
  • Use our SQL & BI developers
    Our team of Software, SQL and BI Developers can be leveraged at a discounted hourly rate of $75 USD per hour. We will give an upper limit of an estimate for each piece of work and keep 100% transparency as the project progresses.
Try it FREE

Starter

  • Number of connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     1
    Cin7 Core & Accelo (+$33 per month)
  • Additional connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     $ 65(per month)
  • Entity consolidation
    This is the number of entities per connector you can consolidate. So Xero counts as one connector, but if you are consolidating 15 Xero entities, then this counts as 15 entity consolidations.
     3
    (+ $11 per entity)
  • Sync frequency
    On Demand = Trigger your own refresh manually. Daily = scheduled refresh once per day. Real-time = as often as API limitations will allow, each API is different and different endpoints within each API differ. Rest assured we will do what we can to customise our syncs to match your needs
     Daily
  • Microsoft Cloud Database
  • Data Alerts
    Data Alerts are scheduled emails, delivered to inboxes of your choice, with CSV data attached, which can be any data that you or we create with SQL or AI Data Query
     5
  • Upload to Xero and Cin7 Core
  • AI Data Query -
    ChatGPT ( + $200 per month )
  • BI & SQL Templates
  • Use our SQL & BI developers
    Our team of Software, SQL and BI Developers can be leveraged at a discounted hourly rate of $75 USD per hour. We will give an upper limit of an estimate for each piece of work and keep 100% transparency as the project progresses.
Try it FREE

Growth

  • Number of connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     5
    Cin7 Core & Accelo (+$33 per month)
  • Additional connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     $ 65(per month)
  • Entity consolidation
    This is the number of entities per connector you can consolidate. So Xero counts as one connector, but if you are consolidating 15 Xero entities, then this counts as 15 entity consolidations.
     25
    (+ $7 per entity)
  • Sync frequency
    On Demand = Trigger your own refresh manually. Daily = scheduled refresh once per day. Real-time = as often as API limitations will allow, each API is different and different endpoints within each API differ. Rest assured we will do what we can to customise our syncs to match your needs
     Real-time
  • Microsoft Cloud Database
  • Data Alerts
    Data Alerts are scheduled emails, delivered to inboxes of your choice, with CSV data attached, which can be any data that you or we create with SQL or AI Data Query
     10
  • Upload to Xero and Cin7 Core
  • AI Data Query -
    ChatGPT ( + $200 per month )
  • BI & SQL Templates
  • Use our SQL & BI developers
    Our team of Software, SQL and BI Developers can be leveraged at a discounted hourly rate of $75 USD per hour. We will give an upper limit of an estimate for each piece of work and keep 100% transparency as the project progresses.
Try it FREE

Unlimited

  • Number of connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     Unlimited
    Cin7 Core & Accelo (+$33 per month)
  • Additional connectors
    Connectors are source systems you pull data from. So Xero, Hubspot, Cin7 Core and Google Ads would count as 4 connectors.
     $0
  • Entity consolidation
    This is the number of entities per connector you can consolidate. So Xero counts as one connector, but if you are consolidating 15 Xero entities, then this counts as 15 entity consolidations.
     100
    (+ $11 per entity)
  • Sync frequency
    On Demand = Trigger your own refresh manually. Daily = scheduled refresh once per day. Real-time = as often as API limitations will allow, each API is different and different endpoints within each API differ. Rest assured we will do what we can to customise our syncs to match your needs
     Real-time
  • Microsoft Cloud Database
  • Data Alerts
    Data Alerts are scheduled emails, delivered to inboxes of your choice, with CSV data attached, which can be any data that you or we create with SQL or AI Data Query
     15
  • Upload to Xero and Cin7 Core
  • AI Data Query -
    ChatGPT ( + $200 per month )
  • BI & SQL Templates
  • Use our SQL & BI developers
    Our team of Software, SQL and BI Developers can be leveraged at a discounted hourly rate of $75 USD per hour. We will give an upper limit of an estimate for each piece of work and keep 100% transparency as the project progresses.
Try it FREE

* Connectors are source systems you pull data from. So Xero, Hubspot, DEAR Systems and Google Ads would count as 4 connectors.

** This is the number of entities per connector you can consolidate. So Xero counts as one connector, but if you are consolidating 15 Xero entities, then this counts as 15 entity consolidations.

*** On Demand = Trigger your own refresh manually. Daily = scheduled refresh once per day. Real-time = as often as API limitations will allow, each API is different and different endpoints within each API differ. Rest assured we will do what we can to customise our syncs to match your needs

**** Our team of Software, SQL and BI Developers can be leveraged at a discounted hourly rate of $75 USD per hour. We will give an upper limit of an estimate for each piece of work and keep 100% transparency as the project progresses.

WE BUILD ANY NEW CONNECTOR YOU NEED FOR A FIXED FEE OF $200 USD PER CONNECTOR

All our plans include :

All our plans include our expertise that will guide you to 100% automated reporting

Access to Data Experts

Conversations with our team who have years of experience in taking SME’s from manual reporting, to real-time, 100% automated & scalable reporting

Your Data Hub and Templates

Perfectly automate your data with our proprietary platform and Reporting templates built with years of experience

Pay-As-You-Go Consulting

If you need us to get going, or step-in when your internals are stretched. Hop on a call and let’s get you sorted

Pay-As-You-Go Coaching

Nearly all of our customers aren’t full time report developers. We simplify and focus on delivery to get you the skills to be 100% self-sufficient

Huge Focus on Client Service

Our NPS of 72 and almost 0% Churn is testament to our number one focus; Client Happiness

Frequently asked questions

  • Create an account (Free trial available), create or bring an existing database, connect business data on the Connectors page, then Sync! Then follow a short video on how to use your database credentials to connect to Power BI in Direct query mode. Done!

  • Create an account (Free trial available), create or bring an existing database, connect business data on the Connectors page, then Sync! Then follow a short video on how to use your database credentials to connect to Excel. Done!

  • Create an account (Free trial available), create or bring an existing database, connect business data on the Connectors page, then Sync! Then follow a short video on how to push your data to Google Sheets. Done!

  • Absolutely. Every customer gets their very own isolated data warehouse. Database credentials are salt-encrypted. Multi-factor authentication can be activated for your account. We take security very seriously.

  • Your business data reports can be updated daily, on-demand, and if it’s business data sales data as frequently as every 5 minutes.

  • Absolutely. We are software developers first, report developers second. Any business data data you need aggregated, calculated and pushed either via an ExcelAddIn or fully automated is no problem at all. Just get in touch and we can explore your requirements and offer multiple solution options.

  • We do! The business data templates will need some customisation, which either we can do, or you can do. Just get in touch and we can figure out how best to progress!

  • Absolutely. We are software developers first, report developers second. Any data you need pushed into business data either via an ExcelAddIn or fully automated is no problem at all. Just get in touch and we can explore your requirements and offer multiple solution options.

  • The choice is yours, or you can choose a combination, or we can coach you. Our only goal is to automate all our data, and guide you to 100% automated business data report automation.

  • We can consolidate whatever systems you use, and we would love to show you how OR start a FREE Trial and connect your business data, and sync away!

How Your data + Microsoft Power BI Integrations Work

  1. Step 1: Authenticate your systems + Microsoft Power BI.
    (30 seconds)
  2. Step 2: Schedule a time for your data to sync.
    (15 seconds)
  3. Step 3: Trigger sync.
    (15 seconds + variable syncing time)
  4. Step 4: Select the reporting tool you want to use (Excel, Power BI, Google Sheets) and build reports with automated data.
    (2 minutes)
  5. That’s it! More time to work on other things.

Our Blog

Latest news, tips and best practices.

How to use the SQL Editor by dataSights

How to use the SQL Editor by dataSights

by

In the realm of data management and analysis, having a robust and user-friendly SQL Editor is a game-changer. In this comprehensive guide, we'll embark on a journey led by Kev from DataSights as he unveils the power of the SQL Editor. While this tool might appear...

read more

Want to find out more?

We do solutions not sales, book a chat and get some awesome advice

Download the Perfect Practice KPI Cheatsheet

Download the Perfect Practice KPI Cheatsheet

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!