What-IF Analysis in Excel
Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Percent of Total with filters in Tableau
Hi Friends! recently I came across with a situation where I’ve to show the Top city and Sale value as percent of total sales. Today we’ll be seeing how to maintain Percent of total even with filter applied. This tutorial is easy to follow.
Combined measures in single chart Tableau
Hi Friends! Recently I came across a situation where monthly sales where in different columns and the trend has to be displayed in single line chart in Tableau. In this tutorial we’ll see how to combine multiple measure in single chart in Tableau. Also the use of column chart in Tableau.
How to split Train and Test data in R
Today we’ll be seeing how to split data into Training data sets and Test data sets in R. While creating machine learning model we’ve to train our model on some part of the available data and test the accuracy of model on the part of the data.
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.