A couple of weeks ago I had the pleasure of speaking again at SQLSaturday Minnesota. This year it was at a new location in downtown Minneapolis at the St. Thomas Graduate Campus. Once again the planning team and volunteers did a wonderful job of organizing the event and having everything ready. Awesome job!
The session that I did this year was What’s new in Excel 2016 for Business Intelligence. There were over 40 people in attendance at the session (first one of the morning) and everything went as planned, no demo issues:) I covered the new features in both Excel 2013 as well as 2016. No one in the room was using 2016 yet (not sure if anyone new it was even released yet – was released on Sept 22) and everyone was using 2013 (majority were not aware of the new features in 2013, so good thing I had that material readily available).
The new features I highlighted in Excel 2016 were the following:
- Tell Me – search for features (probably my favorite addition to Office – provides instant access to the feature as well)
- Sharing – much simpler
- Version History – needs to be in SharePoint or OneDrive
- One Click Forecasting – okay, takes more than one click, but very nice
- 6 new chart types – treemap, sunburst, waterfall, histogram, pareto, box and whisker
- PivotTable enhancements
- Multi-select Slicers
- Get & Transform Data (native Power Query in Data tab)
- 3D Map (native Power Map on Insert tab)
- Publish to Power BI
- Power View works with Multidimensional (but Power View is a hidden item because of Silverlight and a bit of a challenge to add back into Ribbon – wouldn’t recommend, use Power BI Desktop instead)
If you would like to check out my full presentation that also includes the new 2013 features download the material here – [Demo] – SQLSat453MN_Excel2016BI_denglishbi_20151010.zip
Thanks to everyone that attended and look forward to the next event!