About Me

Devin Knight a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the Vice President of the local users group (JSSUG).

15 comments

  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
    Dashboards
    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
    Customizable
    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
    PivotTables
    Ad hoc Reporting Tool
    Performance Point – Dashboarding tool as part of SaharePoint
    Developer Tool
    Score cards
    KPIs

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

    his decision matrix on when to use which tool

    https://devinknightsql.wordpress.com/2012/03/01/choosing-the-right-microsoft-reporting-technology-part-1-report-services/

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

    tool is targeted towards end-users

    devinknightsql.com

    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?

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

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

    Sophie

  6. 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:

    https://blogs.msdn.microsoft.com/mssmallbiz/2016/07/10/free-thats-right-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepoint-2016-sha/

    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.

    JimG

  7. Devin, I just came across your Power BI custom visuals series. Although I am a relative beginner in learning Power BI, I look forward to applying the visuals when I get there. By any chance, would you consider including the custom visuals which are available only on Github? I briefly looked at a couple, but I do not understand how to convert the code to a file which is importable into Power BI.

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