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.
Author: Niket Kedia
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.
Profit Gap Analysis in Tableau
Hello friends! Today we’ll be learning how to do profit analysis in Tableau using the floating bar chart. As you can see in the image the final output.
Quick and Easy Analytics revision
Hello Friends! I’ll be sharing different resources to quickly revise analytics concepts. Sometimes if you don’t use some concepts for time you may forget and need a quick revision. Here I’m listing out few links you can use to revise.
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.
Step Chart in Tableau
Hello friends! Today we’ll see how to create Step chart in Tableau. Step charts are one of the visually appealing line charts. I’ve used superstore data for the tutorial. Easy to follow tutorial