Inside Office 2016


Inside Office 2016: Excel improves business intelligence

Source:  Microsoft

Microsoft said Excel 2016 now includes integrated publishing to Power BI and new modern chart types. It also offers an update to the forecasting function, which Microsoft said has been extended to allow forecasting based on Exponential Smoothing. By offering Power Query as a tool within Excel, Microsoft is moving a step closer to making the product more business intelligence focused. While Excel is unlikely to replace dedicated BI tools, the majority of people use Excel as a data repository anyway, so improving querying is a plus. In fact, the ability for Excel to query central data repository, may very well help IT begin to tackle the big problem of data islands, where people setup Excel to capture data without IT's knowledge. Clearly IT will need to convince users to use central repositories for their Excel data, but Power Query is a step in the right direction to help IT build a bridge between user-generated data and central, corporate data repositories.

View All Photo Stories

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

I suppose a wise programmer can never have too many tools at hand (and these seem particularly smart), but I do sometimes feel inundated hunting through feature trees for that command I know I used to know but have since forgotten... I haven't worked with 2016 yet but hope this Swiss Army Knife of a program comes with a flow chart of commands.