Analytics Tuts

SQL Christmas Tree using SQL server Spatial data

December 26, 2018 Varun S Leave a comment

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

October 8, 2018 Varun S Leave a comment

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

September 30, 2018 Niket Kedia One comment

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.

R
RStudio

Exploratory data analysis (EDA) in R

September 30, 2018 Niket Kedia One comment

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

September 29, 2018 Niket Kedia Leave a comment

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.

R
RStudio

Step Chart in Tableau

September 16, 2018 Niket Kedia Leave a comment

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

Tableau

How to prevent Overplotting in data analysis

September 16, 2018 Niket Kedia Leave a comment

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

September 2, 2018 Niket Kedia One comment

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.

« 1 … 10 11 12 13 14 … 25 »