18 courses to learn R in 2018

Do you want to learn or get better at R programming?  If yes, you will love the list below. I have compiled a list of free and paid R programming courses. Most of them are online and free, so NO excuses about location or money to uplift your skills. The list includes courses for ALL […]

Calculating the median in Excel PivotTables

Calculating the median in Excel PivotTables

Yes, you read the title of this post correctly, you can calculate the median and lots of other functions in Excel PivotTables besides the regular options. If you’re a regular user of Excel PivotTables you might know you can change the summary function: Just right-click inside of the PivotTable → Go to Summarize Values By […]

Using R to predict if a customer will buy

In this post, I’ll show how to create a simple model to predict if a customer will buy a product after receiving a marketing campaign. Before I get into the example, I’ll briefly explain the basics about the model I’ll use (Logistic Regression). As shown in the image below, you want a model (function) that […]

Data Science for Beginners

Are you wondering what’s all this buzz about data science? The following videos will give you a good introduction to data science. Use the links below to go to each video: Problems solved by data science Data Quality Question/Problem Quality Example of linear regression model    Problems solved by data science   The first video […]

Import excel files with a dynamic starting row

This is the 4th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. The previous scenario covered how to import all Excel files in a folder getting the data below the 9th row. Therefore, the data on all […]

Import specific cells from Excel files

This is the 5th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. In this post, I’ll show you how to import the contents from specific cells of all files in a folder. For example, in the file […]

Import and clean each file from a folder

This is the third post of a series that covers everything about importing all files in a folder into Excel. Click here to see the series. The previous scenario covered how to import all Excel files in a folder, however, for that example we assumed that all files had the right format and were ready to be […]

Creating animations from ggplot2 plots

Note: This post was published on February 14th (Valentine’s day) First things first, Marioly, thanks for being a loving wife and an exceptional mother. Here’s an infinite love animation for you: In this post I’ll show you to use the gganimate package from David Robinson to create animations from ggplot2 plots. The animation shown above is […]

How to plot individual values with a mean line in Minitab

One of the most useful charts in Minitab is the Individual Values Plot since it allows you to see the distributions of the samples. You can also observe the general profile of the data if you add the mean values for each of the samples. To illustrate the use of individual value plots we will […]

Import all sheets from all files in a folder into Excel

This is the second post of a series that covers everything about importing all files in a folder. Click here to see the series of post. In this scenario I’ll show you to import all sheets from all excel files in a folder.  If you want to follow along, download the files from this link. […]