Six weeks after implementing a new reporting and business intelligence system recommended by Enprise, fluid supply specialist AUSblue runs complex reports in around ten seconds and creates business analysis reports on demand.
“We were using Clarity to get data out of MYOB EXO, but no one knew how to use it,” says AUSblue IT Manager Jamie Linck.
“Our new system is point and click. It has worked an absolute treat.”
AUSblue had particular challenges, says Enprise Consultant Christopher Timm.
“AUSblue’s reports are very complicated, they wanted self-service, they needed a familiar interface and they provide a lot of reporting to people with no EXO license,” he says.
“For these reasons I presented a solution based on a product called Alchemex. It’s more than a reporting solution. It’s Business Intelligence that can drive specific queries and analysis, and answer questions.”
AUSblue is saving money and time, says Jamie Linck.
“We save money because we no longer have to pay consulting fees to create customised reports – I can create them myself. It does not require a lot of technical knowledge to write reports. It takes me five minutes at the most to write a report if the data is in one table.
“We save time because it’s so quick to pull live data into a report. It takes about ten seconds to pull our Business Development Manager Dashboard Report, which contains our top 30 customers in Australia; top 30 customers by state; what individual sales people have sold, customers lost, sales targets etc. If you know where the data is, you can report on it. If the data is in EXO we can get it out. And it doesn’t affect the database.”
AUSblue needed to connect to third party applications that are not integrated with EXO.
"The thing that really sold us on Alchemex was its ability to pull data from more than one database into a single report,” Jamie Linck says.
“After we changed database at the end of this financial year, we could no longer compare financial years. Alchemex pulls data from our old and new databases into one report. When we saw this feature in the product demo, we were sold straight away.”
Alchemex is Excel-based, so the interface – like its use of formulas, for example – feels familiar.
“It’s easier to use than anything I’ve used before,” Jamie Linck says.
“We just pull what we need. We have a dashboard for the sales guys, we run it weekly. It tells us what sales we’ve done, which customers haven’t ordered in a while, pricing policies due to expire. Anyone can run a report – it just takes a double click. In Alchemex there is the developer of reports – that’s me – and the users of reports, which is our whole staff. Users are report viewers. They just put in a date parameter or whatever and away they go.”