# Plot Last 30 days & Last to Last 30 days of data on same chart area

I got a very unique request from client to show in my tableau dashboard. Actually they got this idea from Google Analytics, they want to show last 30 days and last to last 30 days of data on the same graph. So they want two line charts on the same axis. Let me elaborate this,[…]

# Use of Slicer in MS Excel

If we are analyzing dataset using pivot tables like this: Let suppose there are many values in column selected as filter (here we want to know detail month wise – it has 12 values), so each time selecting value from drop down is little difficult. Slicer can be used to simplify this scenario, as it[…]

# Date Column as Global Filter Between Multiple Data Sources

Making date, a global filter, is a little bit different from making a dimension. One of my friend has faced this scenario and while helping him on this, I came across this solution. I am going to explain this using Superstore Sales Target dataset, please follow below steps to achieve this: Step 1: As we[…]

# Logistic Regression – Basics

Logistic Regression can be binary or multi-nomial depends on the no of levels hold by response variable. Here we will discuss Binary Logistic Regression but same things are applied for multi-nomial as well. What is Binary Logistic Regression? Binary Logistic regression means response variable will have two values (either 1 or 0). It is a special[…]

# Relation between Correlation and Linear Regression

As these two terms looks similar Correlation and linear regression  but actually they are not. They both defines the relationship between two variables. Lets see how they are different: Linear regression finds the model (best fitted line) that can best predict the value of Y using value of X. Measure for fit for regression model[…]

# Linear Regression

What is Linear Regression? It is a predictive analysis technique. With this technique we can predict a variable called as response variable (or dependent variable) using one or more explanatory variables (or independent or predictor variables). When there is only one predictor variable, then method is called as simple regression otherwise multiple regression. Linear regression consists[…]

# XGBoost Algorithm

Applying XGBoost algorithm on data set given in “Otto Group Product Classification Challenge” in Kaggle. Install XGBoost package in R Understanding of Data: a. Id: unique ID of a product b. feat_1 to feat_93: 93 features given for a product c. target: class of a product labelled as “class_1”, “class_2”…., “class_9” (response variable) Check missing[…]

# Showing pie charts on Map in Tableau

This post I have created using Superstore data set. To get map in Tableau, we can use any field with globe sign like this: To draw map double click on this field, latitude and longitude will automatically come in row and column respectively.         Blue dots showing the center of all state[…]

# How to put Sheet Selector option in Tableau Dashboard

While creating a dashboard, I came across this which I am sharing with you all. It is a way to put sheet selector option in dashboards to switch between two sheets. Let’s start working on Superstore visualization present in Tableau 9, concentrate on two sheets: “Performance” and “Forecast” Follow below steps one by one: STEP 1:[…]

# Swapping of titles as Sheet Swaps in Tableau Dashboard

First let me introduce what TABLEAU is? This I have taken from Wikipedia and Tableau software site. Tableau Software is an American computer software company having it’s headquarter in Seattle, Washington. It has produced a family of interactive data visualization products focused on business intelligence. Tableau offers five main products: Tableau Desktop, Tableau Server, Tableau[…]