Archive for tag: Power Query

Power Query Decathlon – Beginner 02: Importing Data

6 January, 2015 (10:00) | Decathlon, Power Query | By: Mark V

NOTE: This post was created using the November 2014 version of Power Query. In later versions, some of the screens or functionality could be different. In this post, we will demonstrate a few of the options available for importing data into Excel with Power Query. There are a lot of options available, many with their […]

Power Query Decathlon – Beginner 01: Installation and Tour

5 January, 2015 (11:00) | Decathlon, Power Query | By: Mark V

NOTE: This post was created using the November 2014 version of Power Query. In later versions, some of the screens or functionality could be different. Power Query, a free add-in for Excel 2010 and Excel 2013 is easily installed. Just search for “power query download” in your search engine of choice. Or click on Figure […]

Power Query Decathlon – Beginner: Introduction

2 January, 2015 (15:12) | Decathlon, Power Query | By: Mark V

Power Query is an add-in for Excel that helps us easily import data from many different sources into Excel. During that process, we have the option to create new columns, change existing ones, filter out rows, and generally shape the data before it arrives in Excel. This is different from the capabilities we have had […]

Power to the Power of Power

16 December, 2014 (11:00) | Power BI, Power Pivot, Power Query, Power View | By: Mark V

I love Power tools. My father was a carpenter in his spare time and used a table saw, drill press, band saw, etc to make furniture and novelty products like a pencil holder shaped like the head of E.T. (I drew that design when I was kid). He sold quite a few of those. Times […]

Power BI Demo Contest Entry

15 January, 2014 (00:55) | Business Analytics, DAX, Power BI, Power Pivot, Power Query, Power View | By: Mark V

Behold! I hereby present my entry into the Power BI Demo Contest! I am really pumped about this set of tools and hope this demo helps show off what Power BI can do. You can view it here on my YouTube channel. Getting a prize would be cool, but I have to say the fun […]