MISSION 368

Guided Project: Analyzing CIA Factbook Data Using SQLite and R

In this guided project, you will put together everything you've learned in the data visualization course and this course. Using the R SQLite workflow and your R programming, analysis, and visualization skills from previous courses in our path, you'll create a data science portfolio project analyzing data from the CIA World Factbook that you can show to employers to demonstrate proficiency in data visualization, R, and SQL.

In this project, you will work with SQLite data in R and generate visualizations from your SQLite SQL query results. You’ll start by connecting to a SQLite database using the DBI and RSQLite packages. Once you connect to the database, you will be query the data and save the results to a dataframe. From there, you'll create histograms and explore outliers in the dataset using your R programming, data analysis, and data visualization skills.

Your mission will be to use the CIA World Factbook to uncover some interesting insights about the various countries in the database. To complete this project, we highly recommend downloading R and the DBI and RSQLite packages to work and following along with the instructions on your local machine.

Objectives

  • Working with SQLite data in R.
  • Generating visualizations from SQLite results.

Mission Outline

1. Overview of the Data
2. Summary Statistics
3. Exploring Outliers
4. Histograms
5. Next Steps

sql-fundamentals

Course Info:

Beginner

The median completion time for this course is 3.5 hours. ​View Details​​​

This course requires a basic subscription and includes four missions and one guided project.  It is the fifth course in the ​Data Analyst in R Path​​​

START LEARNING FREE

Take a Look Inside