DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

How to use the SQL Editor by dataSights

How to use the SQL Editor by dataSights

by Kevin Wiegand

|

Sep 28, 2023

|

SQL

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

How to use the Data Viewer by dataSights

How to use the Data Viewer by dataSights

by Kevin Wiegand

|

Sep 27, 2023

|

Uncategorised

In the world of data analysis, every tool that simplifies the process is a treasure. Today, we’re diving into DataSights’ Data View feature, led by our guide, Kev. This may be a short video, but the insights you’ll gain will be nothing short of...

How to use the Data Alert Service by dataSights

How to use the Data Alert Service by dataSights

by Kevin Wiegand

|

Sep 27, 2023

|

Uncategorised

Are you drowning in a sea of data and emails? In this blog post, we will delve into the world of data alerts, helping you efficiently manage and act on critical information. Join us on a journey to simplify your data-driven life. Introduction

How to use AI Data Query (ChatGPT) to get instant answers to your questions using your own data

How to use AI Data Query (ChatGPT) to get instant answers to your questions using your own data

by Kevin Wiegand

|

Sep 22, 2023

|

SQL

In a world inundated with data, extracting meaningful insights can be a daunting task. However, thanks to innovative solutions like DataSights’ AI data query function, this process is becoming more accessible and efficient.In this blog post, we’ll di

Performance Boosting Excel Trick!

Performance Boosting Excel Trick!

by Kevin Wiegand

|

Sep 21, 2023

|

Excel

Are you tired of your Excel spreadsheets slowing down over time, especially when dealing with linked workbooks, multiple sheets, and complex calculations? In this video, Kev from dataSights shares a clever Excel trick to enhance your spreadsheet perf

Xero Consolidation : Uploading data from Excel to multiple Xeros for easy intercompany transactions, invoice creation, journal creation and much more!

Xero Consolidation : Uploading data from Excel to multiple Xeros for easy intercompany transactions, invoice creation, journal creation and much more!

by Kevin Wiegand

|

Sep 21, 2023

|

Excel

Are you tired of spending countless hours manually entering data into your Xero accounting software? Do you wish there was an easier way to consolidate your financial information? Well, you’re in luck! In this comprehensive guide, Kev from DataSights

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

|

Sep 21, 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 dataSights SQL Templates

How to use the dataSights SQL Templates

by Kevin Wiegand

|

Sep 21, 2023

|

SQL

In the ever-evolving landscape of data analysis, efficiency is the name of the game. Hi there, I’m Kev from dataSights, and in this video, we’re diving into the world of SQL templates and how they can revolutionize your reporting processes. The SQL

Automating Data into Google Sheets for Optimal Performance: A Step-by-Step Guide Optimizing Google Sheets Performance: Tips and Tools for Efficient Data Handling

Automating Data into Google Sheets for Optimal Performance: A Step-by-Step Guide Optimizing Google Sheets Performance: Tips and Tools for Efficient Data Handling

by Kevin Wiegand

|

Sep 20, 2023

|

Google Sheets

In an era of data-driven decision-making, Google Sheets is a valuable tool. However, as data accumulates, performance issues can arise. In this comprehensive guide, Kev from DataSights shares expert tips and techniques to automate data into Google Sh

SQL Crash Course for Business Professionals using Xero data: Create a Game-Changing Sales Analysis View

SQL Crash Course for Business Professionals using Xero data: Create a Game-Changing Sales Analysis View

by Kevin Wiegand

|

Aug 9, 2023

|

SQL

The massive shift in business users (non-technical) wanting access to accurate data and picking up tools and getting stuck in is literally compounding year-on-year IMHO. The intense complexity of Excel formulas / Power Query transformations / Power B