Loading . . .
New data visualization capabilities in Excel 2016

New data visualization capabilities in Excel 2016

Microsoft has announced the further expansion of their BI tool environment at this year’s MSIgnite. Within the new Office 2016, especially Excel 2016 comes with new business analytics features and possibilities of graphical representations.

Excel at least since the version of 2007 is one of the business analytics tools in Power BI with Microsoft SQL Server. In the new upcoming version analysts, developers and end users will grow closer together. Everything revolves around the relevant data, which are determined from the SQL Server components such as Analysis Server or Reporting Services, processed and aggregated through Power-BI Designer and Excel (of course combinable and integrated) and finally brought to the end user via graphical dashboards or pretty displayed (for example) in new Excel Charts. So they can be used for better decision-making or to support business processes.

Microsoft Business Intelligence and Analytics

When you take a look at the path of business intelligence integration in Excel since the 2007 version, then there were more and more functions integrated (for example, in Excel 2010: several sparklines and a optimized Icon Set), now with Excel 2013 new effective data evaluation possibilities which enable an enhanced visualization of processes or existing numbers have been added.

Now Microsoft has taken the next step: Excel 2016 adds even more analytical and visual tools for data analysis and presentation of statistics and business transactions. For example such great features like treemap, sunburst or waterfall charts or the integration of power maps are coming up.

Powermap Preview in Excel 2016

With the new Office package also comes a fundamentally optimized presentation all products on mobile devices. Now documents scale better, faster and easier in the viewport, thus improving the operability of the Office products.

New Office apps on Windows 10 deliver universal touch and mobile-first experience across devices

Who wants to know more about the great new Business Analytics and visualization with Power BI and Excel should definitely watch the video of Scott Ruble on Channel 9, here he explains the individual charts and their options in detail and with reference to figures and examples.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Servicepack 1 for SQL Server 2014 available again
Backup Button Next post TSQL #66 – Monitoring Backup Solution – Backup History

SQL from Hamburg

Das bin ich ;-)

Björn Peters - MVP - Data Platform
I had to do with MS SQL databases for the first time in 2000 and looked after these database systems for around seven years. From 2007 to 2019, I was employed as a database administrator and looked after many different SQL servers from medium-sized companies and large corporations from different industries.
Although I have some certificates, I get my insights and knowledge about the SQL Server purely from day-to-day business, reading / following numerous forums/blogs.
I'm not specialized in any topic, but I focus mostly on performance analysis.
Since the end of 2016, I have been the Azure Meetup Hamburg organizer and from April 2017 to June 2018, Cloud and Data Center Management MVP, and since July 2018, Data Platform MVP.