PostgreSQL connection to R
Today we’ll be learning to connect to Postgre SQL like Amazon Redshift to R. So the package available in R is RPostgreSQL.
Author: Niket Kedia
Top N Values in Tableau
In this tutorial we’ll be learning to create a parameter to find Top N values in Tableau. I’ll be using superstore data for the tutorial. This tutorial is very helpful for executive Dashboards.
Connect your Facebook account to Excel
Today we’ll be learning to connect to Facebook account to download data from your account.
SQL JOINS
When I was learning about SQL JOINS I found this cheat sheet and couldn’t anything find better than this. So I want to share with all of you guys.
I don’t think I have to explain about the SQL JOINS now.
Image is taken from- Image Source
Progress Bar Chart in Tableau
Today we’ll be learning to creating Progress Bar Chart in Tableau. I’ll be using superstore data of the tutorial.
Remove unwanted values from filter in Tableau
Today we’ll be learning how to remove unwanted values from filter using Sets in Tableau. I’ll be using Superstore data for the tutorial. Check out How to use Sets in Tableau for more information about sets.
How to use Sets in Tableau
Today we’ll be learning how to use Set in Tableau. I’ll be using Superstore data for the
tutorial.
SQL: Update Statement
Today we’ll be learning about one of the most important statement in SQL that is ‘Update’ statement. As the name says Update statement is used to update the records in the existing table.
Below the table called new_table in database.