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 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, 90 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, 110 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,048 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, 155 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, 542 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

1 comments, 539 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, 576 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,306 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,223 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,695 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, 670 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, 270 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,723 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, 551 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, 962 reads

Posted in Devin Knight on 6 November 2015

Power BI Desktop: A Guide for Excel Users

Today Microsoft officially released the new development tool for Power BI called Power BI Desktop.  First of all let me share my excitement in what this release means for Power BI.  The team at Microsoft has done an incredible job and the results are something they can truly be proud… Read more

1 comments, 3,326 reads

Posted in Devin Knight on 24 July 2015

Excel Services in Power BI

**Information current as of 7/22/2015**

There’s lots of exciting news this week with Power BI so expect several short blog posts detailing each.  Here’s one you can try now that I was pretty excited to see.

So here’s the news.  You can now expose standard Excel workbooks as another asset… Read more

3 comments, 2,939 reads

Posted in Devin Knight on 22 July 2015

Creating a Date Dimension with Power Query

A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here’s some of the quick benefits and reasons why you need a date table:

  • Helpful when filtering data
    • Filter by year, quarter, month, etc…
  • Helpful for…

Read more

3 comments, 2,549 reads

Posted in Devin Knight on 16 June 2015

Creating a SQL 2016 CTP2 Virtual Machine in Azure

With the CTP2 of SQL Server 2016 now released you may be eager to try it out.  One of the best ways to do this in my opinion is to set it up on a virtual machine.  You could certainly do this with VMWare or Hyper-V but my new preference… Read more

6 comments, 1,498 reads

Posted in Devin Knight on 28 May 2015

Power BI with Azure SQL Database

**Information is current as of 5/21/2015**

Recently Azure SQL Database was added as a new connection to the Power BI Preview. Read the notes about how it can be used here. The things I found especially worth noting were:

  • Every action sends a query back to the database. So…

Read more

0 comments, 2,104 reads

Posted in Devin Knight on 21 May 2015

Older posts