SQL Tips and Tricks for Data Science

Get Ben Sullins’s 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists. Ben’s tips focus on practical applications of SQL queries for data analysis. Learn how to retrieve data, join tables, calculate rolling averages and rankings, work with dates and times, use window functions, aggregate, and filter data, […]

The Secret Algorithm Leonardo DiCaprio Can Use to Solve Climate Change Once and For All

  In this video, I walk through a recent Bloomberg study showing that CO2 emissions are indeed the cause of Climate Change. Then, I do my own analysis looking for the countries that we can work with to reduce their CO2 emissions and have the biggest impact on Climate Change. Bloomberg Report: http://www.bloomberg.com/graphics/2015-whats-warming-the-world/

How to Find and Remove Duplicates in Excel

In working with data from any source, you need to make sure you don’t have duplicate values. In many systems, this can be particularly cumbersome. In my favorite manual data processing tool, Excel, there are a few ways to simplify this process. I’ve used this technique to remove duplicates from Excel for years for its […]

Thoughts on Tableau Conference Keynote #Data16

  Today was the Tableau Conference 2016 Keynote where they announced a new product vision and demonstrated many upcoming features. While I couldn’t attend this years conference, I wanted to share my thoughts about the upcoming features with you online. See below for the full details of their new vision and don’t forget to share […]

How to Analyze Customer Feedback

In this tutorial, we’re going to learn how to Analyze Customer Feedback is a key step in any good business strategy. From understanding customers needs to learning where issues might exist in your processes there is virtually an endless list of use cases for customer feedback. In this tutorial we’re going take a look at how to build a […]

How to WOW Your Boss with Tableau

  I’ve been an advocate for Tableau’s BI and Analytics software for nearly 6 years now. It has given me the tools necessary to help dozens of clients transform their businesses into data-driven organizations. The real magic of Tableau, however is that anyone can learn how to use it and transform data into meaningful insight. In this […]