by Shashanka Rao | Dec 5, 2021 | Shashanka Rao
Subqueries allow us to combine data from multiple tables from a database into a single query. Breaking it down to its simplest definition, a subquery is “a query inside a query”. There are many variants of subqueries. While subqueries are generally used...
by Shashanka Rao | Nov 21, 2021 | Shashanka Rao
Having completed 7 weeks and 2 client projects in The Data School, our cohort – DSAU11 has had a feel for what client placements and most of our careers are going to be like in our foreseeable future. Below are my experiences from first 2 client projects. The...
by Shashanka Rao | Nov 14, 2021 | Shashanka Rao
Although most of the data processed on a day-to-day basis is numeric or categorical, there are times when this data is a part of a string. This could be a customer review, a sentence or a dialogue. Extracting this data from texts is vital to be easily processed by...
by Shashanka Rao | Nov 6, 2021 | Shashanka Rao
One of the main challenges of preparing a good dashboard is maintaining minimalism while delivering the required information. This needs to be sometimes achieved by making details available on demand. The following tutorial in brief shows how to achieve this with set...
by Shashanka Rao | Oct 31, 2021 | Shashanka Rao
Window functions are among the most useful inbuilt functions in Tableau. These functions can be used while carrying out aggregation over a certain set of rows of our interest. These set of rows can be called windows. This puts the term ‘Window’ in window...
by Shashanka Rao | Oct 23, 2021 | Shashanka Rao
The corner-stone of the industrial revolution was the ability to automate the boring tasks. Also, this hold good during the era of digital data revolution. While exploring and analyzing vast datasets can be very rewarding, a fair bit of this involves repetitive tasks....
