Varun Varma
Varun completed his master’s degree in Business Administration from the University of Technology, Sydney. While working as a Call Centre Analyst, he enjoyed working on data to derive insights. Consequently started learning Tableau, this is when he stumbled upon Data School Down Under. Over the weekend, Varun can be often found at one of the bush trails around Sydney.
Dashboard Week: Day 4 | Correlation of Electricity generation per capita with other factors
We are on day 4 of the dashboard week, more than halfway over. Must reiterate that I am loving it. We had to use any dataset from the Gapminder website. This is going it be very different from all our previous dashboard day’s, as Gapminder has data on various metrics...
Dashboard Week: Day 3 | Cricket World Cup 2019
On day three of the dashboard week, we were given a task to build a dashboard on Cricket World Cup, since the 2019 world cup final is scheduled this weekend. There were two big positives with the Day 3 dashboard The data was clean as it could get. Craig had recently...
Dashboard Week: Day 2 | Plastic Waste using Power BI
On day two of the dashboard week, we were given data about plastic waste. However, the curve ball was that we had to work on Power BI to build the dashboard. Not that just, we had to also tick a few requirements (example: Make joins only on Power BI, etc). The good...
Dashboard week: Day 1 | My attempt to create a Mortgage repayment calculator on Tableau
We are finally here, after reading a lot about the Dashboard Week from the blogs of Previous Cohorts. In this blog, I talk about the approach I have taken towards the task, not how I made it. API: The task we were given was to build a dashboard using domain.com.au’s...
Tableau Tip: Apply dashboard filter on Worksheet
There can be many use cases for applying dashboard filter on a Worksheet, but this blog illustrates how we can achieve the effect on the below picture. The dashboard in the picture above shows the overall sales by each subcategory. Upon clicking on any of the bars,...
Alteryx: Blob Convert Tool
In this blog I share details on how I used blob convert tool to convert blob data type to string data type. When working on one of our client projects, one of the tasks we were given was to analyse and create dashboards on Alteryx scheduler data. So, the files we were...
Tableau Tip: Separate/unmerge auto-concatenation of columns or rows
We can notice that, when more than 6 fields are placed in columns or rows, by default, the first two fields are concatenated by a comma. (in the above picture, fields 'Region' and 'Country' got concatenated) To avoid this, select Analysis > Table Layout >...
Tableau Set Actions: Compare selected dimension with remaining dimensions
For this example, the data source used is Sample – Superstore data. Creating the tableau dashboard below is broken down in to 4 main steps: 1 Creating the source sheet 2 Create the target sheet 3 Create dashboard and assign set 4 Add dashboard actions (click on the...
Extract data from an API using Alteryx
On Week 3 of our training, we were introduced to API’s. So, in this blog I will demonstrate how I used Alteryx to extract data from an API. The data covered in this blog is the list of Asteroids based on their closest approach date to Earth, from NASA's website. The...
Spatial Matching in Alteryx
Alteryx began as a mapping and reporting tool. So, undoubtedly there are numerous spatial functions and tools within Alteryx. However, in this blog, I will demonstrate how I used Alteryx to solve one use case. My objective was to find the percentage of locations that...