27/05/2017
Where do we see the future of MS Excel in Business Intelligence Workflows?
We at TheDataLabs see Excel as the future of Business Intelligence workflows.
No matter how many systems a company has, how big they are, or how many millions of dollars have been spent on them, the reality is that the majority of data is exported to Excel before decisions of serious consequence are made. We’d go so far as to say that there are only a handful of finance departments in the world who don’t run their critical decision making analysis through Excel.
With the increasingly diverse toolset being added to Excel — Power Query to source and clean data from disparate dirty sources, Power Pivot to aggregate those disparate sources into business intelligence models, Power View to create dynamic dashboards from those models and Power Map to tell the data story on a geo-spatial plane – it’s very clear that Microsoft is investing heavily to make Excel the Business Intelligence tool of choice.
The killer for Excel today is not the fact that it isn’t the best out there for building business intelligence, it is the fact that far too many users are ignorant of the vast amount of capability that was added in the last five years. The attitude of “Excel can’t do that” is still pervasive and relied upon by its competitors to sell their products.
Our advice to anyone looking at building business intelligence systems today and considering switching to a competitor’s product: find a business intelligence expert who REALLY uses Excel. Ask them what can be done. Chances are you already own the software that will do it all, you’re just not aware of how.
TheDataLabs is expert in this field and can provide you a valuable and money saving expertise in building Business Intelligence or Management Information System.
In nutshell, Excel continues to be the #1 platform when it comes to analyzing data, finding information, preparing charts and presenting them to decision makers. In that sense, we see Excel playing a strong role in BI workflows in future.
11/04/2016
18/06/2015
16/06/2015