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
Go to Master Data Analysis 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 → […]
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
Go to Master Data Analysis 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. […]
Import specific cells from Excel files
Go to Master Data Analysis 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. […]
Import and clean each file from a folder
Go to Master Data Analysis 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 […]
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
Go to Master Data Analysis 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 […]