# Linear Regression

Linear regression is a regression model which tries to predict the relationship between the dependent variable Y and independent variable X in a linear fashion.

y=mx+c

It is a regression models which mean that it is used to predict continuous values.

Eg: Stock prediction, Insurance amount prediction, Loan amount Prediction…

# Different types of SQL JOINs

Using the JOIN clause in a query, we can combine row data across two separate tables using this key.

INNER JOIN

The INNER JOIN is a process that matches rows from the first table and the second table which have the same key to create a result row with the…

# Pandas in Python

Pandas is used for data manipulation, analysis and cleaning.

What are Data Frames and Series?

Dataframe is a two dimensional, size mutable, potentially heterogeneous tabular data.

It contains rows and columns, arithmetic operations can be applied on both rows and columns.

Series is a one dimensional label array capable of…

# Brief Introduction to Tableau and Visual Analysis.

Tableau is a software visualization company which produces interactive data visualization products focused on business intelligence.

It allows the customers to spend more time on data analysis and less on data wrangling.

Components of Tableau

Tableau Architecture

It operates in three segments

1. Data Sources
2. Tableau Server
3. Tableau Desktop and the…

# How to rearrange columns in ascending or descending order in SQL?

## LIMIT and OFFSET clauses helps in further optimization.

The LIMIT will reduce the number of rows to return, and the optional OFFSET will specify where to begin counting the number rows from.

Let’s create a table.

CREATE TABLE Enrollment(Id int, StudentName Varchar(30), DOJ int);
insert into Enrollment values(1,’Preet’, 2009),(2,’Aman’, 2011),(3,’Bharathi’, 2003),(4,’Ishan’,2003);

select * from Enrollment;
— Sorting Date…

## Lolithasherley

Get the Medium app