Working with accounts data in Excel: Power Query

Kashflow logo
Share this content

In the previous instalment in this series we looked in some detail at the Power View add-in for Excel. Microsoft has recently introduced two new “Power” add-ins and given the entire Power ensemble the name Power BI.

The two additional add-ins are currently previews with some known ‘issues’ and warnings about possible changes in the final release, so it’s worth reading the accompanying release notes before getting started. Power Map is a data visualisation add-in that starts where last time’s Power View playable charts finished, but this time we will concentrate on the other end of the BI process – getting at the data and preparing if for use. This is what the Power Query preview is for.

Microsoft describes Power Query as providing ‘an intuitive user interface for data discovery, data transformation and enrichment.’

There are three stages to the Power Query process. First you connect to one or more sources of data, then you can ‘shape and transform’ the data prior to returning the result to an Excel worksheet and, optionally, adding it to the Excel Data Model...

Please Login or Register to read the full article

The full article is available to registered members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About Simon Hurst

Simon Hurst

Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.



Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.