Tag: VBA

Board #9: Overview of r/travel’s 2018 Survey

Hello!

On this post we’re going to check on my favorite work on Excel so far, and also the biggest one (3 boards). This was done some good time after my last board, which was a time when I was focusing on learning other things, and I believe it shows a lot of growth when we compare it to the previous posts. It’s more analytical, which made me proud and excited to learn more. (:

The data for these boards was a formulary (google forms) answered by 858 people who are part of the r/travel subreddit. It contained a lot of columns, so I’d rather leave the link for you to see here.

My idea for the boards was to:

  • 1st: Identify the main persona answering the formulary
  • 2nd: Identify their habits when traveling
  • 3rd: Cross both information to get some deeper insights

Tools Used: MS Excel – Charts, Pivot Tables; VBA (msgbox)

Continue lendo “Board #9: Overview of r/travel’s 2018 Survey”

Board #8: Fun with Pokemon Stats!

Hello!

I’m back with one of the things I love the most in the world: Pokemon! #nerd

There was no way I wouldn’t think about practicing Dashboards with Pokemon, so I pushed myself to go far on nostalgia to design this one. I found the dataset online long ago (I believe on Kaggle?) and it contained:

  • Pokemon name, Generation, types (main type, secondary type);
  • If the pokemon is legendary or not; If the pokemon has Mega or not;
  • Pokemon stats: HP, Attack, Defense, Speed, Special Attack, Special Defense, Total.
    • The stats are from the Pokemon Games released for GameBoy/Nintendo DS (Red/Blue, Gold/Silver…)

Tools Used: MS Excel – Pivot Table, Charts; VBA (msgbox)

Continue lendo “Board #8: Fun with Pokemon Stats!”

Board #5: Visualizing Caffeine Presence on Drinks

Hello!

In this post we are going to talk about the presence of Caffeine in certain drinks/substances we take, as well as check the daily limit and the consequences of overdoing it.

The dataset for this came from a challenge on a subreddit (r/dataisbeautiful) and it contains only 3 colums of information, being them:

  • Item (drink, food, medicament, etc)
  • Quantity avaliated
  • Total Caffeine in the quantity
  • Column added by me: Quantity of item until 400mg* of caffeine is reached

*400 mg = Maximum dose of caffeine recommended in 1 day

Tools used: MS Excel – Charts, Pivot Tables, VBA

Continue lendo “Board #5: Visualizing Caffeine Presence on Drinks”