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...
by dataSights | Apr 9, 2019 | Case Study, DEAR Inventory, Sales
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 products are...
by dataSights | Mar 6, 2019 | DEAR Inventory, Opinion piece, Sales, Xero
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...
by dataSights | Feb 22, 2019 | Xero
Quantum Advisory is a Sydney based advisory team who help business owners supercharge their companies, become more profitable and plan for the future. That’s taken directly off the website and whilst I know they are excellent advisors, accountants and...