Tag Archives: power bi

Power BI, power bi desktop

Power BI Architecture Diagram v3 is Now Available!

20 Comments

Download the latest version of the Power BI Architecture Diagram here!

Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power BI. Between Power BI Premium and Power BI Report Server, my head has been spinning trying to stay educated on all the new changes and enhancements. With all these announcements, it was definitely time to update my Power BI architecture diagram to reflect the addition of Power BI Premium and Power BI Report Server.

Here’s how to install and set up Power BI Report Server (Preview)

I’ve made a few changes in v3 of the Power BI architecture diagram. Continue reading Power BI Architecture Diagram v3 is Now Available! →

business intelligence, Power BI, power bi desktop, SQL Server 2016, SSAS

Microsoft Business Intelligence Materials from Discussion at Jacksonville University

Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the business intelligence stack. I met with Jacksonville University students and faculty and also had the pleasure of speaking with members of local businesses that are interested in leveraging Microsoft technologies. It was a wonderful experience and I had a great time!

If you’d like to download my slide deck from the discussion and presentation today, you can find that here.

Continue reading Microsoft Business Intelligence Materials from Discussion at Jacksonville University →

Power BI

Another 5 Power BI Tips

4 Comments

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.

View and download my latest Power BI architecture diagram here!

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 →

Power BI, Power BI Desktop Designer, Power Query

Power BI NFL Fantasy Football 2016 Reports

11 Comments

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?

Download the latest version of the NFL Fantasy Football reports here!

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 →

dataviz, Power BI, Power Query

Power BI and the Bing Maps API

5 Comments

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.

New to Power BI? Start with these 5 tips!

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 →

Community, Excel, Free Training, Power BI, SQL Server, SSAS

What’s New in Power BI Webinar Recording is Available

2 Comments

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 →

Community, DAX, PASS, Power BI

View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now 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.

Additional Resources

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)

Feedback

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!

Community, Power BI, Power BI Desktop Designer, Rstats, SQL Server, SQL Server 2016, TSQL

Microsoft & R Programming Session Materials & Resources Available

2 Comments

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.

New to R & Power BI? Start here.

R visuals in Power BI

Continue reading Microsoft & R Programming Session Materials & Resources Available →

Dashboard Design, Power BI, Power BI Desktop Designer

Download the Power BI Architecture Diagram

13 Comments

Download the latest version of the Power BI Architecture Diagram here!

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 →

Azure, dataviz, Power BI, Power BI Desktop Designer, Rstats

Getting Started with R Visuals in Power BI

33 Comments

Thanks to the December 2015 update released for Power BI, we can now use R to visualize our data in Power BI! Make no mistake, this is huge news and in this blog post I want to walk you through how to use the new R Script Visualization in Power BI and get you started with using R to create your first visualizations.

Read These Top 5 Power BI Tips

Not only can we create and download custom visuals from PowerBI.com to extend the capabilities of Power BI, we can use R to create a ridiculous amount of powerful visualizations. If you can get the data into Power BI, you can use R to perform interesting statistical analysis and create some pretty cool, interactive visuals.

Getting Started

If you’re new to R, like myself, R is a programming language for statistical data analysis. The R programming language is Continue reading Getting Started with R Visuals in Power BI →