Microsoft Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia.
With the Power BI Preview edition, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. For more information about how to share queries, see Share Queries.
With Power Query, you can
- Find and connect data across a wide variety of sources.
- Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as PowerPivot and PowerView.
- Create custom views over data.
- Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.
- Perform data cleansing operations.
- Import data from multiple log files.
- Perform Online Search for data from a large collection of public data sources including Wikipedia tables, a subset of Windows Azure Marketplace, and a subset of Data.gov.
- Create a query from your Facebook likes that render an Excel chart.
- Pull data into PowerPivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections.
- With the Power BI Preview edition, you can share and manage queries as well as search data within your organization.
Power Query Data Sources
- Web page
- Excel or CSV file
- XML file
- Text file
- SQL Server database
- Windows Azure SQL Database
- Access database
- Oracle database
- IBM DB2 database
- MySQL database
- SharePoint List
- OData feed
- Hadoop Distributed File System (HDFS
- Windows Azure Marketplace
- Active Directory
- Requires Microsoft Office Professional Plus 2013 or Office 365 ProPlus.
- Supports 32-bit or 64-bit machines. If you are using the 32-bit version of Excel 2013, you must use the 32-bit version of the add-in. If you are using the 64-bit version of Excel 2013, you must use the 64-bit version of the add-in. The two versions are not interchangeable.
- Requires Windows 8, Windows 7, or Windows Server 2008 R2 (requires Microsoft .NET Framework 4.0).
- Download and install Office 365 ProPlus.
- Make sure Excel is not running.
- Download and install Microsoft Power Query Preview for Excel.
- Open the folder where you downloaded Microsoft Power Query Preview for Excel.
- Double-click the downloaded installer file, and then follow the steps in the wizard.
- After the installation is complete, click Finish.
- Microsoft Power Query for Excel will appear as a new tab on the Excel ribbon.
Posted in Microsoft News, Office 2013, Office 365, Uncategorized
- Tagged analytics, Excel, Office 365, powerpivot, powerquery, powerview, reporting, sharepoint
Power Map is a 3D data visualization tool for Excel that provides an immersive experience for making discoveries in data that might never be seen in traditional 2D tables and charts. Power Map lets you plot geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.
With Power Map you can:
- Map Data: Plot more than a million rows of data* in 3D visually on Bing maps and visualize the data with 3D columns, bubble/pie charts, heat maps, and regions.
- Discover Insights: Discover new insights by seeing your data in geographic space and seeing time-stamped data change over time.
- Share Stories: Capture screenshot “scenes” and build cinematic, guided interactive or video “tours” that can be shared broadly, engaging audiences like never before.
OnePlaceMail is an amazing productivity tool for SharePoint – please contact Atidan for a free trial and special offers! firstname.lastname@example.org
Written by James Fox, Posted in OnePlaceMail
Intuitive, efficient access to SharePoint
OnePlaceMail Release 6.5 combines the familiarity of the Microsoft Outlook experience (such as email and document preview) with the strength of SharePoint views; including columns, grouping, sorting and filtering of content.
End user productivity is significantly increased through efficient access to SharePoint content and minimal change in the Microsoft Outlook user experience which improves the adoption of your SharePoint solutions.
SharePoint views within Outlook
OnePlaceMail’s ‘Outlook style interface’ provides access to both SharePoint public and private views for the selected location
Document and email previews
Microsoft Office Web Apps Server email and document previews (where available) and performace controls for local previews.
Search, preview and access SharePoint
Search within the ‘Outlook style interface’ and view previews of select results.
Access items in SharePoint:
User actions for greater productivity
Increase productivity with actions to copy and email links or attach content from SharePoint:
Exchange Online mailbox sizes are doubling
by Office 365 Team
on August 29
Stephen Brown is a product marketing manager on the Exchange team
The size of user mailboxes in all Exchange Online and Office 365 service plans is doubling. Beginning today, the current 25 GB of mailbox storage is increasing to 50 GB. With this increase even the most active email users don’t have to worry about mailbox size limitations-we’ve got you covered! There’s no price increase associated with this change. Our doubling of your mailbox storage is simply part of our promise to continuously deliver value to our Office 365 customers.
You don’t need to do anything to take advantage of this new mailbox size. Your mailbox size will automatically be increased. The increase starts rolling out to customers today and continues through November.
This increase to a 50 GB mailbox per user benefits Exchange Online and Office 365 service plans, including: Exchange Online Plan 1, Office 365 Small Business, Midsize Business, Enterprise E1, Government G1, and Education A1. If you have one of our premium service plans (Exchange Online Plan 2, Office 365 Enterprise E3 and E4, Government G3 and G4, Education A3 and A4), you already enjoy unlimited email storage through your personal archive, but now your default primary mailbox size is increasing to 50 GB. Kiosk user mailboxes are doubling in size, too-from 1 GB to 2 GB.
In addition to doubling the storage in your users’ primary mailbox, we’ve increased the size of other mailboxes to help you work even more productively. Shared mailboxes and Resources mailboxes are both increasing to 10 GB (more than doubling), so you’ll have plenty of room to store everything you need for your projects and collaborations. The size of Site mailboxes remains unchanged.
Here’s a summary of the new mailbox sizes by plan:
For complete details about mailbox types and sizes, read the Office 365 service descriptions.