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.
Data School Training: Reflective Blog
Here we are at the end of our (DSAU 3) 4-month training period. However, because of the intensity of the program, it felt like 4 weeks. In this blog, I try to explore how my decision to apply to the data school turned out. Application to Data School: Data...
Dashboard Week: Day 5 | Journalist Fatalities
On the final dashboard day, the dataset we were given was Journalist fatalities recorded since 1992. The curve ball this time was that we had to use Tableau version 8.3 only. Using Tableau 8.3 felt like playing a computer game that was 10 years old. However, layout...
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...