Final Project April 18-May 4

Final Project This assignment builds on the lectures, in-class assignments and homework throughout the semester. You will build a new database with the FBI and Census data using SQL and cleaning the data with Excel. You will export it to Tableau, generate data...

April 13 Class

Create a New Database Cleaned Census Data Ark Pop Money Counties 2014 ACS_14_5YR_DP03 (1) FBI Data ARK 2010-2014 Crime Data-Tableau-March4 HOMEWORK Data Cleaning  =Trim Paste Special, Values Transpose Find and Replace Clean Up Census Labels for SQL Import Counties...

April 6 Class

Import the FL_poverty data and clean up the labels. –You may find it easier to edit the labels on Excel first before importing them. Remember, no spaces 2) Join the Fl_nativity and FL_poverty tables in SQL. Join them on the Id2 field. Query SELECT * to show both...

April 4 Class

SQL – Importing Data, Creating a Database For this exercise, we will be using an open source database manager called SQLite that runs as an extension to Firefox. It basically turns your browser into a database program. Firefox...

March 28- 30 Class

Coding Time                           . Washington Post Graphics   Small Business Career Fair SQL Is Fun Really. What does SQL stand for? What is SQL and Why Do I Need It? Relational database....

March 14 Class

Tableau Mapping Tutorial Dataset for this tutorial: sample-superstore Link to transcript for basic mapping tutorial And…the tutorial Note: This tutorial uses a dataset that is slightly different than the one we are using. It lacks international data and some of...