Lawrence Dignan

Here is the exercise.
And here are the workbooks [2012 Presidential Election Results by District.xlsx and Portrait 113th Congress.xlsx]

Here is the exercise.

And here is the Excel workbook you’ll need [Pew Story Data (Jan – May 2012).xlsx]

Some quick instructions:

You must complete the quiz by the start of class on March 25.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It […]

Data integration

GOP Analytics

Dashboard best practices

The One Skill You Really Need

Here is the exercise.

And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].

Here is the exercise.

Some quick instructions:

You must complete the quiz by the start of class on March 18, 2019.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to […]

Performance indicators

Tyranny of success: Non profits and metrics

Tracking health

Wearable tech

Here is the exercise.
And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].

Here is the exercise.

Some quick instructions:

You must complete the quiz by the start of class on  March 11, 2019.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to […]

Damn Excel (amen to that)

Data credibility

Data corruption tricks

Clean data top 10

Here is the study guide for the first midterm exam. Here is also a more detailed version based on notes from class.

Here is the exercise.

And here is the graphic file you’ll need: Philadelphia Area Obesity Rates.png.

Right-click on the file and save it to your computer.

Here is the exercise.

Before you start, save this Tableau file and the studentloans2013 Excel workbook to your computer. Remember, to save the file right-click on the link and choose “Save As…” (don’ […]

Some quick instructions:

You must complete the quiz by the start of class on Feb. 18, 2019.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […]

NYC Cab Viz

Telling story with Data

Cool infographics Chapter 1 and Chapter 6

In the comments section. Then it’s easier to click and go over.

Here is the assignment. Note that the assignment on the PDF is labeled Assignment 2, but ignore it.

Here is the worksheet as a Word document to make it easy to fill in and submit (along with your Tableau […]

Here is the exercise.

And here is the spreadsheet you’ll need to complete the exercise [In-Class Exercise 4.2 – FoodAtlas.xlsx].

Make sure you right-click on the Excel file link and select “Sa […]