Creating my story with Data

So I was looking to make my resume stand out while presenting my skills with the new and shiny PowerBI. (my powerBI page in my site)

I was inspired by an article, Business Insider has created about Marissa Mayers resume.

So I have continued, just like with any other product, using my Business Analysis skills:

Defining the the Business need​:

  • Who is the audience?
    • Potential employer/customer
    • People I am looking to impress
  • Why I want them to see it? ​
    • To show case my skills with PowerBI
    • Look into the details of my resume without getting bored
  • What do I want to  show them? ​
    • How can I tell a story using data

Now that I know what is going to be part of my story with data, I have started to think about the technical aspect.

Technical requirements  ​

  • Real time update? Custom visuals? Sharing? Mobile? ​

​The real time update won’t be necessary, once a month I will update my current work status and the dashboard can be updated within 24 hours. My subscription (pro) allows up to 8 scheduled updates a day, with an hour minimum intervals. I can also manually refresh and republish the dashboard if this is a live demo. The reports were created for my web page, which is built using HTML CSS and some JS for the fun parts. The design is responsive but I will not create separate mobile version of the data visualizations. The out of the box PowerBI versions seemed too look fine in the mobile browser. Since the target audience is going to watch from the browser and not from the PowerBI mobile app as this is not a link to the dashboard but an embedded report.

Designing the solution

What do I need?

  1. Data Source to create a data set –
    • I have used first a google docs table but it had one problem, it was not saved as a table and I needed to save it again from scratch.
    • I have used a SharePoint list, but discovered that this cannot yet be a direct data source (this was done just a month before it became an option 🙂 )
    • I have used an Excel file, that is saved in a SharePoint library and is accessible publicly. (it’s called One Drive bc I have first saved it there and than moved to the SP library. It works from One drive the same way) I have connected this as a data source in PowerBI, after saving the data in the Excel as a table which is very important to make the spreadsheet a valid data source.
      The data source contains a line for each month since my graduation and starting my career, September 2005 till today (March 2017). In each line, I have shown my work location, the field, technologies I have been working with, company I have worked for and off course the job title.
  2. Report/Reports
    Based on the data-set I have created a new report:
    2.1 dragged the first data visualization I have chosen, the map, checked the columns from the table indicating location and
    2.2 Chose the next visualization the Treemap, chose the Group as the Location city, the Values as Count of Workplace (which will count the number of times the specific workplace is displayed in the rows)
    2.3 Dragged the bar-chart visual to have the information regarding my experience in each industry type to be presented.
    The Treemap visualization filter selection can be seen here:
  3. Publish option –

I have saved the report in my PowerBI account, that means it was uploaded to my storage, the PowerBI API library, on my Office365 account. After which I have chosen in the menu File-> Publish to web
PowerBI have opened a wizard, where I could choose the option of embedding in my WebSite. The result was the following: 

This is what I have pasted in the HTML code of my WebSite:

<div class=”container”>
<div class=”row”>
<iframe width=”800″ height=”600″ src=”https://app.powerbi.com/view?r=eyJrIjoiZTY4Y2M4NTktMjZmMS00ZWEwLTkyZmQtMDliMmMyZjRjYmVjIiwidCI6IjAyMTJmZDNkLWQ1ZGYtNGVkNy05NzYyLTQ5ZGRmZDQ1ZGM1MCIsImMiOjZ9″ frameborder=”0″ allowFullScreen=”true”></iframe>
</div>
<div class=”row”>
<div class=”col s12″>
<iframe width=”800″ height=”600″ src=”https://app.powerbi.com/view?r=eyJrIjoiN2NjZDIzMjUtNThjNC00YTUzLThhNDgtMDBlMmM2ZGYzNzVkIiwidCI6IjAyMTJmZDNkLWQ1ZGYtNGVkNy05NzYyLTQ5ZGRmZDQ1ZGM1MCIsImMiOjZ9″ frameborder=”0″ allowfullscreen=”true”></iframe>
</div>
<div class=”col s12″>
<h2 class=”text_h2″> MY PowerBI Twitter Feed </h2>
<a class=”twitter-timeline” href=”https://twitter.com/search?q=%23PowerBI%20from%3Ayana_berkovich” data-widget-id=”843961672100274176″>Tweets about #PowerBI from:yana_berkovich</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?’http’:’https’;if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+”://platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”);</script>
</div>
</div>
</div>

The last div is for the Twitter feed related to PowerBI that I have created, just to add this is just for fun and actually works! 🙂

Testing ​

  • Hi there, have you seen my page yet? (5 AM Israel time is 7 PM in Vancouver…)​ I have asked people with different browsers and used the chrome different sizing option to test in different screen sizes. (There are still some problems with the top links in my site but that’s not part of the PowerBI topic…so next post)

Requirements gathering featuring myself as the business user is a very interesting experience; Documentation is still important! (Otherwise it takes you forwever to find the right report.​

The page link: http://yanaberkovich.com/powerBI.html ​

The link to the lightning session

Leave a Reply

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