DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

Data-Driven Cin7 Core Inventory Management – Part 1: Unveiling Bundling Analysis with ChatGPT into Excel, Power BI, Google Sheets and Looker

Data-Driven Cin7 Core Inventory Management – Part 1: Unveiling Bundling Analysis with ChatGPT into Excel, Power BI, Google Sheets and Looker

by Kevin Wiegand

|

Jul 27, 2023

|

Cin7 Core

Getting instant bundling analysis answers using ChatGPT over your business data Basically we are going to Tarantino this bad boy and start with the end at the beginning. Starting with The How? and end with The Why? Why? Because the how is damn exciti

Why SQL is far more important than a reporting tool

Why SQL is far more important than a reporting tool

by Kevin Wiegand

|

Nov 2, 2021

|

Opinion piece

It is both amazing and awesome to watch the capability and responsibility of data and reporting move into business roles which previously did not have that expectation as part of their job description.Especially with the younger staff in businesses w

How to automate PO creation in DEAR Systems with two clicks

How to automate PO creation in DEAR Systems with two clicks

by Kevin Wiegand

|

Oct 27, 2021

|

DEAR Inventory

Purchase Order creation is without a doubt a fundamental part of any inventory based business. Without raw materials to manufacture and/or without goods to sell, well, what are we doing here exactly? So now that we have relatively easily established

The magic of ExcelAddIns – Xero Invoice Automation – 3 real scenarios

The magic of ExcelAddIns – Xero Invoice Automation – 3 real scenarios

by Kevin Wiegand

|

Mar 10, 2020

|

Excel Add Inc

The invoice automation challenge It is no secret that invoicing is a fundamentally key part of any business, without revenue, there is no business! Unfortunately it is a process that often comes with a large amount of complexity. From discounts, to c

Budgeting in Excel? You are doing it wrong

Budgeting in Excel? You are doing it wrong

by Kevin Wiegand

|

Mar 3, 2020

|

Uncategorised

It’s 2020 and if people are asking “is the cloud secure”, well, at least they aren’t asking it to my face. I digress, it’s 2020 and all across the land, from solopreneurs to corporates, Excel spreadsheets are getting emailed around at...

Xero Consolidation INTO Excel & PowerBI – the reality from the coalface

Xero Consolidation INTO Excel & PowerBI – the reality from the coalface

by Kevin Wiegand

|

Feb 18, 2020

|

Excel

When it comes to effective #Xero consolidation that an SME will actually use, there are four rules; don’t force a particular tool on the SME’s various functions, let them use what they want automate the data into all the SME’s reporting tools via

The 4 Phases to a Modern & Powerful Data-Smart SME

The 4 Phases to a Modern & Powerful Data-Smart SME

by Kevin Wiegand

|

Feb 6, 2020

|

Uncategorised

Noone likes change, simple. Especially when it comes to systems, tools, business data and producing information that guides business decisions. It can be perceived as risky & incredibly painful. However, what is also true is most SME’s are not..

What is Screenscraping? The good, bad and the ugly

What is Screenscraping? The good, bad and the ugly

by Kevin Wiegand

|

Jan 21, 2020

|

Opinion piece

What is Screenscraping? It’s programmatically gathering data from a website. A software developer writes a bit of code, to; Startup a browser Click around the website as if its a normal user Download html / download data dependent on the particular w

Helping Anstel Brands nail goal tracking, team target visibility and data availability – a DEAR Inventory story

Helping Anstel Brands nail goal tracking, team target visibility and data availability – a DEAR Inventory story

by Kevin Wiegand

|

Apr 9, 2019

|

Case Study

Anstel Brands are a wholesale company located in Melbourne that use DEAR inventory across their business. “Bringing beautifully designed baby products to quality conscious parents”. They sell baby products, predominantly to retail baby stores. These

5 Sales Dashboard Best Practices & 2 Must Have KPI’s to drive better sales results in your business

5 Sales Dashboard Best Practices & 2 Must Have KPI’s to drive better sales results in your business

by Kevin Wiegand

|

Mar 6, 2019

|

DEAR Inventory

Welcome to our best practices & KPI’s to get you a Sales dashboard that will drive results “Your dashboards need to achieve 2 things; be useful & drive engagement. When your staff look at them everyday, give feedback & adjust them, THAT...