Row Number for Duplicates in Excel VBA
Recently I came across a situation to find the row number for duplicate values.
In SQL Server there is a inbuilt function ROW_NUMBER() read more but in Excel there is no direct function as such.
Conditional Formatting on Errors in Excel
Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.
Visualize LinkedIn Connections
I exported my LinkedIn and tried to get some insights with the data. I’ve created a basic dashboard with some of the findings.
Creating Heatmap in R
Today we’ll be seeing to create the Heatmap in R. In my last tutorial I’ve created the heapmap in Tableau.
Emergency – 911 Calls Heatmap in Tableau
I’ve created a simple dashboard in Tableau to visualize the frequency of the Emergency – 911 Calls.
Rank Chart in Tableau
Today we’ll be learning how to create Rank chart in Tableau. Rank chart is very effective way to show the ranking of the dimension variation across the year,category or any other dimension. The Rank chart is easy to create and very useful.
How to visualize Twitter networks with Gephi
Today we’ll see how to visualize use Twitter stream plugin in Gephi. Gephi is an open-source network analysis and visualization software package written in Java on the NetBeans platform (more at Wikipedia). We’ll also get to learn to create apps in Twitter.
Analyzing my Uber Trips in R : Part 2
These days I’m mostly reading, watching about time management, how to use time effectively and strikes about the travel time so I fetched my trip data from Uber and Ola. Uber(USA based but also operated in India) and Ola(India Based) both are online cab aggregator platforms provides cab booking facility though there web and app based platforms.