About Me

I am a Senior BI consultant at Pragmatic Works Consulting.  Previously, I tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the books Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services, Knight’s Microsoft Business Intelligence 24-Hour Trainer and SharePoint 2010 Business Intelligence 24-Hour Trainer.  I have spoken at past conferences like PASS, SQL Saturdays and Code Camps.  Making my home in Jacksonville, FL, I am the Vice President of the local users’ group (JSSUG).

14 Responses

  1. Hey Devin, just watched your PowerView recording from SQL Pass last fall. I thought you’d enjoy reading my notes and things I found of interest from your session. Also, I think I’ll reference you in a blog post. Do you want to know when I do that? I’ll link to your site, so you get some SEO credit from it.

    Requires SQL 2012

    5 different Microsoft reporting tools

    PowerView – End Users
    If they can click a button than they can use PowerView
    End User Tool
    Everything just talks to each other and there’s no need for developer work
    Create fancy reports off of data models
    SSRS – Report Designer & Report Builder – Developers
    Developer Tool
    Static Report
    PowerPivot – Developers & End Users Combined
    Power User Tool
    Need to create relationships
    In Memory OLAP
    Ad hoc
    Excel –
    End User Tool
    Ad hoc Reporting Tool
    Performance Point – Dashboarding tool as part of SaharePoint
    Developer Tool
    Score cards

    what is power view?
    ad hoc reporting tools…excel pivot tables on crack

    his decision matrix on when to use which tool


    do the same things they can do in pivot tables, but bring in images and charts

    tool is targeted towards end-users


    download excel 2013 to see excel 2013 power view, released to manufacturing fall 2012

    requires silverlight 5

    can use BISM tabular model or standard multi-dimensional cubes (new feature)

    optimizing a data source for power view may deoptimize it for other reporting tools and other olap clients

    excel 2013 has power pivot on it all ready without a download

    he recommends watching 7 steps to getting kerberos right session (i think it’s chuck’s session)

    DAX is supposed to be as easy as Excel formulas

    DAX has really good intellisense

    the scatter chart animation was a really cool demo – about 60 minutes in

    the filter at 1:04 is also pretty cool

    click to interact inside powerpoint is way, way cool…way better than using screenshots of reports

    drillthrough to MOLAP might be in the next release

    MOLAP cubes relationships will come through

  2. Good evening my dear, I read your site and am interested to exchange ideas on the Power Map, here in Brazil few use, it is an extremely powerful tool. I use it every day to estastísticas of accident rates, but I wonder if there are new recuros within the power map so I can enjoy. Below is my contacts:
    Whatsapp: 03598291801
    Whatsapp1: 06296060114
    E-mail; brunosilver@outlook.com – or – bruno.silva@triunfoconcebra.com.br

    Big hugs.

  3. I attended your Advanced power seminar in pragmatic works. I have a simple question how do I fix the following problem ?

    Formula.Firewall: Query ‘ACCIDENT DATABASE’ (step ‘Added Custom’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.

  4. We have an SaaS app called Aluvii.com. We’d like someone to implement PowerBI embedded from start to finish into the app. Do you do that type of work?

  5. Hi Devin, I started watching the 3 hours webinar on PoweBI you did at http://pragmaticworks.com/Training/Details/Power-BI-Takeover
    Can you please let me know if the materials you use for your demos are available to download in order to follow with you
    Thanks in advance

    • Hi Salam. The course materials is something that’s provided with the paid version of the class that was mentioned during the session. Let me know if I can direct you do that.

  6. Hi Devin,

    My name is Sophie. I’m an Excel and Data Platform MVP in Montreal, Quebec (Canada). I’m also the leader of the Power BI user group in Montreal.

    We are now planning our next year of meetings and we would love to have you as a speaker. Unfortunately, we do not have any budget but we do have a nice crowd (82 persons at our last meeting).

    Is it something that you would be interested in?

    Please, let me know.


  7. Let me ask my co-organizers and I will come back to you on this!

  8. Hey, Devin,

    I sent out this link to my company team, and to the FISG (Florida IT Server Group) . . . you probably already have it somewhere – it’s Eric Ligman’s 2016 collection of free eBooks from Microsoft . . . and there is A LOT of SQL and Power BI docs and guidance available:


    BTW, I enjoyed your recent presentation to Jax FISG on Powershell . . . which was one of the TWO technologies that was identified by Mark Minasi at the Tampa IT Pro Camp that would be wise for IT pros to learn. He indicated there are some features on Windows Server 2016 that aren’t even available thru a GUI – exposed only thru Powershell. The other technology was CLOUD (Azure) . . . which, coincidentally was the beginning and end of YOUR presentation.

    Hope you and your readers enjoy.


  9. Hi Devin

    great series about Power BI custom visuals. You may want to review IBCS Charts as well? I can provide a trial version.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: