Consolidate files using VBA
Today we’ll be learning how to consolidate multiple excel files present in a folder save the output file using VBA. We’ll use FileSystemObject in VBA to achieve this.
Read moreTag: Data Analytics
Split data to Workbooks using VBA
Hello friends! It’s been very long I’ve written any article. I was super busy since last 4-5 months.
Read Excel files in R
Today we’ll be learning how to read excel files and write output files in R. There are multiple packages in R. We’ll see few packages available and how to use it.
Read moreWaterfall chart using multiple measures in Tableau
Hello friends! recently I got a requirement where the I had to create Waterfall chart using different measures. Data was not static but the format/structure was constant. Also data transformation was not allowed.
Exploratory data analysis (EDA) in R
Hello friends! today we’ll be see how to do exploratory data analysis (EDA) in R. EDA is an approach to analyse data and start with it read more. I’ve used medical cost data from Kaggle.
Reshaping data in R
Reshaping data is one of the important steps for data analysis and data transformation. Today we’ll see few of the methods and function in R. The tutorials is easy to follow. I’m using mtcars dataset which is available in R.
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.
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.