Data Visualization For Social Problems презентация

Peter F Drucker

Data generation and analysis are not sufficient.
Consuming it as a team and acting in cohesion is.

Just
EXPOSE
the data to me

Low effort

High effort

High effort

Low effort

Creator

Consumer

There are many ways to aid data consumption

Just
EXPOSE
the data to me

Just
EXPOSE
the data to me

This clearly shows collusion of some form with the customers.

This happens with specific customers, not randomly. Here are such customers’ meter readings.

If we define the “extent of fraud” as the percentage excess of the 100 unit

meter reading, the value varies considerably across sections, and time

New section manager arrives

… and is transferred out

… with some explainable anomalies.

Why would these happen?

Just
EXPOSE
the data to me

… to inform and to entertain

Just
EXPOSE
the data to me

June borns score the lowest

The marks shoot up for Aug borns

… and peaks for Sep-borns

120 marks out of 1200 explainable by month of birth

An identical pattern was observed in 2009 and 2010…

… and across districts, gender, subjects, and class X & XII.

“It’s simply that in Canada the eligibility cutoff for age-class hockey is January 1. A boy who turns ten on January 2, then, could be playing alongside someone who doesn’t turn ten until the end of the year—and at that age, in preadolescence, a twelve-month gap in age represents an enormous difference in physical maturity.”
-- Malcolm Gladwell, Outliers

For example,
Are birthdays uniformly distributed?
Do doctors or parents exercise the C-section option to move dates?
Is there any day of the month that has unusually high or low births?
Are there any months with relatively high or low births?

Very high births in September. But this is fairly well known. Most conceptions happen during the winter holiday season

Relatively few births during the Christmas and Thanksgiving holidays, as well as New Year and Independence Day.

Most people prefer not to have children on the 13th of any month, given that it’s an unlucky day

Some special days like April Fool’s day are avoided, but Valentine’s Day is quite popular

More births

Fewer births

… on average, for each day of the year (from 1975 to 1990)

For example,
Is there an aversion to the 13th or is there a local cultural nuance?
Are holidays avoided for births?
Which months have a higher propensity for births, and why?
Are there any patterns not found in the US data?

Very few children are born in the month of August, and thereafter. Most births are concentrated in the first half of the year

We see a large number of children born on the 5th, 10th, 15th, 20th and 25th of each month – that is, round numbered dates

Such round numbered patterns a typical indication of fraud. Here, birthdates are brought forward to aid early school admission

More births

Fewer births

… on average, for each day of the year (from 2007 to 2013)

The average marks of children “born” on the 1st, 5th, 10th, 15th etc. of the month tend to score lower marks.
Are holidays avoided for births?
Which months have a higher propensity for births, and why?
Are there any patterns not found in the US data?

Higher marks

Lower marks

… on average, for children born on a given day of the year (from 2007 to 2013)

Children “born” on round numbered days score lower marks on average,
due to a higher proportion of younger children

Forest

Fuel

Haz & Wakf

Health and family welfare

Higher Education

Home

Horticulture

Housing

Information & Technology

Kannada & Culture

Labour

Law & Human Rights

Major & Medium Industries

Medical Education

Medium and Large Industries

Mines & Geology

Minor Irrigation

Muzrai

P.W.D.

Parliamentary Affairs and Human Rights

Planning

Planning and Statistics

Primary and Secondary Education

Primary Education

Prison

Public Library

Revenue

Rural Development and Panchayat Raj

Rural Water Supply

Rural Water Supply and Sanitation

Sericulture

Small Scale Industries

Small Industries

Social Welfare

Sugar

Textile

Tourism

Transport

Transportation

Urban Development

Water Resources

Woman & Child Development

Youth and Sports

Youth Service & Sports

BJP focus

JD(S)
focus

INC focus

What topics did parties focus on during questions?

Karnataka, 2008-2012

Fuel

Housing

Agriculture

Primary Education

Primary and Secondary Education

Woman & Child Development

Higher Education

Home

Cooperative

Forest

Adminisrative Reforms

Labour

Food & Civil Supplies

Tourism

Finance

Animal Husbandry

Transportation

Horticulture

Muzrai

Haz & Wakf

Transport

Medical Education

Medium and Large Industries

Excise

Major & Medium Industries

Kannada & Culture

Textile

Fisheries

Parliamentary Affairs and Human Rights

Adult Education

Rural Water Supply and Sanitation

Mines & Geology

Small Industries

Youth and Sports

Sugar

Planning and Statistics

Agricultural Marketing

Rural Water Supply

Fisheries & Inland water transport

Small Scale Industries

Youth Service & Sports

Sericulture

Law & Human Rights

Prison

Planning

Information & Technology

Public Library

What topics did the young & old focus on during questions?

Karnataka, 2008-2012

Young

Old

Just
EXPOSE
the data to me

… to connect the dots for your readers

Just
EXPOSE
the data to me

Just
EXPOSE
the data to me

… to allow your users to tell stories

gramener.com
for more examples