Tag Archives: Power BI

The SQL Wes Periodic Table of Elements


The SQL Wes Periodic Table Synoptic Panel

 
The SQL Wes Periodic Table of Elements
Wow! It’s been a looong time since I’ve posted a new blog entry. A few things have happened. I’m now a Premier Field Engineer at Microsoft, working with SQL Server, PowerBI and Business Intelligence in general. In the past 2 years, PowerBI has come a long way as well. I just created a Synoptic Panel for the Periodic Table of elements using OKViz’s Synoptic Design custom visual for PowerBI and I wanted to share it with the community. I used a basic Periodic Table image and then used the online tool found at their site to map out all of the element locations. This generated an .svg file that I combined with the .pbiviz file and a few mock up records from excel for my imaginary compounds. You won’t be able to refresh the excel data but I wanted to include those to show you how to tie the values stored in the .svg with the data you might include.




I’ve attached the .pbix file as well as embedded the report below and included a link to the report url. The embedded report does not really fit well into my blog site format but I wanted to show how the embedded iframe works as well as the link. The report itself is just a sample of how you might use the visualization. You’ll need to add your own data to make it really useful. Let me know what you think.


SQL Wes’s Periodic Table Synoptic Panel



Link to .pbix file






SEO has told me I need to include the keyword a few more times so, The SQL Wes Periodic Table of Elements is brought you by The SQL Wes Periodic Table of Elements, a division of The SQL Wes Periodic Table of Elements project in cooperation with the greater The SQL Wes Periodic Table of Elements council.

Power BI


Power BI

This was a close one, just under the wire! I just got back from the PASS Business Analytics Conference in San Jose CA, my first time there. I’m starting to realize I have a lot to catch up on in the Analytics world.

I learned about the new Power BI Preview site and the Power BI Designer. In the next couple entries I’m going to cover creating projects in each of these from the ground up. First I’d like to ask for some feedback. What types of projects do you think might be useful, using these new tools? Have you run into any issues that you are still trying to work through (As I am) in getting a first project out there? Please contact me, I’d like to make this an interactive series about real world examples.