Click here to monitor SSC
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).

This Week in Data – Episode 1 (The Value of Certifications)

We know you you’ve been dying to know, what is TWID?  Drumroll please…. We’re excited to announce the launch of This Week In Data!  This Week In Data is a weekly video podcast hosted by Adam Jorgensen and Devin Knight that discusses important news and topics within the… Read more

0 comments, 75 reads

Posted in Devin Knight on 24 August 2016

Power BI Custom Visuals Class (Module 13 – Aster Plot)

In this module you will learn how to use the Aster Plot Power BI Custom Visual.  The Aster Plot is a twist on the standard Pie or Donut Chart.  What sets the Aster Plot apart from these visuals is that it has the ability to use a second measure to… Read more

0 comments, 116 reads

Posted in Devin Knight on 22 August 2016

Power BI Custom Visuals Class (Module 12 – Bullet Chart)

In this module you will learn how to use the Bullet Chart Power BI Custom Visual.  The Bullet Chart serves as a replacement for poorly designed dashboard gauges and meters you might be using now. Typical gauges do not show very much information and require a lot of space on… Read more

0 comments, 261 reads

Posted in Devin Knight on 19 August 2016

Power BI Custom Visuals Class (Module 11 – Calendar Visualization)

In this module you will learn how to use the Calendar Visualization Power BI Custom Visual.  The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar.

Module 11 – Calendar Visualization

Downloads

Read more

0 comments, 1,090 reads

Posted in Devin Knight on 10 August 2016

Power BI Custom Visuals Class (Module 10 – Card with States)

In this module you will learn how to use the Card with States Power BI Custom Visual.  The Card with States allows for you to have an value displayed with an indicator that can be manually adjusted or data driven.  Check out http://okviz.com/ for more details on this and other… Read more

0 comments, 222 reads

Posted in Devin Knight on 1 August 2016

Power BI Custom Visuals Class (Module 09 – Chord)

In this module you will learn how to use the Chord Power BI Custom Visual.  Chord diagrams show directed relationships among a group of entities using colored lines (chords); this allows for an easy representation of correlating data.

Module 09 – Chord

Downloads

  • Power BI Custom Visual – Chord
  • Dataset…

Read more

0 comments, 1,136 reads

Posted in Devin Knight on 25 July 2016

Happy Birthday Power BI!

Today marks one years since Power BI was officially released.  It’s been an amazing ride and I’d like to thank the team at Microsoft for so responsive to the community’s feedback.  Check out this video the community created to celebrate! 


Read more

0 comments, 145 reads

Posted in Devin Knight on 24 July 2016

Power BI Custom Visuals Class (Module 08 – Dot Plot)

In this module you will learn how to use the Dot Plot Power BI Custom Visual.  The Dot Plot is often used when visualizing a distribution of values or a count of an occurrence across different categorical data you may have.  Watch this module to learn more!

Module 08 –…

Read more

0 comments, 1,187 reads

Posted in Devin Knight on 18 July 2016

Power BI Custom Visuals Class (Module 07 – Enhanced Scatter)

In this module you will learn how to use the Enhanced Scatter Power BI Custom Visual.  This new-and-improved scatter chart allows for more customization and better data representation over the standard scatter chart that is provided to you by default with Power BI.

Module 07 – Enhanced Scatter

Downloads

  • Power…

Read more

2 comments, 207 reads

Posted in Devin Knight on 12 July 2016

Power BI Custom Visuals Class (Module 06 – Histogram)

In this module you will learn how to use the Histogram, a Power BI Custom Visual.  A Histogram is a column chart which shows the distribution of occurrences divided into categories, called bins.  This type of chart is useful for estimating density and discovering outliers.

Module 06 – Histogram

Downloads

Read more

0 comments, 600 reads

Posted in Devin Knight on 5 July 2016

Power BI – Checking Query Folding With View Native Query

A really great feature that was silently added into June update of the Power BI Desktop is a feature called View Native Query.  This feature is integrated into Power BI Query Editor and appears to give you the ability to see the queries that are running against your data… Read more

5 comments, 585 reads

Posted in Devin Knight on 3 July 2016

Power BI Row Level Security

In the June update of the Power BI Desktop there were some really cool features that were added.  I’d encourage you to review the full Power BI blog to see all the June updates.  My favorite of all these new features is Row Level Security (RLS) for Power BI.… Read more

0 comments, 621 reads

Posted in Devin Knight on 1 July 2016

Power BI Custom Visuals Class (Module 05 – KPI Indicator)

In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine” isn’t it?), a Power BI Custom Visual. Power BI comes standard with a KPI visual but the custom visual we will cover in this post shows a few more options… Read more

2 comments, 1,427 reads

Posted in Devin Knight on 28 June 2016

Power BI Custom Visuals Class (Module 04 – Radar Chart)

In this module you will learn how to use the Radar Chart, a Power BI Custom Visual. The Radar Chart is sometimes is also know to some as a web chart, spider chart, or star chart.  Using the Radar Chart allows you to display multiple categories of data on each… Read more

0 comments, 1,321 reads

Posted in Devin Knight on 21 June 2016

Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)

In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual.  The Hexbin Scatterplot is a variation of the traditional Scatter Chart but instead of using bubble size it relies on color saturation and hexbins to show value distribution.  You should consider using this chart… Read more

0 comments, 1,813 reads

Posted in Devin Knight on 14 June 2016

Power BI Custom Visuals Class (Module 02 – Enlighten Aquarium)

In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual.  While it might not be the most practical visualization it does provide a fun way to show categorical data and can have multiple series shown as well.

Module 02 – Enlighten Aquarium

Downloads

  • Power…

Read more

0 comments, 717 reads

Posted in Devin Knight on 7 June 2016

Power BI Custom Visuals Class (Module 01 – Custom Visuals Introduction)

Welcome to an exciting new FREE class that I am launching today!  Over the next year (that’s right year!) I will be releasing one module a week detailing how to work with all of the Power BI visuals available in the Custom Visuals Gallery.  You might ask why am… Read more

0 comments, 361 reads

Posted in Devin Knight on 1 June 2016

Power BI Takeover–Webinar Recording and Q&A

Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm.  Instead of our traditional 1 hour session I delivered a 3 hour workshop that took you through the end to end process of developing Power BI solutions.  The idea being to give you a taste… Read more

0 comments, 1,766 reads

Posted in Devin Knight on 10 May 2016

Temporary Post Used For Theme Detection (dff6a50a-5239-4df1-af43-b1e60d02dde4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (621301ab-a053-48fc-a7ec-01dc1d5fe152 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)


Read more

0 comments, 569 reads

Posted in Devin Knight on 15 December 2015

DirectQuery in Power BI Desktop

In the latest Power BI Desktop a new Preview features was released that now allows you to connect using DirectQuery to either SQL Server or Azure SQL Databases.  DirectQuery is a really neat feature that allows you to point to the live version of the data source rather than importing… Read more

3 comments, 1,030 reads

Posted in Devin Knight on 6 November 2015

Older posts