Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
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.
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.
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.
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.
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.
I exported my LinkedIn and tried to get some insights with the data. I’ve created a basic dashboard with some of the findings.
Today we’ll be seeing to create the Heatmap in R. In my last tutorial I’ve created the heapmap in Tableau.