Microsoft Power Query for Excel

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.

http://www.microsoft.com/en-us/download/details.aspx?id=39933

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
  • Folder
  • 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
  • Facebook

Prerequisites:

  • 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).
  1. Download and install Office 365 ProPlus.
  2. Make sure Excel is not running.
  3. 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.ImagePower BI for Office 365 from Atidan

Visio 2013 Preview

Download the Visio 2013 Preview Here

Simplify complex information by creating professional diagrams in just a few clicks.

The new Microsoft Visio has:

  • Features designed to make it easier to create diagrams—including quicker access to frequently used tools, new and updated shapes and stencils, and improved and expanded themes and effects.
  • Tools to make teamwork simpler, such as the ability to work together on the same diagram at the same time and improved commenting—in both Visio and Visio Services.
  • Improved touch support, including for Windows 8 and Visio Services in the new Microsoft SharePoint.
  • Options to make your diagrams more dynamic by linking shapes to real-time data, with an expanded set of supported sources.
  • The ability to share your diagrams with others through a browser (even if they don’t have Visio installed) through Microsoft Office 365 or SharePoint.
  • Support for updated diagramming standards, including Unified Modeling Language (UML) 2.4, Business Process Model and Notation (BPMN) 2.0, and Windows Workflow Foundation 4.0.


Create professional diagrams quickly: Create engaging diagrams in just a few clicks with updated shapes and new formatting options
and tools.

It’s easier to start creating and customizing diagrams

Visio is packed with enhancements to make it easier to get started, find the stencils you want to use, and quickly get great-looking results with over 60 built-in templates, many with updated shapes. You can also create and customize professional-looking diagrams using a rich set of expanded and improved effects and themes that apply a completely different design in just one or two clicks.

Perform common tasks more easily

Diagrams are seldom static, so Visio makes it easier than ever to update your diagram with new shortcuts for frequently performed tasks. You can get to frequently used tools right away with a significantly improved quick-access floating toolbar and easily replace any shape (or combination of shapes) in a diagram while preserving your shape connections, shape metadata, and the overall layout.

Create great-looking organization charts more easily

One of the most used templates in Visio—the organization chart—just got even better with several new styles—from professional to playful, which you can apply with just one click, the ability to import pictures and improved layout options to help fine tune the way your org chart looks.


Work together on diagrams with your team: Collaborate on diagrams with new teamwork features.

Work together on a single diagram at the same time

Streamline teamwork and reduce the risk of errors by allowing two or more people to work on the same diagram in a single file at the same time—from rearranging and adding shapes, to writing comments, to applying effects. With just one working file, you avoid the need to email files around, figure out what changes others have made to the original diagram, and manually merging multiple versions together.

Share diagrams through a browser on almost any device

By saving your Visio diagrams to Microsoft SharePoint—either on your company’s servers or through Microsoft Office 365—you can make them instantly viewable through a browser for colleagues without Visio. Visio Services in SharePoint provides a rich experience through the browser, with full detail from the original diagram, refreshable data (in diagrams with data links), the option to view and add comments, and improved touch support so you can view and interact with the diagram through virtually any device.

Give feedback with improved commenting

The latest Visio release introduces features designed to make it easier to capture and address reviewers’ feedback on diagrams. You can add comments to any diagram from virtually any device, whether through Visio or a browser using Visio Services – and can get immediate clarification on any you are unclear on by initiating an instant messaging (IM) conversation or audo/video call right from within Visio. (Requires a compliant IM application, such as Microsoft Lync.)


Link diagrams to dynamic data: Use the shapes in your diagram to make real-time data understandable at a glance.

Link diagram shapes to data with a simple wizard

Visio Screenshot

With Visio, you can link the shapes in your diagram to your business data to visually represent complex information. Several popular data sources are supported, including Microsoft Excel, Microsoft Excel Services, Microsoft SQL Server, Microsoft SQL Azure, and Microsoft SharePoint Business Connectivity Services. This allows you to reveal patterns and meaning in your data with data graphics, such as vibrant icons, symbols, colors, and bar graphs.


Use a powerful diagramming platform: Get an extensible and flexible platform for creating diagrams and solutions that fit your business.

Enhance process management with support for BPMN 2.0 and updated validation rules

Visio can help you ensure that your diagrams meet the standards required by your business, including support for Business Process Model and Notation (BPMN) 2.0 —today’s standard for business process modeling—and you can use the built-in validation rules to help ensure your diagrams comply with the specification. You can also continue to open and update diagrams that use BPMN 1.2.

Create visual workflows and publish them to SharePoint

Visio simplifies how you create SharePoint workflows and Microsoft Project workflows to support demand management. You can create and publish SharePoint workflows visually with updated support for Windows Workflow Foundation 4.0 (including support for stages and loops and better integration with Microsoft SharePoint Designer) and also use Visio to create visual Project workflows for demand management, which work with both Microsoft Project Server and Microsoft Project Online.

Try Visio with Office 365

Try Visio as a subscription through Office 365, with the same features as in Visio Professional 2013 Preview. Visio Pro for Office 365 Preview will get users up and running quickly with application streaming technology and automatic patching. Visio Pro for Office 365 Preview also enables users to work from the Windows PC of their choice through Visio On Demand, which allows them the option to install Visio on multiple PCs and even temporarily install Visio on kiosks while they’re travelling.

Microsoft Project 2013 Preview

Microsoft Project 2013 Preview

Take action

Get started quickly

Project Online helps you get started quickly. Visual tiles identify important steps and provide a simple guide for you to begin or flex project portfolio management (PPM) capabilities.

Access from virtually anywhere

Project Online extends your PPM experience to smartphones, keeping you up-to-date while you’re on the go with an interface suited to small form-factors.

Flexible project portfolio management

Select optimal portfolios

Project Online enables you to define and select project portfolios that align with your business strategy–prioritize competing requests, run optimization scenarios under varying budgetary constraints, and maximize resource utilization to manage capacity.

Deliver projects successfully

Project Online helps you effectively manage everyday work in SharePoint Online and the tactical details of execution with Project Pro for Office 365 or Project Web App (PWA), while ensuring alignment with business priorities.

Gain visibility and control

See what your teams are doing–even when they’re managing everyday work or ad-hoc projects in SharePoint Online task lists. You can also move ad-hoc projects from SharePoint Online into Project Online when you need more control. Now you can see all demand and govern accordingly, accurately measure utilization and make objective decisions that align with your strategic goals.

Easily create workflow

Project Online allows you to create workflows with Visio in SharePoint Designer, to subject each project to the appropriate controls throughout its lifecycle–to improve governance and control.

Strengthen everyday collaboration

Discover and share information

Share documents, follow people and sites, or simply keep track of what people are working on. By binding together the social experiences of SharePoint Online and Project Online, you can facilitate discussions and information sharing to help you complete projects and everyday work.

Improve decision making

Project Online enables you to see summary dashboards, plans, and timelines in PWA, helping you glean insight and make better decisions across a collection of projects, a particular program or portfolio. Self-service access enables decision makers and analysts to quickly mine and aggregate data–to understand risk and align long-term planning and short-term execution needs with business priorities.

Increase agility and control

Simplify IT management

Project Online simplifies IT management with straightforward provisioning, enterprise-grade reliability and integrated administration with SharePoint Online so it’s easier for your IT staff to administer.

Explore the SharePoint Store

Quickly act on new challenges or respond to big opportunities. Shave time off discreet processes. With Project Online, you can choose apps from the SharePoint Store to meet the needs of your business.