Lawrence Dignan

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 Oct. 22, 2018.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […]

Performance indicators

Tyranny of success: Non profits and metrics

Tracking health

Wearable tech

Here are a few reports worth checking out. The first one is the UN’s 2018 report on global warming. You probably saw a headline or two about it last week. It’s worth seeing the whole report and the executive […]

Here are the instructions (in Word)   (and as a PDF).  Make sure you read them carefully!  This is an assignment that should be done individually.

And here is the data file you’ll need: VandelayOrders(Jan).xlsx.

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  Oct. 15, 2018.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […]

Damn Excel (amen to that)

Data credibility

Data corruption tricks

Clean data top 10

For 5 points on your lowest scored exam, here’s the assignment for the Analytics Challenge. This is good practice for the group project as well as an opportunity to compete and maybe win some money. I will look […]

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 Oct. 1, 2018.
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

Here is the assignment.

Here is the worksheet as a Word document to make it easy to fill in and submit (along with your Tableau file).

And here is the data file you will need to complete the assignment […]

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 […]

Here is the exercise

Here are the links in case you cannot click from the document.

History, Economics and Social Issues

Science and Health

English, Fine Arts and Entertainment

Remember to […]