Anusha Kola
Anusha obtained her Bachelor’s degree in Chemical and Materials Engineering from The University of Auckland, New Zealand. She also did her Master’s in Food Technology from Massey University, New Zealand. After that, she moved to Australia and completed her PhD in Chemical Engineering from The University of New South Wales. Then, she became a Postdoctoral Research Fellow at the University of Melbourne, where she worked in Dairy Industry collecting and analysing data. Finally, she decided to not go any further in academia and follow her passion for Data Analytics. She chose to join The Data School to become a Data Analyst Consultant.
In her free time, she enjoys spending time with her family, travelling and cooking. The one meal she could eat all her life is Pizza!
Nested Sort in Tableau with Rank Table Calculation
Sorting the measures is an important step in building a vizualisation as it helps us digest the data on display quicker. Nested sorting is required when there is more than one dimension in the view. I’m using superstore data set for this exercise, I want to find the...
Dashboard Week Day 4: Boston 311 Service Requests
Last day of Dashboard Week!! Today, we only had 5 hours to build the dashboard, luckily we didn't need to use Alteryx. The data we were given was on 311 Service requests for Boston, one csv per year starting from 2014. This was a big data set. In Tableau, I unioned...
Dashboard Week Day 3: Museum of Modern Arts
Three down, One more to go! Today, we were given the data on Museum of Modern Arts Collection. At first glance, it looks like the data doesn't need a lot of cleaning but that wasn't the case. When multiples Artists were associated with one item in the collection it...
Dashboard Week Day 2: YouTube Trending data
We have survived Day 1 of the dashboard week. For Day 2 we were given the data on the videos that were trending on YouTube. There were lots of files in the csv and JSON formats. I used Alteryx to combine all the csv files using wildcard input first, then did the same...
Dashboard Week Day 1: Game of Thrones
It’s the first day of our much-dreaded dashboard week. Our challenge for today was to use an API to get data on Game of Thrones (GoT). We could choose from data on GoT characters, the books and the Houses. I chose to look at the characters. I have extracted the data...
How I prepared for the Alteryx Designer Core Exam
I recently passed the core exam and here is how I prepared for it. It is a free exam to take, you can sit it once to get a feel for what will be in the exam. How you prepare for the Alteryx Designer Core Exam depends on how much experience you have in using Alteryx...
Dynamic input tool in Alteryx
When you have multiple sheets with the same column headers in excel, rather than bring in one sheet at a time through the input tool in Alteryx you can use the dynamic input tool to bring all sheets into Alteryx at one go. There are 5 sheets in this file for five...
Tableau: Highlighting bars in a chart without using calculations
First plot your chart, in this instance I have used Sample-Superstore data to plot profit per sub-category in each category. For this I dragged the Profit (measure) to columns and category and sub-category (dimensions) to rows in that order. Drag Profit to colour on...
How to transpose a table of columns to rows in Alteryx?
In this blog I will show you how to transform a table of columns into rows using data from an excel file (you can also use other file formats that are supported by Alteryx). Step 1: Input the data (I’m using GDP from 1970 to 1979 in a excel file) into Alteryx...
5 Reasons why I chose The Data School
For Data enthusiasts who want to become Data Analysts, The Data School is a great place. I put down the top 5 reasons for why The Data School was appealing to me. Recruitment Process The recruitment process gives a very good understanding of what you should expect as...