Combining specific excel sheets from multiple files

Last week DS19 carried out an internal project with data from the National Student Survey. This data was of survey responses collected from 2005-2019. We were taking the data from files on the NSS site, where each year had at least one file for responses. Each excel...

Looking back on Dashboard Week

Looking back on dashboard week, there’s definitely some things I’d go back and do differently, but I’m glad this is the case, because it means I’m making mistakes and learning. I’ve tried to whittle it down to the top three things I’ve learnt from dashboard week,...

Dashboard Week: Day 5

I didn’t publish a blog for the final day of dashboard week, which I think is because as soon as I finished my presentation on the last day, I felt like the week was complete and I mentally checked out. However, in the future its likely I’ll look back on these blogs,...

Dashboard Week: Day 4

For today’s challenge we were required to create a dashboard that visualized the findings of a research paper. The paper looked at the huge decline of insect abundance over the past 20 years. It was a relief that there were no surprises with regard to the challenge or...

Dashboard Week: Day 3

Looking back at today, I’m not sure how it went by so quickly. The requirements were to make a KPI dashboard in both Power BI and Tableau. Andy mentioned that the data prep would be minimal today, which was a relief as I think I was still scarred from yesterday’s...