Blogs/Articles

My name is Rakesh. I live in Seattle and lead the Analytics team @ Expedia. I run the analytics and data science teams that build data models and metrics using Hadoop, Teradata, Tableau and other statistical tools. I use this site to publish a variety of misc stuff and videos that I hope people find interesting or useful.

New Course: Learn Data Analysis using Pandas and Python

Hello All, Today, I am launching Module # 2 of the Data Science Series – “Learn Data Analysis using Pandas and Python” In this module I teach you how to Analyze and Manipulate data using Python and powerful Pandas. Link:...

READ MORE

Module # 2 - Learn Data Analysis using Pandas and Python (Lecture Notes)

Chapter # 1 - Introduction A li’ll background: This is module # 2 of the Data Science track. Module # 1 Absolute basics of data science and Scikit learn We walked through simple concepts: What is data science and machine learning. How to build a career in machine...

READ MORE

Data Science using Python (Lecture Notes)

Chapter 1: A li’ll background: Data jargons - “Data Science”, “Data Analytics”, “Machine Learning”, “Python” , “R”... Where to Start? A little about me: I am Rakesh! Coder, Manager and work in the field of analytics I like solving analytical problems, hiking, XBOX, Photography, teaching...

READ MORE

Tableau Lecture Notes (For Udemy)

Chapter 0: A little about me: I am Rakesh! Coder, Manager and work in the field of analytics I like solving analytical problems, hiking, XBOX, Photography, teaching etc. My website: www.rakeshgopal.com Some feedback from my previous courses. About this course: Keep it simple! Provide...

READ MORE

Tableau Tutorial for Beginners

Tableau Training for beginners Are you looking to learn visualization for your next job as a data analyst or data scientist? If so, I have got a new course for you. I have recorded a series of videos to learn visualization using Tableau. You will learn, how to connect to different data sources...

READ MORE

Tableau Tutorials Lecture Notes

Chapter 0: A little about me: I am Rakesh! Coder, Manager and work in the field of analytics I like solving analytical problems, hiking, XBOX, Photography, teaching etc. My website: www.rakeshgopal.com Some feedback from my previous courses. About this course: Keep it simple! Provide...

READ MORE

SQL joins

Different Types of SQL JOINs Here are the different types of the JOINs in SQL: INNER JOIN: Returns records that have matching values in both tables SAMPLE SYNTAX SELECT column_name(s)FROM table1INNER JOIN table2 ON table1.column_name = table2.column_name; LEFT JOIN Or LEFT OUTER JOIN :...

READ MORE

TSQL Quiz # 1

Join my list to get latest updates on articles and courses. Hello All - I hope you all are enjoying the holiday season. I wanted to personally thank you for all your reviews, comments and messages. It’s really been an overwhelming experience. Students occasionally ask me for some problem sets,...

READ MORE

Interview Tips and Preparation Guidelines

Join my list to get latest updates on articles and courses. It's been more than a month since I last uploaded a course. I am glad that more than 130,000 students have taken up my databases courses. I keep a close eye on the Udemy forums and my Udemy Inbox for your questions and doubts and try...

READ MORE

Where do I start to learn SQL Server Databases

In the last few months, I have been getting a lot of emails via linkedin and my website asking about pointers and resources to start learning SQL Server / Querying. Hence I am putting together this article, detailing some basic steps that an absolutely newbie to SQL can start with. SQL server is...

READ MORE