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.
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.
When Microsoft launched Skype for Business earlier this year, we said we’d deliver new Skype for Business voice and meetings capabilities in Office 365 that will enhance the existing Skype for Business experience, and allow us to offer a complete, enterprise-grade communications solution at global scale as part of Office 365. We’re pleased to announce technical previews starting today: Skype Meeting Broadcast, PSTN Conferencing and Cloud PBX with PSTN Calling.
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,…
Today, at our first-ever Ignite Conference in Chicago, we announced new capabilities and solutions from across the company, all of which help IT Pros fuel innovation and transformation within their organizations. I was thrilled to join corporate vice president of Skype engineering Gurdeep Singh Pall on stage during today’s keynote to showcase the innovation we’re delivering across Office to empower IT Pros.
Today, businesses are required to understand a growing amount of data to drive effective business decisions and remain competitive. Many specialized business intelligence and analytics solutions are entering the market to take advantage of this trend with most requiring installation of new data systems or new training of employees to learn new tools. Excel may already have the business analytics tools you need to drive the information analyses and data-driven…