DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

How to use Microsoft ChatGPT to Search, analyse, query and data alert your consolidated Xero Account Transactions Data

How to use Microsoft ChatGPT to Search, analyse, query and data alert your consolidated Xero Account Transactions Data

by Kevin Wiegand

|

Nov 13, 2023

|

Xero

Are you ready to revolutionize the way you handle your financial data? In our latest video, we unveil the game-changing features of our data viewer, paired with the incredible capabilities of artificial intelligence. Efficient Data Filtering: Sa

How to download consolidated Xero Reports as at a certain date

How to download consolidated Xero Reports as at a certain date

by Kevin Wiegand

|

Oct 13, 2023

|

Xero

Greetings, fellow data enthusiasts! In this informative blog post, we’ll explore a video transcript featuring Kev from DataSights. He demonstrates how to seamlessly download report data from Xero’s API, providing you with a powerful tool to access sp

How to calculate MRR Growth rate with Xero Invoice data and Azure ChatGPT

How to calculate MRR Growth rate with Xero Invoice data and Azure ChatGPT

by Kevin Wiegand

|

Oct 12, 2023

|

Xero

Greetings, data enthusiasts! I’m Kev from dataSights, and in today’s blog post, we’re going to delve into a fascinating video transcript. In this video, I demonstrated how to calculate your Monthly Recurring Revenue (MRR) growth rate using ChatGPT...

How to use the Caching Service by DataSights

How to use the Caching Service by DataSights

by Kevin Wiegand

|

Oct 12, 2023

|

Uncategorised

In this insightful video, DataSights introduces their groundbreaking caching service, designed to revolutionize data performance, especially in online reporting. By addressing the intricacies of live data retrieval and report rendering, DataSights ai

How to use ChatGPT and dataSights to email a Xero Debtors list

How to use ChatGPT and dataSights to email a Xero Debtors list

by Kevin Wiegand

|

Oct 10, 2023

|

Xero

In today’s rapidly evolving digital landscape, accessing and utilizing data efficiently has become a paramount concern for businesses. The ability to retrieve valuable insights quickly can be a game-changer, streamlining decision-making processes and

How to use the Syncs functionality by dataSights

How to use the Syncs functionality by dataSights

by Kevin Wiegand

|

Oct 3, 2023

|

Uncategorised

In this comprehensive guide, we delve into the world of data synchronization with DataSights. What exactly is a sync, and why is it crucial for your data management? A sync, in essence, is the process of transferring data from your various sour

How to use the Data Editor to add in Business User Data to your reporting

How to use the Data Editor to add in Business User Data to your reporting

by Kevin Wiegand

|

Oct 3, 2023

|

Uncategorised

In today’s data-driven world, efficiently managing and integrating various data sources is paramount for business success. In a recent video presentation by DataSights, a powerful solution for businesses, the focus was on simplifying the process of i

How to use the Snapshot Service by dataSights to build up a comparitive / trend dataset

How to use the Snapshot Service by dataSights to build up a comparitive / trend dataset

by Kevin Wiegand

|

Oct 3, 2023

|

Uncategorised

Data snapshotting is an invaluable tool when your dataset lacks historical information. In this guide, we’ll explore DataSights’ Snapshot Service, its applications, and how you can effectively implement it. Why Snapshot Data? ...

How to connect Microsoft Excel to Azure SQL for Windows and Mac

How to connect Microsoft Excel to Azure SQL for Windows and Mac

by Kevin Wiegand

|

Sep 29, 2023

|

Excel

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

Bulk update products in Cin7 Core (formerly DEAR) from Excel

by Kevin Wiegand

|

Sep 29, 2023

|

Cin7 Core

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