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

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, 155 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, 137 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,236 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, 798 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,021 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,542 reads

Posted in Devin Knight on 17 January 2017

Power BI Custom Visuals Class (Module 34 – Sankey with Labels)

In this module you will learn how to use the Sankey with Labels Power BI Custom Visual.  The Sankey with Labels is a type of diagram that visualizes the flow of data between a source and destination columns. This is visual is similar to the visual we showed in Module… Read more

0 comments, 1,043 reads

Posted in Devin Knight on 17 January 2017

Power BI Custom Visuals Class (Module 33 – Sankey Bar Chart)

In this module you will learn how to use the Sankey Bar Chart Power BI Custom Visual.  The Sankey Bar Chart is used to show a flow of data between different stages of a process.

Module 33 – Sankey Bar Chart

Downloads

Read more

0 comments, 271 reads

Posted in Devin Knight on 10 January 2017

Power BI Custom Visuals Class (Module 31 – Horizontal Funnel)

In this module you will learn how to use the Horizontal Funnel Power BI Custom Visual.  The Horizontal Funnel functions somewhat similar to the traditional funnel but it allows you to display a secondary measure and has a few more customizations than you would normally get. You’ll find that the… Read more

0 comments, 1,233 reads

Posted in Devin Knight on 29 December 2016

Power BI Custom Visuals Class (Module 32 – Percentile Chart)

In this module you will learn how to use the Percentile Chart Power BI Custom Visual.  The Percentile Chart is used to show a distribution of values over a range. This helps you answer questions like “What percentage of my customers bought 4 or more items”.

Module 32 – Percentile…

Read more

0 comments, 1,205 reads

Posted in Devin Knight on 29 December 2016

Power BI Custom Visuals Class (Module 30 – Linear Gauge)

In this module you will learn how to use the Linear Gauge Power BI Custom Visual.  The Linear Gauge would often be used to visualize a KPI. It gives you the ability to compare an actual vs target as well as showing up to two trend lines.

Module 30 –…

Read more

0 comments, 192 reads

Posted in Devin Knight on 21 December 2016

This Week in Data – Episode 16 (Top 5 Reasons You Need a Data Warehouse)

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 discuss the importance of having a data warehouse.

Are there really only 5 reasons you need a data warehouse? No, but in our latest… Read more

0 comments, 140 reads

Posted in Devin Knight on 14 December 2016

Power BI Custom Visuals Class (Module 29 – Dial Gauge)

In this module you will learn how to use the Dial Gauge Power BI Custom Visual.  While the usefulness of gauges on a dashboard is often debated, this module will show you how to configure one using Power BI.

Module 29 – Dial Gauge

Downloads

  • Power BI Custom Visual –…

Read more

0 comments, 166 reads

Posted in Devin Knight on 13 December 2016

This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)

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 discuss why companies are deciding to move to SQL Server.

In our industry, we often hear people talking about being on or migrating to… Read more

0 comments, 448 reads

Posted in Devin Knight on 7 December 2016

Power BI Custom Visuals Class (Module 28 – Sankey)

In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between a source and destination.

Module 28 – Sankey

Downloads

Read more

1 comments, 302 reads

Posted in Devin Knight on 6 December 2016

This Week in Data – Episode 14 (Hacking Your Professional Development)

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 discuss hacking your own professional development.

Having a plan for your professional development is essential when tackling your career goals. You need to have… Read more

0 comments, 216 reads

Posted in Devin Knight on 30 November 2016

Power BI Custom Visuals Class (Module 27 – Synoptic Panel)

In this module you will learn how to use the Synoptic Panel Power BI Custom Visual.  The Synoptic Panel is really one of the more impressive visuals available. This visual allows you to take an image and plot data on different regions that you define.

Module 27 – Synoptic Panel

Read more

0 comments, 1,088 reads

Posted in Devin Knight on 29 November 2016

Power BI Custom Visuals Class (Module 26 – Timeline)

In this module you will learn how to use the Timeline Power BI Custom Visual.  The Timeline is a great tool for filtering date values on a report.

Module 26 – Timeline

Downloads

Read more

3 comments, 1,442 reads

Posted in Devin Knight on 22 November 2016

This Week in Data – Episode 13 (Building Your Personal Brand)

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 discuss investing in your most important asset,you!

Many people don’t realize that their biggest investment should be in themselves. It’s important to make sure… Read more

2 comments, 197 reads

Posted in Devin Knight on 16 November 2016

Power BI Custom Visuals Class (Module 25 – Scroller)

In this module you will learn how to use the Scroller Power BI Custom Visual.  The Scroller has the appearance of an animated stock ticker with values and deviation values scrolling by on the design surface.

Module 25 – Scroller

Downloads

Read more

0 comments, 1,336 reads

Posted in Devin Knight on 14 November 2016

Older posts