How to prevent Overplotting in data analysis
Hello friends! Overplotting is one of common issue faced by analysts during EDA (Exploratory data analysis), data visualization and getting inference the results. We’ll see few methods to prevent it.
Author: Niket Kedia
dplyr in R
Today we’ll see about the dplyr package in R also known as grammar of data manipulation. In the last tutorial we saw about the ggplot2 which is another famous package in R. It consist of set of functions which helps you for different type of data manipulation. I’ll be using medical cost data set from Kaggle(data source). I’ve listed all possible documentation and resources to learn more about the dplyr package.
ggplot2 in R
Today we’ll be learning about one of the most popular packages in R and which is ggplot2: An Implementation of the Grammar of Graphics. I’m using iris data set which is available in the R. ggplot2 create plot in multiple layers. I’ve used ggplot to create correlation heatmap. I’ve provided more resources in the end of the blog.
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.