Scott’s 5 Vacation House Rules

on 09 July 0 Comment

😎 It’s summer, perfect vacation time!  If you can, a change of scenery does wonders.  Inspiration and learning come from everywhere.  And nothing beats being somewhere else than the office, whether it be at home or the office office.

And if you can’t go somewhere right now, get inspired from tv shows.  I do watch a lot of crap tv, but I can still learn 🙂

What I really like are Scott’s 5 Vacation House Rules – so applicable to BI design!

  1. Do Your Research – understand your users and audience, know the data inside and out, what are the data points that will elicit action?
  2. Plan Your Design – how will your users interact with the report?  will they view it on mobile or their laptop? will it be integrated in a powerpoint? do your users know how to enable the filter panel, use the slicers or drill through? be intentional with the design.
  3. Get Noticed – make sure people know about the report and give it that wow factor!  doesn’t do any good if people can’t find it or aren’t even aware it exists.  promote promote promote!
  4. Get Your Hands Dirty – get your users involved to provide their design input or images they would like as part of the report.
  5. Be Your Guest – put yourself in the user’s shoes and test drive your report.  what questions would they want answered next? is it intuitive for someone of their skill level? does it look good on mobile? does the data flow in the right order?

 

Looking forward to being here soon! ⬇

Woot woot! PL 300 ⭐

on 07 July 0 Comment

I just passed the PL 300 Microsoft Power BI Data Analyst Exam!

It was a little sketchy to be honest if I was going to pull it off this morning, but lo and behold it was managed.

 

Tips:

Don’t be like me and avoid coffee this morning.  I had my reasons – didn’t want to have to go while driving, while taking the test, didn’t want to be nervous from the caffeine…but then I was a bit groggy and reading the case studies were a bit of a blur…

Join a study group to push you along… thank goodness for running into the Power BI Women Meet Up group via Twitter, I wouldn’t have passed this first time round for sure.  And bonus… got a voucher to waive the exam fees.  🤩

Make sure to get familiar with ALL the features of Power BI even if you don’t normally use them in your business needs.

 

Weeding

on 04 July 0 Comment

Long weekend = weeding -> the ones in the backyard

This always reminds me of an office conversation where my boss tells me to just douse everything in weedkiller.  I counter that I like to pull them out by the root (Elvis style).  And one of our chief scientists poses the question of wondering what will propragate next now that I’ve cleared out the space. 🤯

Just one of life’s many metaphors.

 

Of course, no 4th of July weekend post is complete without some Usher –

 

Me: Finally got rid of all these weeds!

Other weeds:

watch this

Data data everywhere, now what?

on 26 June 0 Comment

So now that we have data to work with, now what?  I wish I could remember the person who told me this, a representative for some application (I’ll have to look at my emails way back) – he told me about the 5 Cs of Data.

5Cs of Data

  • Current
  • Complete
  • Context
  • Consistent
  • Correct

In order to make this report or dashboard of use, it needs to be Current.  Understand what refresh schedule is needed or enough for this type of report.  Is a daily refresh enough?  In this case, a live connection would be ideal since it’s dealing with real time transactions and availability if we were to use it to buy.  If we were to just analyze trends, maybe an hourly refresh.  We’d also have to factor in the speed of the refresh.  Given my personal resources, and it’s working with web data, it’s a bit slow – approximate 30 minutes for 3,000 rows.  With organizational datasets, it could be 30 million rows within 30 minutes.

    • What is end use of report?
    • What is the refresh speed?

Complete – Usually we are missing pieces that would give us a better report – in this case, what about misspelled entries (add another query for common misspellings?)?  In organizations, data that is not structured (see if this can be addressed, if not data clean up is needed) can give multiple versions of a name and not aggregrate.  Think about the different scenarios of how the data you are working with can come across and account for as much of it as possible.

Context is what really gives data its meaning.  I attended a presentation by Cole Nussbaumer Knaflic (Storytelling with Data) and what I remember most is when looking at a report or dashboard, be blunt and think to yourself “SO WHAT?”.  If I see a record for sale for $20, how do I know how to act?  Is it a good deal or not? Having other data points such as market value would be a good start.  What does it cost to ship? How many have sold recently at what prices?  What is the condition of the item?  Does the seller have a good reputation?  And then take it a step further and make it easy for the viewer to know the overall score (good buy, poor buy).

Being Consistent is also key.  Making sure that comparisons are indeed apples to apples.  Apply the same parameters to historical data or account for changes in the new data.  Paying attention to what units are being reported, for example currencies and their exchange rates.

And finally, that the data is Correct.  Seems like a given but things happen during the journey of the data from the source to your end report.  An incorrect formula, a relationship that changed – make sure to check and put systems in place where you can easily identify areas that could go awry.  See how much of this can be avoided by going to the root cause of the error which leads to Roche’s Maxim –

Data should be transformed as far upstream as possible, and as far downstream as necessary.

Power BI Tips & Social Media

on 25 June 0 Comment

Social media can be good 🙂   Since I mindlessly scroll day in day out (although I have been doing so less in the past few weeks if I have to assess unscientifically), I may as well learn along the way… Twitter is great, and I am starting to find some people to follow on LinkedIn.

Here are some favorites (today) –

Twitter 

  • Wyn Hopkins @wynhopkins
  • Bas @HowToPowerBI
  • Daniil Maslyuk @DMaslyuk
  • Sandeep Pawar @PawarBI
  • Bernat Agulló @AgulloBernat

Not so much for learning but I enjoy their tweets –

  • David Eldersveld @dataveld
  • Classic Data Stack Bob @BobLovesData

LinkedIn 

Contoso? Rexco!

on 20 June 0 Comment

So I’m pretty much making this up as we go along since I have no data to publicly share, nor do I want to use Contoso.  Therefore, let’s follow the journey of Rexco! We’ll go into Rexco more later.

Today’s interest du jour is “Webscraping”.  I guess this is the idea of just trawling the internet and pulling together data that’s out there for us to consume.  Luckily, I don’t need to be a rocket scientist.  I just need to use Power BI Desktop and –

  • Get Data -> Web
  • Use the website I want and connect anonymously
  • See which suggested table works or Add Table Using Examples
  • Through the magic of Power Query, figure out the data that comes across and transform them accordingly

For this demo, let’s use discogs.com (https://www.discogs.com/sell/list?q=the+smiths&page=1) and try to gather data on The Smiths! Mind you I’m sharing my learnings as we go along, and any helpful tutorial links I come across.

 

Tips:  Make sure to get the url that gives the structure for the pages (try going to the next page and then going back to the first page).  Also check your search parameters!  Having ‘the’ in the search query as above muddies it up, and maybe use any advanced search parameters to really hone in on your search results.  Do this BEFORE transforming in Power Query.

Test out scraping a few pages first!  I put in 100 pages and it took 15-20 minutes to load… But check it out – we now have data that we can visualize!

 

Tutorials:

Power Query Get Data from Web by Example

Scrape Data from Multiple Web Pages with Power Query

 

the smiths power query data

1…3456