If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers. The other reason is that the customer I’m speaking with have lots of questions about Power BI. So consider this one of my efforts at scaling myself.
If you enjoy this “Power BI tips and tricks” type posts, check out my first five Power BI tips and then my second five Power BI tips. You’ll probably enjoy those if you found this post helpful. So without further ado, I present to you more Power BI tips that I truly hope you’ll find helpful.
Continue reading Another 5 Power BI Tips
If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy football draft. I know, its nerdy, but I like Power BI and I like fantasy football so I thought why not?
With the new NFL season upon us, I thought I’d update my fantasy football report with the stats from the Continue reading Power BI NFL Fantasy Football 2016 Reports
This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street address information for some of the buildings and for other buildings they were missing the latitude and longitude.
The good news is that Power Query in Power BI is flexible enough for us to take advantage of the Bing Maps API so that we can lookup the missing pieces of information we need. In this blog post, I’m going to show you how you can use the Bing Maps API to look up an address based on a latitude and longitude or use a street address to find a latitude and longitude for the location. Continue reading Power BI and the Bing Maps API
Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to thank Thomas LeBlanc for having me to present. I had a great time presenting on the newest features of Power BI and what features you will see in the near future. Continue reading What’s New in Power BI Webinar Recording is Available
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power BI and time calculations! There were a bit of audio issues on my end but thankfully we were able to still have a great event with lots of great questions!
If you missed the webinar, have no fear! You can still watch the recording right here. Just jump ahead to minute 11 as I had some unfortunate connection issues!
If you have any additional questions or feedback, please leave a comment down below.
Download my PowerPoint slide deck here.
The PASS BI VC is a great group with tons of free, quality training events! I highly recommend you connect with this group so you can stay up to date on all their great events!
The PASS BI VC also has all their previous webinar recordings hosted on YouTube so definitely check that out!
If you’re new to Power BI, I suggest you start here.
Read more about Getting Started with R Visuals in Power BI
Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
I hope you enjoyed the webinar and that you maybe even learned a little something. If you have any questions, comments, or feedback, please leave it down below! Thanks for reading and watching!
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power BI User Group. We took an introductory look at how Microsoft’s acquisition of Revolution Analytics is making serious waves across the Microsoft data platform. We also walked through leveraging R in Power BI and SQL Server 2016.
Continue reading Microsoft & R Programming Session Materials & Resources Available
Update: I’ve updated the Power BI architecture diagram! Click here to view version 2!
As a Data Platform Solution Architect for Microsoft, one of my jobs is to help teach my customers what our amazing tools can do and how those tools work. Interest in Power BI is blowing up and I’m seeing most of my customers express huge interest in this awesome tool. To help facilitate the conversation about how Power BI works and how it can help my customers, I put together this diagram.
Also, each text block in the black area to the right includes a link to the documentation on PowerBI.com for the specific component. So if I’m looking at the diagram and I want to gather more information on the Power BI Gateway – Enterprise, just click the text block or point #2. Continue reading Download the Power BI Architecture Diagram