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

Power BI – Problem, Design, Solution (Concatenated Tooltip)

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into with customers. Each post will be accompanied by a video (found in the bottom under… Read more

1 comments, 78 reads

Posted in Devin Knight on 24 May 2017

Power BI Custom Visuals Class (Module 52 – Bowtie Chart)

In this module you will learn how to use the Bowtie Chart Power BI Custom Visual.  The Bowtie Chart visual is designed to show a flow of data from one process or category to another.

Module 52 – Bowtie Chart

Downloads

Read more

0 comments, 92 reads

Posted in Devin Knight on 23 May 2017

Power BI Custom Visuals Class (Module 51 – Hierarchy Slicer)

In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual.  The Hierarchy Slicer visual is a great way to filter your day but within a hierarchical view of your data.

Module 51 – Hierarchy Slicer

Downloads

Read more

0 comments, 131 reads

Posted in Devin Knight on 17 May 2017

Power BI Custom Visuals Class (Module 50 – Narratives)

In this module you will learn how to use the Narrative Power BI Custom Visual.  The Narrative visual is developed by Narrative Science and it gives you the ability to automatically deliver analysis of your data.  The results look similar to a final report that a analyst might provide after… Read more

2 comments, 767 reads

Posted in Devin Knight on 9 May 2017

Power BI Custom Visuals Class (Module 49 – SandDance)

In this module you will learn how to use the SandDance Power BI Custom Visual.  The SandDance visual is an incredibly interactive visual that allows you to create insights to view your data in multiple ways and with animations.

Module 49 – SandDance

Downloads

Read more

2 comments, 1,103 reads

Posted in Devin Knight on 1 May 2017

Power BI Custom Visuals Class (Module 48 – Time Brush)

In this module you will learn how to use the Time Brush Power BI Custom Visual.  The Time Brush gives you the ability both filter your report and see a graphics representation of your data at the same time. The name Time Brush comes from the behavior used when you… Read more

0 comments, 902 reads

Posted in Devin Knight on 25 April 2017

Power BI Custom Visuals Class (Module 47 – Line Dot Chart)

In this module you will learn how to use the Line Dot Chart Power BI Custom Visual.  The Line Dot Chart gives you the ability to make a more engaging line chart that can actually be animated across time.

Module 47 – Line Dot Chart

Downloads

  • Power BI Custom Visual…

Read more

0 comments, 776 reads

Posted in Devin Knight on 18 April 2017

Power BI Custom Visuals Class (Module 46 – Table Sorter)

In this module you will learn how to use the Table Sorter Power BI Custom Visual.  The Table Sorter allows you to rapidly re-sort and rank values by within a table.

Module 46 – Table Sorter

Downloads

Read more

0 comments, 243 reads

Posted in Devin Knight on 13 April 2017

Power BI Custom Visuals Class (Module 45 – Network Navigator)

In this module you will learn how to use the Network Navigator Power BI Custom Visual.  You may find the need to use the Network Navigator when you’re trying to find links between different attributes in a dataset. It does this by visualizing each attribute as a node and the… Read more

1 comments, 891 reads

Posted in Devin Knight on 6 April 2017

Power BI Custom Visuals Class (Module 44 – Attribute Slicer)

In this module you will learn how to use the Attribute Slicer Power BI Custom Visual.  Using the Attribute Slicer you have the ability to filter your entire report while also being able to visibly see a measure value associated with each attribute.

Module 44 – Attribute Slicer

Downloads

  • Power…

Read more

0 comments, 321 reads

Posted in Devin Knight on 29 March 2017

Power BI Custom Visuals Class (Module 43 – Gantt)

In this module you will learn how to use the Gantt Power BI Custom Visual.  Using the Gantt chart you can easily visualize project timelines and deliverable completion.

Module 43 – Gantt

Downloads

Read more

1 comments, 1,483 reads

Posted in Devin Knight on 21 March 2017

Power BI Custom Visuals Class (Module 42 – Stars)

In this module you will learn how to use the Stars Power BI Custom Visual.  The Stars visual is a great way to visualize ratings data.

Module 42 – Stars

Downloads

Key Takeaways

Read more

0 comments, 361 reads

Posted in Devin Knight on 14 March 2017

Power BI Custom Visuals Class (Module 41 – Image Viewer)

In this module you will learn how to use the Image Viewer Power BI Custom Visual.  The Image Viewer visual helps in displaying images based on an image URL stored in your data.

Module 41 – Image Viewer

Downloads

Read more

4 comments, 1,315 reads

Posted in Devin Knight on 7 March 2017

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset.

Module 40 – Long Text Viewer

Downloads

Read more

0 comments, 1,200 reads

Posted in Devin Knight on 28 February 2017

Power BI Custom Visuals Class (Module 39 – Waffle Chart)

In this module you will learn how to use the Waffle Chart Power BI Custom Visual.  The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions… Read more

1 comments, 483 reads

Posted in Devin Knight on 21 February 2017

Power BI Custom Visuals Class (Module 38 – Mekko Chart)

In this module you will learn how to use the Mekko Chart Power BI Custom Visual.  The Mekko Chart visual is helpful when you need to analyze two different dimensions on a single chart.

Module 38 – Mekko Chart

Downloads

Read more

0 comments, 347 reads

Posted in Devin Knight on 14 February 2017

Power BI Custom Visuals Class (Module 37 – Gap Analysis)

In this module you will learn how to use the Gap Analysis Power BI Custom Visual.  The Gap Analysis visual is used to analyze the difference between two different groups of data you have.  For example, you might use it to analyze the gap between two answers people gave in… Read more

0 comments, 1,701 reads

Posted in Devin Knight on 8 February 2017

Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))

In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual.  This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to… Read more

0 comments, 1,042 reads

Posted in Devin Knight on 3 February 2017

Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))

In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual.  This is the first of two Box and Whiskers visuals that we will cover. The Box and Whiskers chart is used to show things like data outliers, clusters of data points… Read more

2 comments, 1,336 reads

Posted in Devin Knight on 24 January 2017

Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature shares some similarities to Subscriptions in Microsoft Reporting Services.

The idea of subscriptions is to… Read more

0 comments, 1,685 reads

Posted in Devin Knight on 17 January 2017

Older posts