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
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
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
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
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
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
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
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
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
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
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...
Page 15 of 16