Shashanka Rao
Shashanka is a data enthusiast with a background in Environmental Engineering and a Masters’ degree in Sustainability and Renewable Energy Engineering. Having worked as an environmental engineer for several years provided him with the opportunities to analyze vast environmental datasets. He is interested in analyzing environmental issues like global warming,food and water scarcity. Shashanka aims on helping communities with coping with these issues.
Away from computer Shashanka enjoys, photography, pencil sketching and digital art. Shashanka’s choice of one meal that he wouldn’t mind having for the rest of life is -Pepperoni Pizza.
Tutorial on using Python in PowerBI (with a web-scraping example)
In this tiny tutorial, I’ll be demonstrating how to integrate Python script to get data for transformation and analyses on Power BI. I've used an example Python script to scrape web data in this walk through which must provide a well-rounded idea on how Python can be...
Importing Mapbox Maps into Power BI
This is a tutorial on importing and plotting Mapbox Maps on Power BI. The tutorial is split into 3 parts. The first part covers steps on how to get style URL for the map design and access token to Mapbox. The second part covers details on how to import Mapbox map into...
Adding Contexts to Headings without Parameters
This is a small tutorial on how to add a selected dimension member to a graph to add more context. While this can be done alternately using Parameters in Tableau, this method uses a Calculated Field. Where can this be used? This can be used as a heading for a graph...
Images with Bar Graph
Getting images as axes values in bar graphs This is a tiny tutorial teaching how to add images under bar graphs. Step 1: Add the respective measures as rows and columns. In this case I've used the dimension as Columns and measure as Rows. Step 2: Add a new measure...
Surviving Dashboard Week
A small blog on how to tackle Dashboard week at DSDU. Now that the Christmas vacations had been thoroughly 'vacationed', we were greeted by the much coveted 'Dashboard Week' (DW). The 3 syllables that has struck fears into the heart of every DS Cohort (At least the...
What’s Trending on YouTube?
As a part of the second day of my Dashboard Week at the DSDU, our cohort was given a really interesting dataset. This data comprised of trending YouTube videos along with a few associated parameters. This included, total views, comments, likes, dislikes, links to the...
A Beginners Guide to Subqueries
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 with a 'where'...
Client Project Weeks
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 Week:...
Regular Expressions for Text Processing in Alteryx
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...
Drilling Down on a Bar Graph
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...