Excel 2016 and Power BI are a portfolio of tools that is unique in the industry. Together, they provide a broad set of capabilities that allow business analysts to more easily gather, shape, analyze and visually explore their data. —Read more for an overview of how these tools work together to solve your analytics needs.
We introduced you to our new chart types across Office 2016 and dove deeper into a few of them. We showed the effectiveness of Waterfall charts in visualizing financial statements and how hierarchical charts show complicated data with multiple levels and categories. Now, we’ll take a closer look at the last set of chart types: statistical. —Read about Histogram, Pareto and Box and Whisker charts in Office 2016 for Windows.
This month’s Power Query update includes four new or improved features, including the option to specify Join Type in the Merge Queries dialog, the ability to extract first, last or range of characters from a Text column, the ability to customize the Quote Style in the Split Column by Delimiter dialog, and support for UPN credentials in the Exchange connector.
This month’s Power Query for Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.
In the Office 2016 Public Preview, we have provided a set of new charts to give you innovative ways to explore data and tell rich stories across Excel, Word and PowerPoint. Say hello to Waterfall, Histogram, Pareto, Box & Whisker, Treemap and Sunburst—six powerful chart that help you quickly visualize common financial, statistical and hierarchical data in more intuitive ways.
In the May 2015 update of Office 365 we are proud to introduce a new core feature to Power Map: Custom Regions. The Custom Regions feature allows data to be mapped to the regions that matter most to you, even if they are not the traditional zip code, county, state or country regions. Custom regions are useful for plotting data on sales districts, school districts, congressional districts, land lot development,…