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

This Week In Data – Episode 4 (What is Slack?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing how Slack can improve your company’s internal communication.

Over the past year, the Pragmatic Works team has been successfully using Slack for internal… Read more

0 comments, 313 reads

Posted in Devin Knight on 14 September 2016

This Week in Data – Episode 3 (What is the Internet of Things (IoT)?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re answering the question, “What is the Internet of Things?”

Most of you have probably been hearing about Internet of Things (IoT) and are curious… Read more

0 comments, 627 reads

Posted in Devin Knight on 7 September 2016

Power BI Custom Visuals Class (Module 15 – Table Heatmap)

In this module you will learn how to use the Table Heatmap Power BI Custom Visual.  The Table Heatmap has the look and feel of a pivot table or matrix report.  However, instead of seeing traditional values in the table you actually see colors that represent your values instead.

Module…

Read more

0 comments, 1,566 reads

Posted in Devin Knight on 6 September 2016

This Week in Data – Episode 2 (How to Ask for Help)

Welcome back to another episode of This Week In Data! In our first episode, Adam and Devin debated the value of certifications. In this week’s episode, we’re discussing the right way to ask for help.

For some, knowing when and how to ask for help can be a major… Read more

0 comments, 354 reads

Posted in Devin Knight on 31 August 2016

Power BI Custom Visuals Class (Module 14 – Tornado)

In this module you will learn how to use the Tornado Power BI Custom Visual.  The Tornado allows you to compare two categories of data vertically similar to a bar chart.

Module 14 – Tornado

Downloads

Read more

0 comments, 531 reads

Posted in Devin Knight on 29 August 2016

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

1 comments, 305 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, 408 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, 1,859 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

2 comments, 1,617 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, 484 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,557 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, 319 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,510 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, 463 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, 909 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

8 comments, 811 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, 852 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,832 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,737 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, 2,168 reads

Posted in Devin Knight on 14 June 2016

Newer posts

Older posts