by Nathan Smith | Apr 18, 2017 | Daily-Class, Spring_2017, SQL
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...
by Nathan Smith | Apr 10, 2017 | Daily-Class, Spring_2017, Student_Work
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...
by Nathan Smith | Apr 6, 2017 | Daily-Class, Spring_2017
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...
by Nathan Smith | Apr 4, 2017 | Daily-Class, Spring_2017, SQL
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...
by Nathan Smith | Mar 28, 2017 | Daily-Class, Spring_2017, SQL
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....
by Nathan Smith | Mar 14, 2017 | Daily-Class, Map, Spring_2017
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...
Recent Comments