The Data School Blog
From Excel User to Alteryx User
Do you primarily use Excel to prepare and clean your data? What if I told you if there was a better way to create a data prep workflow that is repeatable, auditable, and easy to hand-over? A couple of weeks ago, I discovered a powerful tool called Alteryx. Our first...
Diary of an Alterook – Alteryx Decluttering Tips
Dear Internet Diary, In my first week at the Data School, I learned how to use this software called Alteryx. To describe it from an Alterook’s perspective, it's Excel in steroids – faster, stronger and smarter. You might be wondering by now: What in the world is an...
Looking to become a Data Analyst mid-career?
"Hi! I am Shiva. We tested our new Rehoboam, the world's most powerful AI droid, to predict stock market indices 15 minutes in future and have successfully reaped millions of profit." This has been a dream for both day and night for the past few years ever since I...
Week 1 Experiences
Well, when it came to choosing the topic of my initial post with the Data School; since I had personally read some ‘Week 1’ blogs which provided helpful indicators for what to expect for the beginning of my own DSAU adventure, what else could I choose for a first blog...
Week One – My new favorite tool, Alteryx!
First Week has just flown by and I am so glad I have joined The Data School Down Under. If not, I would not have known about the amazing tool – Alteryx! Alteryx is an intuitive drag-and-drop user interface. It's so simple to use where the user just has to drag a tool...
How to make the 80/20 Pareto Chart in Tableau
Let’s start with a little history lesson. The Pareto Chart is named after Vilfredo Pareto - an Italian civil engineer, sociologist, economist, political scientist, and philosopher. One of his discoveries was that 20% of the population in Italy unequally held 80% of...
The Data School Training Retrospective
Introduction As we wind up the final week of training, there is a sombre mood amongst the trainees in DSAU7. The 15 weeks leading up to this moment has felt both simultaneously long and incredibly fast at the same time. It's safe to say that everyone has learnt a lot,...
How to Survive Dashboard Week
From before I even started at the Data School, there seemed to be this air of fear around the fabled Dashboard Week. For those that don't know, dashboard week is essentially a whole week challenge that the Data School sets its students. The idea being that every day...
Dashboard Week \\ Day 5 – OECD Better life index
INTRODUCTION We made it! It's the final day of Dashboard week and it has been a hectic week. The week was not as hard as we expected but we went through our fair share of challenges and difficulties. However, I think everyone will agree that it was one of the most...
Dashboard Week 5 – Kevin’s Better Life Index
Hello again everybody, welcome to the final episode of Dashboard Week. In this episode we were given a dataset that essentially compares various countries for their livability based on various other factors. Unlike the other dashboard week days, this day was an extra...
Want to be a good project lead?
Being a project lead is not an easy job. If you are doing it right, you will feel responsible for every little thing that goes wrong and undeserving to claim credit for everything that goes right. It can be a lonely road. In this blog, I will go through my experience...
Tableau Sheet Swapping in Two Different Ways
Sheet swapping allows the users to swap the different chart in the same dashboard; for the purpose of this article, we create two charts in two separate sheets, 1. The map shows Sales for each State. 2. The line chart shows monthly sales. I will introduce two...