Data Analysis with R: Case Study with Real Data Using dplyr

This is a case study that allows you a glimpse into the life of a Data Analyst. The project isn’t glamorous, there are no machine learning algorithms but it reflects what a Data Analyst does most of the time. The tools we learned in the previous chapter along with some new one’s will help us prepare the analysis for an RMarkdown or Shiny App Presentation.

Join for $9.99
Data Analysis with R: Case Study with Real Data Using dplyr

Duration (mins)


5.0 / 5


Task List

We will cover the following tasks in 44 minutes:


In this section we’re going to look at the Big Picture. What are we going to do to the data and why.


Sometimes Data doesn’t come in with Colnames as is the case with this Data. We will add the colnames. Just follow me along.

More Clean Up

We’re going to discuss how to change the class of a Vector. This is important. I also will show you a quick way to look at the data to see what is needed to be changed.

Funny Data

Funny data isn’t funny if you don’t catch it. It can spell trouble down the road when others are looking at your work. Come in and we’ll learn some of the more basic ways to check for funny data.

Stripping Out Data

In this chapter we’re going to remove data the old fashion way using Base R. Come in and see how to do this and also to keep up with the lesson.


Finally. I told you in Chapter 2 we would do Lubridate. Better than late than ever. I’ll show you a couple useful functions within the package.

Adding a Column

In this chapter I will show you how to add a column to your data set. You can also use this for feature engineering when building models down the road.

Tables and Branches

We’re going to do some analysis using our old dplyr tool set. We’re going to group by Branch and then do some analysis to see which branches are not living up to the others.

More Analytics

Let’s dive in a little further and see how the Credit Department might freak out at some of these orders.

Final Thoughts

Watch Preview

Preview the instructions that you will follow along in a hands-on session in your browser.

Chris Shockley

About the Host (Chris Shockley)

I am an R enthusiast, hiker, and amateur astronomer. My favorite hike is located in Mt. Rainier National Park, my favorite Deep Sky Object is Alberio, and my favorite R package is dplyr (since I use it everyday). I have a dog named Coog (Lllasa Apso)., I work as a Data Analyst/Financial Analyst for a Metals Co. located in Seattle, WA. I have been in my current position for 5 years. I work in SQL, R, R Shiny, QGIS. Because I have traveled the roads you are on I believe I will be an asset and will add value to your programming repertoire. We will walk through multiple examples and get to know each other through the process. Don't take my word for it though. Come on in and take a Project or two. Regards, Chris Shockley

Frequently Asked Questions

In Rhyme, all projects are completely hands-on. You don't just passively watch someone else. You use the software directly while following the host's (Chris Shockley) instructions. Using the software is the only way to achieve mastery. With the "Live Guide" option, you can ask for help and get immediate response.
Nothing! Just join through your web browser. Your host (Chris Shockley) has already installed all required software and configured all data.
You can go to, sign up for free, and follow this visual guide How to use Rhyme to create your own projects. If you have custom needs or company-specific environment, please email us at
Absolutely. We offer Rhyme for workgroups as well larger departments and companies. Universities, academies, and bootcamps can also buy Rhyme for their settings. You can select projects and trainings that are mission critical for you and, as well, author your own that reflect your own needs and tech environments. Please email us at
Rhyme's visual instructions are somewhat helpful for reading impairments. The Rhyme interface has features like resolution and zoom that are slightly helpful for visual impairment. And, we are currently developing a close-caption functionality to help with hearing impairment. Most of the accessibility options of the cloud desktop's operating system or the specific application can also be used in Rhyme. However, we still have a lot of work to do. If you have suggestions for accessibility, please email us at
We started with windows and linux cloud desktops because they have the most flexibility in teaching any software (desktop or web). However, web applications like Salesforce can run directly through a virtual browser. And, others like Jupyter and RStudio can run on containers and be accessed by virtual browsers. We are currently working on such features where such web applications won't need to run through cloud desktops. But, the rest of the Rhyme learning, authoring, and monitoring interfaces will remain the same.
Please email us at and we'll respond to you within one business day.

Ready to join this 44 minutes session?