1 of 18

Slide Notes

DownloadGo Live

CSCI E-59 Final Project

No Description

View Outline

MORE DECKS TO EXPLORE

PRESENTATION OUTLINE

1.

CREDIT CARD FRAUD

ON THE RISE DURING THE PANDEMIC?
Photo by MarkGregory007
2.

Key findings
There were 1,387,615 reports of identity theft in 2020.
Government documents or benefits fraud was the most common type of identity theft in 2020 after an increase of 1,663% from 2019. Those aged 30 to 39 reported the most cases of identity theft.
Kansas, Rhode Island, and Illinois were the top three states for identity theft per capita.
Credit card fraud rose by 44.7% over 2019 levels to 393,207 reports.
There were 1,108 data breaches in 2020, the lowest total since 2016.
The number of people affected by data breaches has decreased significantly, from over 2.5 billion in 2016 to just over 300 million in 2020.

Photo by Kevin Ku
3.

PRE-PANDEMIC

WHAT DOES THE DATA TELL US? LET’S TAKE A LOOK…
Photo by Nathana Rebouças
4.

2019

PRE-PANDEMIC
Photo by Markus Spiske
5.

2020

THE PANDEMIC
Photo by Edwin Hooper
6.

THE US

Photo by davidrossharris
7.

MERCHANTS

WHICH MERCHANTS LOST THE MOST MONEY?
Photo by Giorgio Trovato
8.

CONSUMERS

HOW MUCH MONEY DID CONSUMERS LOSE TO CREDIT CARD FRAUD?
Photo by London Lights
9.

CONCLUSION

WHAT DID THE DATA SHOW US?
Photo by Visual Content
10.

SQL 2 - QUERY

HOW MUCH MONEY WAS LOST DUE TO CREDIT CARD FRAUD IN 2020
Photo by Kevin Ku
11.

SQL 3 - QUERY

WHICH STATES SAW THE LARGEST INCREASE (TOP 10)
Photo by Kevin Ku
12.

SQL 4 - QUERY

HOW MUCH WAS THE INCREASE?
Photo by Kevin Ku
13.

SQL 5 - QUERY

WHICH MERCHANTS LOST THE MOST MONEY (TOP 10)?
Photo by Kevin Ku
14.

SQL 6 - QUERY

WHICH CUSTOMERS LOST THE MOST MONEY (TOP 10)?
Photo by Kevin Ku
15.

SQL 7 - QUERY

WHAT WAS THE LARGEST CATEGORY OF FRAUDULENT CHARGES?
Photo by Kevin Ku
16.

SQL 8 - ADD

ADDING A NEW RECORD
Photo by Kevin Ku
17.

SQL 9 - UPDATE

UPDATING A TRANSACTION
Photo by Kevin Ku
18.

SQL 10 -

UPDATING A TRANSACTION
Photo by Kevin Ku

Friend of Haiku Deck

Haiku Deck Pro User