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.

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), and I love talking about Coog (as you'll find out soon). I work as a Data Analyst/Financial Analyst for a Metals Co. located in Seattle, WA. I have been in my current position for 4 years. I work primarily in R for Analytics and R Shiny for Deployment. I have built numerous apps over the past few years. My hope is that I can help you in learning R. Yes, the Rhyme Interface will help you. But. You also must take what you learn and practice, practice, practice. So... Let's get after it. See you soon.

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
Please email us at and we'll respond to you within one business day.

No sessions available

More Projects by Chris Shockley