by dataSights | Sep 20, 2023 | Google Sheets, Process Automation
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 Sheets while...
by dataSights | Aug 9, 2023 | SQL, Xero
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 BI data models I...
by dataSights | Jul 27, 2023 | Cin7 Core, DEAR Inventory, Inventory Management
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 exciting and I’ll...
by dataSights | Nov 2, 2021 | Opinion piece, SQL
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 we notice....
by dataSights | Oct 27, 2021 | DEAR Inventory, Dear Process Automation, Excel, Excel Add Inc, Process Automation
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 PO’s are an...
by dataSights | Mar 10, 2020 | Excel Add Inc, Process Automation, Xero
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 contracts, to...
by dataSights | 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...
by dataSights | Feb 18, 2020 | Excel, PowerBI, Xero
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 a single...
by dataSights | 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...
by dataSights | 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 website Why...