For Business Intelligence and Reporting, the Client is Excel

Microsoft recently released Management Reporter 2012 and a lot of people are excited.  The Management Reporter team has been very accessible and they've done an admirable job of tackling questions and promoting the new release. However, I'm stuck on one significant flaw of Management Reporter.  It's not Excel. 

...

Requires FREE Membership to View

Login
Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Mark Polino

Mark Polino is a Microsoft MVP for Dynamics GP and the Director of Client Services for Fastpath. He is author or coauthor of five books on Microsoft Dynamics GP. Mark has been working with Dynamics GP and its predecessors since 1999. He is a Florida licensed CPA and holds an MBA from Rollins College.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013Mark's new book, Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013, is available now.

 

 

 

 

Read full bio...

Excel is good, but...

Mark,

I've been using Excel for about 15 years now. While I fully appreciate your perspective on this, and recognize that Excel (for better or worse) is the defacto client for most BI (intentionally or otherwise), there are some glaring issues with Excel that make it less than desirable as a cornerstone for a BI implementation.

First off, there's the ubiquitous user error. I have spent a lot of time building user apps in Excel, locking cells and putting in formatting macros to make SURE that the user will never need to touch anything sensitive...and then they do something I never expected and the whole thing crashes. Excel's flexibility is delightful, except when it allows so many options that you can't safely say you've covered all the bases.

Second, Excel is very poor as a data repository (although it's often used as one). Having worked in FP&A for many small to mid size clients, I know that any data set which lives and is updated IN EXCEL is eventually going to corrupt. Having data live outside Excel is always preferable.

In short, once you have your data set, and you want to perform additional formatting/analysis on that data set, Excel is great. Getting the data, however, is better suited to a more-structured application (like an FRx) which will make sure you're getting the right data every time.

That said, I think the interface for MR could do with a lot of improvement. I just don't see something as flexible as Excel being the right starting point for critical analysis.

...Dig deeper into Excel, you'll be surprised

Rick,

The point is that with other tools (deFacto, BI 360, Hyperion, you name it) the data still resides in the database. Excel is NOT the data repository, it's simply the presentation layer. Simplifying, it's a lot like GP's refreshable Excel reports. Refreshing Excel brings in the latest data for financial reporting and you have all of Excel's tools for formatting.

Excel in my experience is ALWAYS the analysis layer. Users just export from MR or FRx today for analysis today.

On the budget side, again, Excel is the input layer but the budget actually resides inside of a database and is subject to workflow and approval before updating. A big difference is the transparency behind it. If a user makes a mistake, it's possible to find the mistake in a spreadsheet. For many tools today, I see users using Excel to build the model and then keying the data into another budget package. With that approach you add keying errors and lose the transparency of where a number originated from.

Last thing, I looked at every mid-market Corporate Performance offering I could find for the Dynamics space for an upcoming presentation I'm working on. On the financial reporting side, every single product uses Excel as the reporting interface. Every one. The fact is that the market has spoken and Excel is the client.

Mark

Finally ... the voice of sanity

Mark,

While I agree with the concerns around Excel as a potential data silo and uncontrolled area for key business calculations, I completely agree with the points that you make. Host the data in the database or Cubes and also any complex calcs that need to be controlled for consistency.
It is also my experience that users are most at ease with doing analysis in Excel.
I look forward to further integration of AX with Excel as its reporting tool and while MR is a definite improvement on FRx, it still adds to much of a tech requirement to truely empower the business users.
JK

minivan