Your Business Data to Power BI, Excel, Google Sheets and more. Perfectly done.
Automate your Business data and empower your staff in real-time.
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
Connect your business data to YourDataHub
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
Data gathering second to none
No matter where your data lives, we will get you access to it
Dashboard’s, reports & emails that help you manage your business
Custom Excel Add Ins & data automations
Pricing options for every business
We have a plan to suit your organisation
* 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
-
Step 1: Authenticate your systems + Microsoft Power BI.(30 seconds)
-
Step 2: Schedule a time for your data to sync.(15 seconds)
-
Step 3: Trigger sync.(15 seconds + variable syncing time)
-
Step 4: Select the reporting tool you want to use (Excel, Power BI, Google Sheets) and build reports with automated data.(2 minutes)
-
That’s it! More time to work on other things.
Our Blog
Latest news, tips and best practices.
How to connect Microsoft Excel to Azure SQL for Windows and Mac
In this tutorial, we'll walk you through the process of connecting Microsoft Excel to your Microsoft Azure Cloud Database, a vital step in streamlining your data management tasks. Whether you're using Windows or Mac, we've got you covered. ...
Bulk update products in Cin7 Core (formerly DEAR) from Excel
Are you struggling to manage your DEAR inventory efficiently? Look no further! In this detailed guide, Kev from DataSights will walk you through the process of installing and using the XLN add-in, a powerful tool that can revolutionize your inventory management in...
How to use the SQL Editor by dataSights
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...
Want to find out more?
We do solutions not sales, book a chat and get some awesome advice