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.
Hi Reza,
Is it possible to download a copy of the .pbix file to further practice my power bi silks. Thanks
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 Yousef
This is not coming from Excel data. All of that is coming from the RD website mentioned in the article.
Cheers
Reza
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
Thanks.
In this particular report, I engineer them from the name field, because the base URL is the same anyways. however, you can fetch the URL from the website too. I might write about it in another blog post. the technique is similar to the method I described here for images.
Cheers
Reza