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.


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

Lesson Outline

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

Take a Look Inside