Dashboard Week #4: Unwanted Call data (+ Power BI)

Today’s challenge was different from the first three days of Dashboard Week in two ways. 1. We had to use Tableau Prep over Alteryx, 2. We were not allowed to use Tableau Desktop as our visualisation tool. The data was from the Federal Communications Commission...

Dashboard Week #3: Indian Electricity Network

Today we were tasked to download data from Harvard Dataverse on electricity in India. The data was survey based (again). Respondents were asked about their energy source, their perceptions to energy use as well as background such as employment and where they lived....

Dashboard Week #2: Web Scraping the Rules of Parliament

Today’s challenge was based on Rules of Parliament and involved getting data from ParlRulesData.org. The only problem was, we weren’t allowed to download any data. Instead, all the information we needed had to be scraped from the website directly. Getting...

Dashboard Week #1: Survey Data

This week is the infamous Dashboard Week for DS16. Every day this week we will be given data at the start of the data. The challenge is to carry out any manipulation required in Alteryx, find a story and build a dashboard in Tableau which has to be published to...

Include a row outside of your Top N when mark is selected on a different sheet

Due to limited space on dashboards, charts with many marks are often cut down to a view which shows the Top 10 or 20 marks. Sometimes we might want to investigate a mark outside of the Top N and see this included on our view. This blog outlines how to build this functionality for both bar charts and sparklines with a use case from Makeover Monday.