We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and improvements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.
The Excel and Power BI teams are hosting a new conference designed specifically for you, the business analyst. The Microsoft Data Insights Summit will feature talks from leaders in the Excel community and successful analysts who will share their thoughts on trends in the industry, Excel and Power BI best practices and what it takes to succeed as an analyst in the modern workplace.
With the new Get & Transform capabilities in Excel 2016, you can now import, transform and combine data from different sources—thanks to the integrated Power Query technology in Excel. Today we are going to focus on one of the most useful capabilities that Get & Transform offers—the ability to use Unpivot to transform ANY table in your workbook to make it ready for powerful analysis using PivotTables and PivotCharts.