Blog
Latest articles, guides and insights from the dataSights team.
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
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
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
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!
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!
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
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
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
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
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
Page 14 of 16