We’ll continue Technology Management's countdown to the launch of AX2012 with a question:
What’s the world’s favourite BI tool?
Clue: Hit the windows key, type “exc” and hit enter.
Chances are that you’re already familiar with it, and have been for years. Your colleagues know it, and you can be fairly certain that anyone joining your business- even a school leaver is likely to be proficient.
So wouldn’t it be great if you could directly access your live ERP data from a Microsoft office Excel spreadsheet?
It's easy if your ERP system also happens to be from Microsoft. In a matter of seconds you can pull live data from AX into Excel and view, analyse and update information in AX without ever leaving your favourite BI tool.
Providing you have the necessary authority, you can help yourself to transactional data and use tools such as Powerpivot to drill down to what’s important.
You can then save the spreadsheet locally and because the link with Dynamics AX tables in maintained, you can refresh it with up to the minute data at any point in the future.
Microsoft even have a catchy, Monday morning friendly phrase for it: “Pervasive interoperability”. Meaning Microsoft software is already pervasive within your business, so perhaps a highly integrated (interoperable) Microsoft ERP system is the next logical step.
To see "DIY BI" in action, register for our AX2012 preview event on the 20th July.