Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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).

Power Map Enhancements and Presentation

Power Map for Excel 2013 has had some recent enhancements that are worth noting.  You can download the latest Power Map install file here.  This update includes some really nice features that are helping make Power Map consumable to a larger audience.  Here’s a quick list of some of… Read more

0 comments, 257 reads

Posted in Devin Knight on 20 September 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, 376 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, 414 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, 188 reads

Posted in Devin Knight on 8 August 2013

Using Parameters in Power Query Extracts

Introduction

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, 1,811 reads

Posted in Devin Knight on 7 August 2013

Ohio Business Intelligence Road Trip 2013

Next month Mike Davis and myself will be making a epic road trip.  We will be flying into Columbus, OH to deliver a two day (7/16 – 7/17) workshop on advanced Reporting Services techniques.  We will then pack up and drive to Cleveland, OH for another two day (7/18-7/19) workshop… Read more

0 comments, 382 reads

Posted in Devin Knight on 27 June 2013

Creating Real World PowerPivot Models Recording and Q&A

Thanks everyone for attending my free webinar on Creating Real World PowerPivot Models on June, 18, 2013.  If you were not able join for the live event you can now watch the recording here.

In this webinar we built out a live solution with the Pragmatic Works Marketing Director,… Read more

0 comments, 294 reads

Posted in Devin Knight on 20 June 2013

Power View Reporting on Multidimensional Cubes Released

I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was announced. You can read about the details of it at the Analysis Services and PowerPivot team blog for Microsoft here. http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx

This is part of a SQL Server Cumulative update… Read more

0 comments, 382 reads

Posted in Devin Knight on 2 June 2013

Ad-hoc Reporting with SharePoint Recording and Q&A

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013.  If you weren’t you can now watch the recording here.

As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on… Read more

0 comments, 356 reads

Posted in Devin Knight on 23 May 2013

Analysis Services Webinar Recording and Q&A

I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013.  If you weren’t you can now download the recording here

Because I covered new material all the way to the end of the webinar i thought I'd also answer some… Read more

0 comments, 951 reads

Posted in Devin Knight on 2 April 2013

SQL Server Analysis Services Webinar

Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics themed free training.  This webinar is for anyone trying to understand the basics behind Analysis Services and how to get started design a cube.  With… Read more

0 comments, 415 reads

Posted in Devin Knight on 1 April 2013

Consuming News Through Social Media and Read It Later With Pocket

These days the fastest way, not always the most accurate, to get news is through social media.  Technology, sports, politics, and breaking news will always be found first on social media outlets like Twitter. 

For example, I’m a huge fan of American Football or most known as the NFL.  Every… Read more

0 comments, 446 reads

Posted in Devin Knight on 20 March 2013

Getting Started with Microsoft Data Explorer

What is Data Explorer

Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions.  It does this by provided straightforward methods for connecting to data previously unheard of, without a developer, in Excel.  It also provides a basic ETL tool for those involved… Read more

0 comments, 507 reads

Posted in Devin Knight on 6 March 2013

Excel 2013 Inquire Add-in

What is Inquire

The Inquire Add-in for Excel 2013 helps you analyze and review your workbooks for things like relationships, invalid formulas, and to compare .xlsx files for differences.  Let’s take some time to review how to enable the add-in and then how to use it.

Enabling the Add-in

If… Read more

0 comments, 649 reads

Posted in Devin Knight on 8 February 2013

New Book: Knight’s SSIS 2012 24-Hour Trainer

I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer. The 24-Hour series of books offered by Wrox is a great way to get kick started into learning a new tool. Not only are the lessons… Read more

0 comments, 1,464 reads

Posted in Devin Knight on 30 November 2012

PASS Summit 2012 Recordings Available

Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy networking?  Good news!  The recordings are now available for free to watch streaming for all those who attended the conference now here.

If you weren’t an attendee you can… Read more

0 comments, 760 reads

Posted in Devin Knight on 21 November 2012

PASS Summit 2012 Review

Life is finally returning to normal after a great week in Seattle for PASS Summit 2012.  The entire year is basically other smaller events (still great events!) that occur to pass the time until Summit arrives.  Like Ted Kummert said in the keynote on Wednesday PASS Summit is like a… Read more

0 comments, 1,014 reads

Posted in Devin Knight on 13 November 2012

Building Dynamic SSRS Reports with Analysis Services Recording and Code

Thanks to all who attended my webinar last Thursday on Building Dynamic Cube Reports.  You can find my code

Recording:

http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/WebinarDetails.aspx?ResourceId=470

Code:

http://sdrv.ms/RqxbcF

There are several reports in here that step you through the changes I made throughout the webinar.

Also, look for my upcoming SSRS Master Classes that will… Read more

0 comments, 676 reads

Posted in Devin Knight on 30 October 2012

Upcoming Webinar: Building Dynamic SSRS Reports with Analysis Services

Join me next week for a really fun presentation on building Dynamic SSRS
reports using Analysis Services cubes as a data source.  This webinar will
demonstrate how you can use one of the underutilized features of Analysis
Services called Dynamic Management Views.

Session details:

Designing
Dynamic SSRS Reports using an…

Read more

0 comments, 902 reads

Posted in Devin Knight on 18 October 2012

24 Hours of PASS Recordings Available

If you missed any of the great 24 hour of PASS sessions from September you
can now watch the recordings. 

http://www.sqlpass.org/UserLogin.aspx?returnurl=%2fLearningCenter%2fSessionRecordings%2f24HoursFall2012.aspx

Details on my session can be found below:

Session 01 - Choosing the Right Reporting Platform
Presenters: Brian Knight, Devin Knight
Download presentation slides (PDF) Read more

0 comments, 554 reads

Posted in Devin Knight on 12 October 2012

Newer posts

Older posts