Today we’ll be learning about one of the very important functions Index function with Match function which is very strong strong combination.
There is always been this debate- which one is better Index-Match or VLOOKUP?
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more
Today we’ll be learning to embed Google Maps and the use of Webpage in Tableau. Workbook is attached to download and reuse. The data source used for the tutorial is taken from www.pier2pier.com with some changes. Read more
Today we’ll be learning about Pivot Table. Pivot Tables is one of the most powerful features of Excel. Pivots Tables are great way to summarize, analyze, explore, and present your data.
Worksheet is attached for downloading and reuse.
Today we’ll be learning to connect to Postgre SQL like Amazon Redshift to R. So the package available in R is RPostgreSQL.
Today we’ll be learning to create a Search Box in Tableau dashboard. I have used ‘Superstore’ data for the tutorial.
Today we’ll be learning to make Google charts and use of Pages in Tableau. You might have seen Google public data explorer if not please check out the link. The Data file and the workbook is attached for downloading.
Today we’ll be learning to make Waterfall chart in Tableau. I have used ‘World Indicators’ data for the tutorial. Tableau workbook is attached for download.
