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.
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.
Today we’ll be learning some tips and tricks in Tableau to make out analysis faster. This we’ll be very helpful to increase your efficiency while working with large amount of data and tight deadline.
Today we’ll be learning about one of the very important functions Index function with Match function which is very strong strong combination.
There is always been this debate- which one is better Index-Match or VLOOKUP?
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more
Today we’ll be learning to connect to Postgre SQL like Amazon Redshift to R. So the package available in R is RPostgreSQL.
Some times we need to download the tables from the webpages to the Excel for our Analysis. If the number of tables is more than 1 it will be very time consuming to format the table. In this tutorial we’ll learn how to download multiple tables directly into excel sheet and No need of extra formatting. I’ll be using Excel 2016. We will step by step. Read more
Trend Charts are very good visualization technique in my earlier post Trend Chart in Tableau. I have used Tableau for the Trend Chart. In this tutorial we’ll learn how to make Trend Charts in Excel and use of Alt Key Codes and Paste Special in Excel.