The Data School Blog

How to create a Custom dates in Tableau?

In this blog, I will take through how to create custom dates for yearly, monthly, quarterly, Weekly, Daily, Last month, Last week Yesterday.     Step 1 – Create Parameters for Date Range: Create a parameter with a data type of string and create list for the above...

read more

How to understand the process of creating a macro?

How to understand the process of building a macro? When I first learn macro, my biggest challenge is understanding the principle of macro. I knew that the aim of macro is to generalise a workflow so that it can work on any input as long as the input matches the input...

read more

Alteryx Macro Input Tool

Alteryx Macro is a tool which isolates a alteryx workflow and packs in one tool. By definition, a Macro Workflow is a workflow that has the flexibility to be run as a single tool within another workflow. Macros save with an *.yxmc extension. Macro Input In a normal...

read more

How to Create a Jitter plot in Tableau?

   Jitter plot:   Jitter plots allow you to separate overlapping marks on a view. They reveal hidden data and makes it easy to visualize distributed data points.   In the below Visualization, you can see how each State has been overlapped to each other....

read more

A quick guide to Web Scraping

The term web scraping may not sound attractive, but last week we got the opportunity to really delve in to it, using a Zomato API to download data off their website. Their API allows you to access detailed information on each of the restaurants which you can massage and, if you’re a foodie like myself, use that information to find the next restaurant to indulge at.

read more

Download tool with Google Geocoding API

Downloading data from download tool via API is similar to ordering a Macdonald's meal via Uber Eats. Step 1: Choose your store : URL The URL of an API tells download tool which website do you choose for downloading your data. Take google geocoding as example, its URL...

read more

How To Get Into The Data School Down Under

If you’re reading this blog then you’ve probably heard about how amazing the Data School is. Maybe you’ve already submitted in an application. Don't worry. I've seen the signal and heard you scream, “How do I prepare for the selection process and stand up from the...

read more