SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: August 2013

Introduction to Power Query Q&A

Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013.  If you were not able join for the live event you can now watch the recording here. This was part of an ongoing webinar series by Pragmatic Works offers every Tuesday and Thursday… Read more

0 comments, 1,080 reads

Posted in Devin Knight on 28 August 2013

Whitepaper: Building Self-Service BI Solutions with Power Query

Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate than any traditional BI solution. This is why businesses are looking to Self-Service BI to solve the smaller, but no less significant, problems that individual departments need addressed. The goal… Read more

0 comments, 1,049 reads

Posted in Devin Knight on 14 August 2013

Extracting Data From Multiple Files with Power Query

In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort.  If you’re still learning the basics of Power Query please refer back to an earlier post here.

This demonstration will show you how to use Power Query… Read more

0 comments, 917 reads

Posted in Devin Knight on 8 August 2013

Using Parameters in Power Query Extracts


By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have heard of the tool many still have not gotten their hands on it and started experiencing the potential it has. In case you’re new to Power Query here’s a… Read more

0 comments, 5,036 reads

Posted in Devin Knight on 7 August 2013