“Excel is one of those applications that the business world cannot live without.”
So says one of 27 Excel experts commenting on Microsoft’s Power BI Suite and its effect on the great wide world of spreadsheet users.
As Excel lovers, we couldn’t agree more!
There’s a wealth of wisdom in the observations made by these 27 pros. Along with the main topic of what’s new in Power BI Suite, there’s excellent insight on the use of Excel and BI generally. (For a good post about what one expert calls a “running joke in BI communities—‘What is the most used feature in any business intelligence solution?’”, see But, Does It Export to Excel?, from PARIS Technologies.)
About what’s new with Power BI Suite, the experts agree that it delivers significantly powerful new capabilities: from connecting to enterprise data (Power Query) to aggregating differently sourced data (Power Pivot) to creating exciting visualizations (Power View and Power Map—watch out, “Visual Analytics” products!), this suite of tools signifies a whole new era of “self-service BI” for Excel users.
Smart guys and gals that they are, the experts point up some caveats. How will these new capabilities affect a company’s “B.I. workflow[s]”? And, mightn’t Power BI, by empowering Excel user(s), propagate more—and more complex—silos of data among disconnected groups of users? Will IT lose total control, if users feel it’s their Excel-given birthright to reach back to underlying data sets for BI solutions? And as to collaborative work—will SharePoint be the answer, finally?
All the caveats and concerns are certainly worth considering … That said, from our standpoint: we begin with the premise that user-empowering technologies—Excel or otherwise—are a good thing! As for the caveats, won’t someone please invent a technology that addresses concerns about security and collaboration? And one that provides for other application needs, like planning, budgeting and forecasting? Because that’s what people do in Excel! And while they’re at it, a solution that is inclusive of other non-Excel users? (Hmmm, maybe someone has – see here for a description of PARIS’s Olation).
“The future looks very bright for Excel and BI,” says another expert. Here’s to a future that’s bright for all BI users—and no caveats required!
Read the original article, from InvestInTech.com here: 27 Microsoft Excel Experts Predict the Future of Excel in Business Intelligence