Joe the Business Intelligence Guy

A journey through the design and delivery of business intelligence solutions.

Power Query – Presentation

Devin Knight, a co-worker of mine at Pragmatic Works, presented last night at our local JSSUG Jacksonville SQL Server User Group meeting.

Power Query (Formally known as Data Explorer) is a free add-in for Excel 2010 and up that provide users an easy way to discover, combine and refine data all within the familiar Excel interface.  With Power Query you can now combine and transform data from a variety of unusual data sources all within Excel, which would have previously required a complex ETL job.

This was a well organized presentation with good introduction using PowerPoint to describe how Power Query fit into the landscape of self-service business intelligence (data extraction, modeling, and presentation). Demos were useful in understanding a good range of options for handling common scenarios.

This work is licensed under a Creative Commons license.

Written by Joe Salvatore

August 22, 2013 at 8:30 am

%d bloggers like this: