Microsoft Regional Director’s Power BI Report

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

Over the last week of December 2019, I’ve had a bit of time to play with some free available datasets over the internet. One of them was the SQL Saturday data which I built a Power BI report for it, and another one is the Microsoft Regional Director‘s data. Let’s see what I built for that.

Who is Microsoft Regional Director?

When I became Microsoft Regional Director, I had the same question; Who is a Microsoft Regional Director, what it means, and what they do? Let me clarify that a little bit for you here;

Microsoft Regional Directors are NOT working for Microsoft. RDs are trusted advisors for Microsoft in different aspects of the technology. They have an architectural view on the technology rather than a deep technical view on a very specific subject. They are familiar with the competitive technologies, service, and products in the market, and can advise Microsoft on the right track towards success. Being a Microsoft Regional Director is not against being an MVP, In fact, many RDs, are MVP too.

If you like to know more about being a Regional Director, and how I became one, read my post here.

There are about 154 Regional Directors all around the world, and you can see all their information on the RD website here.

Power BI Report

As I mentioned in the introduction, I found the RD website also an interesting source to visualize the data of that in the Power BI and came up with a few pages. Here you can see the report interactively:

Map View

Category View

Details View

Focus Area

You can use the navigation buttons on each page to navigate to the other pages:

and on some of the visuals, with a right-click you can drill through to the details view;

on some of the visuals, you also get RD page in the drillthrough, which will navigate to the full RD profile, like this:

RD Page:

The data of this report is directly fetched from the RD website and would be refreshed on a scheduled basis.

Have fun and see who are RDs in your region.

Video

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

6 thoughts on “Microsoft Regional Director’s Power BI Report

    • Hi Steve,
      Not the file, because it contains people’s data, and I don’t feel good sharing it.
      However, I will write some blog articles about methods used for building the report. One of those was fetching image urls, which I explained here.
      Cheers
      Reza

  • Hello Mr. Reza,
    I hope this letter finds you in well health,

    First of all I would like to thank you for sharing this article which amazing, Secondly, I would be thankful if you share the xcl file which contain the row the in order I can do slimier in the power
    best regards,
    Yousef

  • Hi Reza.
    Great article. I was just wondering how you got the profile urls. Are they ‘data’ on the site or did you engineer them from the name field?
    Regards
    Ian

Leave a Reply

Your email address will not be published. Required fields are marked *