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.
Updating R to latest version in R studio on Windows
Updating the existing R version to the latest version from R studio itself on Windows. Simple, yet appealing!
SQL Christmas Tree using SQL server Spatial data
SQL is an amazing tool, if we know to use it the right way. Using the concept of the SQL server spatial data and some mathematics, I have built this Christmas tree the SQL way!!. Attached is the image of the output. The code is as below. You too can run the code for yourself and generate the tree.
Note: After Executing the code, to see the image, Click on the “Spatial results” tab below in the results window, Uncheck the ‘Show Grid lines’ box in the right pane. You will be able to see the image.
Read more
Using the Values() clause in T-SQL to get max() and sum() of values
Values() clause also known as Table valued Constructor(TVC) was introduced in SQL server 2008. This is a very useful clause and has variety of applications. One such application we will be looking here is to create a matrix of numbers and then display the sum of numbers and maximum values in each row of the matrix using values() clause. SQL code is as below:
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