The trick is to allow the analysis to happen within the app, and not as vlookups and pivot tables in Excel (as the user is more comfortable with).
Ultimately, this is Microsoft's failing as Excel should have become a cloud/server-powered think-desktop/tablet app a long time ago with versioning and multi-user support. Sure that existed back in the late 90s with ODBC and data links, but it was too fragile and was not significantly improved in the decade and a half since.
http://edu-kinect.com/blog/2014/06/23/microsoft-brings-hadoo...
Some documents that I've prepared in Excel with complex (meaning not all that complex) don't come into Numbers properly (a stacked bar with one series as a line, for example).
It's not just the macros but 100s of little things that break compatibility.
If you use Numbers with Excel for anything but the most basic spreadsheet list you are going to have a bad time.
Its something of a stereotype but generally Excel to "something else" is less painful than old Excel to new Excel.
This initiative probably has the MS Office 365 marketing people salivating.