You’ve been running your business for a while now but some days it just doesn’t “feel right”.
You know there’s something amiss but you can’t put your finger on it.
There’s still several months before you meet with your accountant when they’ll inform you of exactly what it was that was bugging you but you couldn’t quite figure out.
But what if there was a way to see these things more obviously and in a more timely fashion?
Enter business dashboards!
Now these types of dashboards are not new. In fact you’ve seen them every time you take a flight.
The Arrivals and Departures boards are common place examples of business dashboards and serve perfectly to demonstrate their effectiveness.
Within minutes, the traveller can ascertain what gate their flight leaves from and whether its on time or should they go grab a coffee due to delays.
In fact a friend of mine who runs an IT business has these dashboards in his support room displaying a myriad details of his current support tickets.
Business dashboards are definitely here to stay with a number of players offering them, most notably Microsoft.
Microsoft’s Power BI product https://powerbi.microsoft.com/en-us/ allows you to aggregate data from a host of locations including Xero and QuickBooks accounting, the usual host of SQL database, but also Excel spreadsheets and text files.
Most amazingly, it allows you to transform and transpose the data so it becomes more meaningful to you.
Perhaps the outstanding feature (imho) is that you can have, say, Sales data in monthly CSV (comma separated value) text files and join them to your other data whether it comes from SQL Server or your accounting software.
If you’re interested in learning more about Power BI, the online training company Edx is currently running a course https://www.edx.org/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-3 if you want to give it a go yourself.
Or you can call the office on 08 9200 4431 and have a chat about what you’d like to do and what might be involved.