Tesla Model S vs Competitors: Cost of Maintenance Including Battery Replacement

What are the maintenance costs of a Tesla Model S versus it’s competitors? In this video I break down the annual service costs and look at how much you’d save with a Tesla over a BMW 7 Series, Mercedes-Benz S-Class, and an Audi A7. Results Data Sources Audi Cost – https://www.edmunds.com/audi/a7/2014/cost-to-own/ Mercedes Cost – https://www.edmunds.com/mercedes-benz/s-class/2016/sedan/st-200713464/cost-to-own/ […]

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 […]