Devin Knight a Microsoft Data Platform MVP and the Vice President of Training at Pragmatic Works. He is an author of eight SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the a contributing member at the Jacksonville Power BI User Group.
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
Sure thing! I’ve also updated it a bit since then and will be presenting it again here http://www.pragmaticworks.com/LearningCenter/FreeTrainingWebinars/FutureWebinars.aspx
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.
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.
Hi Antony. In the query editor settings you can change the privacy levels to ignore these warnings from appearing.
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?
Hi Bryan! It sure is. Email me at dknight@pragmaticworks.com and we can discuss.
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.
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
Hi Sophie. Can you do remote sessions? If so I can do one for you!
Ask them to feed you, the food in Montreal is SPECTACULAR! Well worth a visit.
Let me ask my co-organizers and I will come back to you on this!
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
Hi Devin
great series about Power BI custom visuals. You may want to review IBCS Charts as well? I can provide a trial version.
THX
Klaus
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.
Hi Devin,
I attended the PowerBI Takeover class and had to leave early so I didn’t get to ask my most pressing question. I watched the video yesterday and was hoping there would be an example of how to do a simple dynamic axis using the following:
1) Disconnected Data Set (ex: Region Level … Region, Area, Site)
2) Single Select Slicer to select the above
3) Custom Column (ex: Show Region, Area or Site Name based on the Single Select Slicer value)
I was able to get the first two and a measure to do the third but I need a column so I can use the column in a visual as an axis.
Any assistance would be appreciated.
Thanks – Ryan
Hi Ryan. I’m not sure I understand. Are you saying you’re trying to put a measure on the visual axis? I think I may be misinterpreting something! 🙂
Devin, I am a fan. I have been in live training with you a couple of times–THANK YOU! I am currently viewing Advance Power BI Takeover. When I try a simple query folding, I am not able to view native query. I have a connection to a D365 CRM Account table. I have filtered the City for a single city name. The Filtered Rows step is the only step after Source and Navigation. When I right click the step, Native Query is grayed out. I have had this problem with other workbooks. Am I missing something?
Hi Sharon. Unfortunately there’s not an official list of sources available (that i’m aware of) detailing which data sources can be folded. It would surprise me if D365 cannot be folded but it certainly sounds like it. Can you test with a different type of source, like SQL Server, and see if the folding option appears again?
Caught your intro to the new book yesterday and picked up a digital copy. While reading it something jumped out at me that is in error. In the second chapter you state that the icon to change a column type is to the right of the column name – that is incorrect – it’s to the left.
Thanks Guy. I’ll report this to the publisher.
Dear Devin,
On June 18, 2016 you hosted a Power Bi presentation at SQL Saturday at Nova University in Ft Lauderdale.
I want to thank you personally for opening this world to me, it changed my life and my career.
I also learned SQL as part of the process of implementing Power Bi at the company I work for, this combo skill set is in super high demand now and you motivated me to get certified in Power Bi and SQL querying.
Thank you for everything you do and sharing your knowledge,
Kevin Mason
That’s so great to hear Kevin!