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).

Bringing Power BI Q&A to your Organization Recording and Q&A

I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014.  If you weren’t you can now watch the recording here.

Traditionally following a webinar I try to post a quick Q&A session for everything I was not able… Read more

0 comments, 20 reads

Posted in Devin Knight on 17 April 2014

Introduction to Power BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If you weren’t you can now download the recording and slides.

I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s… Read more

0 comments, 95 reads

Posted in Devin Knight on 14 March 2014

Upcoming Webinar – Creating Power Map Reporting Solutions

Come join me for this webinar on 4/17/2014 at 11:00 AM EST

Creating Power Map Reporting Solutions

Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest… Read more

0 comments, 29 reads

Posted in Devin Knight on 13 March 2014

Upcoming Webinar – Bringing Power BI Q&A to your Organization

Come join me for this webinar on 4/15/2014 at 11:00 AM EST

Bringing Power BI Q&A to your Organization

Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply… Read more

0 comments, 31 reads

Posted in Devin Knight on 13 March 2014

Upcoming Webinar - Introduction to Power BI

Come join me for this webinar on 3/13/2014 at 11:00 AM EST

Introduction to Power BI 

The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and… Read more

0 comments, 135 reads

Posted in Devin Knight on 28 February 2014

Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A

I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on February 11, 2014 that I delivered with Dustin Ryan.  If you weren’t you can now watch the recording here.

Traditionally following a webinar I try to post a… Read more

0 comments, 533 reads

Posted in Devin Knight on 17 February 2014

Power BI for Office 365 Released

Today Microsoft has officially announced the release of Power BI for Office 365.  You can read the Power BI teams post on the release here:

http://blogs.msdn.com/b/powerbi/archive/2014/02/10/announcing-the-general-availability-of-power-bi-for-office-365.aspx

Power BI has some pretty amazing features that allow users take control of their data.  I’ve also written several posts in the past about… Read more

0 comments, 195 reads

Posted in Devin Knight on 10 February 2014

Final Day for Power BI Voting, Can I Have Your?

Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition!  Please take a moment and vote for my video here http://tinyurl.com/PowerBIDevin

Thanks for voting! Read more

0 comments, 149 reads

Posted in Devin Knight on 30 January 2014

Power BI Contest Entry Voting

You’ve watched my video (hopefully) now vote for it!  In a previous post I wrote about my Power BI contest entry (Read more about it here).  I really enjoyed making this video and hopefully you enjoyed watching it.  Please take a few moments and vote for my entry here. Read more

0 comments, 133 reads

Posted in Devin Knight on 20 January 2014

Power BI Contest Entry

Today I submitted my Power BI contest entry and I’d love for you to take a look!  Here’s a short description of entry and the video itself:

In this submission I have used Power BI to help me plan a vacation with my wife. We both love thrill rides so… Read more

0 comments, 154 reads

Posted in Devin Knight on 8 January 2014

Power BI Q&A Preview Now Live On Your Data

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick tutorial of how it all works.  This post will walk you through uploading a workbook to Power BI, Using Q&A against that workbook, enhancing the workbook with synonyms and the… Read more

0 comments, 217 reads

Posted in Devin Knight on 18 December 2013

Using Power Query to Parse your Inbox

One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft Exchange as a data source.  You can download this update now here:

http://www.microsoft.com/en-ca/download/details.aspx?id=39933

Here’s a quick demonstration of how you may use the Microsoft Exchange… Read more

0 comments, 1,502 reads

Posted in Devin Knight on 13 December 2013

Thoughts on December 2013 Power Query Updates

Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates.  The list of updates can be found here but for my notes specifically on Power Query updates continue reading!

Power Query

Power Query now has 3 new data sources that you… Read more

0 comments, 202 reads

Posted in Devin Knight on 11 December 2013

Power Pivot Synonyms

A little gem was included with the latest Office 365 update.  After downloading and installing this update you will now find that a feature called Synonyms is available inside Power Pivot. 

Synonyms are a piece of the puzzle that make the Power BI feature Q&A work.  If you haven’t seen Q&A… Read more

0 comments, 176 reads

Posted in Devin Knight on 18 November 2013

New Book: Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

I’m very excited to announce that you can now purchase my latest book: Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services . This booked, offered by Wiley, takes you through designing effective balanced scorecards using Reporting Services. You can get your copy of my new book here Read more

0 comments, 329 reads

Posted in Devin Knight on 14 November 2013

Dealing with Power Pivot to Tabular Upgrade Errors

Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process.  This is part of the beauty of the relationship between Tabular and Power Pivot.  This allows an Analyst to get started on a project using Power Pivot and when new requirements like row level security… Read more

0 comments, 786 reads

Posted in Devin Knight on 4 November 2013

PASS Summit 2013 and SQL Saturday Charlotte in Review

I love reading the many blogs posts that pour in following a PASS Summit.  I think it is fun to read everyone’s experience.  There’s not really a wrong way to attend the conference unless you just hide our in your hotel the whole week.  Here’s how my week went.

Sunday Read more

0 comments, 209 reads

Posted in Devin Knight on 21 October 2013

Awarded Microsoft MVP

Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first time.  Becoming an MVP has been an informal goal for me for quite sometime now.  I’ve always kept this as more of an informal goal because I’ve always thought of… Read more

0 comments, 241 reads

Posted in Devin Knight on 1 October 2013

Understanding Microsoft Self-Service BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 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, 283 reads

Posted in Devin Knight on 26 September 2013

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, 256 reads

Posted in Devin Knight on 20 September 2013

Older posts