►
From YouTube: Redesigning Written Reports for Interactive Viewing
Description
No description was provided for this meeting.
If this is YOUR meeting, an easy way to fix this is to add a description to your video, wherever mtngs.io found it (probably YouTube).
A
Good
afternoon
and
thank
you
for
joining
us
for
today's
webinar
redesigning
written
reports
for
online
viewing
hosted
by
the
research
editorial
legal
and
committee
staff
association
of
ncsl.
My
name
is
angela
andrews,
I'm
director
of
ncsl's
legislative
staff
services
program
and
I'll,
be
your
moderator.
For
today,
before
I
introduce
our
speakers,
I
want
to
review
a
few
housekeeping
items.
A
Today's
webinar
is
a
platform
for
information
exchange
and
engagement
over
the
next
60
minutes.
We
encourage
participation
through
our
chat
and
q.
A
boxes
use
the
q,
a
box
for
questions
for
our
speakers
and
the
chat
box
to
connect
with
other
attendees
to
familiarize
yourself
with
the
chat
function
and
also
to
learn
who
is
with
us
today.
I
invite
you
to
tap
to
type
your
state
into
the
chat
box.
We
will
hold
a
formal
q
a
after
our
presenters
are
finished.
A
A
A
As
we
also
know,
legislators
are
busier
than
ever,
and
many
are
working
remotely
and
much
of
what
they
read
is
accessed
on
a
computer
screen,
so
redesigning
redesigning
lengthy
written
documents
as
more
concise.
Digital
files
requires
an
understanding
of
how
to
synthesize
data
and
use
visually
descriptive
tools
to
convey
information.
A
sean
also
serves
as
a
legislative
analyst
and
covers
individual
income
taxes,
income,
tax,
modeling
and
property
tax
refunds
he's
been
with
the
minnesota
hrd
since
2014
and
has
staffed
higher
education,
long-term
care
in
tax
committees.
Both
jared
and
sean
have
their
masters
in
public
policy
from
the.
A
B
We're
excited
to
be
here
sean
and
I
are
going
to
walk
through
some
of
the
work
we've
done
around
redesigning
written
reports
for
interactive
viewing,
but
before
we
get
started
with
the
presentation,
we're
just
going
to
do
a
quick
poll
to
gauge
some
of
the
familiarity
with
this
issue
and
some
of
the
software
tools
that
are
used
for
some
of
this
work.
So
you
should
be
seeing
a
poll
pop
up
on
your
screen
shortly
and
take
a
minute
and
respond
to
the
question.
A
Would
you
mind
reading
through
them
yeah,
so
we
have
90
of
you
participated
so
far,
so
26
say
they
have
never
heard
of
either
tool.
50
are
familiar,
but
I've
never
used
them.
20
have
some
experience
with
at
least
one
of
them,
and
only
two
percent
actually
use
one
of
these
tools
regularly.
B
Okay,
thank
you.
So
that's
helpful.
We
will
we'll
talk.
We're
gonna
try
to
keep
at
a
high
level
for
most
of
this
presentation.
B
B
I
will
spend
a
little
bit
of
time,
like
I
said,
going
over
some
of
the
software
that
sean
and
I
have
used
for
this
type
of
work
and
then
we're
going
to
try
to
spend
most
of
our
time
looking
at
examples
of
some
of
the
interactive
data
tools
that
we've
created
and
how
they've
replaced
some
of
the
written
documents
that
we've
used.
Traditionally
sean
will
have
a
few
cautionary
notes
at
the
end
of
the
presentation
to
think
about.
B
If
you
are
going
to
start
this
work
and
as
I
mentioned,
we'll
have
plenty
of
resources
for
you
to
learn
more,
not
only
about
the
software
but
about
interactive
data
tools
in
general,
and
then
we
should
have
plenty
of
time
for
questions.
At
the
end
of
the
presentation
like
angela
said,
if
you
do
think
of
something
as
we're
going
along,
feel
free
to
put
it
into
the
chat
box
and
we'll
try
to
get
to
it.
At
the
end
of
the
presentation.
B
So
I
just
wanted
to
start
by
giving
you
a
definition
of
interactive
data
tools.
That's
a
phrase
that
we're
going
to
use
a
lot
throughout
this
throughout
the
presentation
today
and
when
we
talk
about
interactive
data
tools,
what
we
really
are
referencing
are
web-based
tools
that
allow
a
user
to
explore
data
and
create
custom
data.
Visualizations
again,
that's
a
pretty
broad
definition,
but
we'll
go
through
a
few
examples,
and
you
should
have
a
good
sense
of
what
that
means.
B
B
B
The
interactive
data
tools
allow
for
exploration
of
data
by
a
non-technical
audience,
so
these
are
kind
of
a
way
that
you
can
put
data
directly
into
the
hands
of
decision
makers
so,
rather
than
you
need
to
needing
to
be
sort
of
an
intermediary
between
the
data
set
and
the
people
making
decisions
based
off
of
the
data
set.
You
can
allow
them
to
sort
of
explore
the
data
on
their
own.
B
This
is
especially
true
if
you're
creating
a
report,
that's
based
off
of
a
very
large
data
set,
and
these
interactive
data
tools
can
allow
users
to
create
their
own
visualizations,
rather
than
relying
solely
on
what
you've
decided
to
include
into
the
report
from
the
report
creation
side
of
things.
There
is
also
some
benefit,
so
creators
of
written
reports
can
save
time
by
using
data
tools
in
place
of
all
or
portions
of
a
written
document.
B
B
Interactive
data
tools.
Allow
you
to
easily
link
together,
multiple
years
of
a
report
so,
rather
than
having
you
know,
many
standalone
pro
stand-alone
reports
think
you
know
maybe
a
report
that
you
update
annually.
B
You
can
link
together
multiple
years
of
data
with
these
tools
and
give
the
users
more
more
information
and
the
ability
to
make
comparisons
over
time
and
then.
Lastly,
interactive
data
tools
provide
direct
access
to
the
data
and
through
the
visualizations,
so
users
with
these
tools
can
create
download
print
their
visualizations
and
download
the
underlying
data
that
they
use
to
create
them.
B
I
do
want
to
talk
briefly
about
some
of
the
software
packages
that
are
available
for
this
type
of
work.
Again.
This
is
a
high
level
overview,
we're
not
going
to
sort
of
get
into
the
how-to
of
how
to
use
these
software
packages,
but
the
primary
the
primary
tool
that
shawn
and
I
use
for
creating
interactive
data
tools
is
r
and
if
you're
not
familiar
r,
is
a
free,
open
source
software
pro
and
software
and
programming
language,
that's
primarily
used
for
data
analysis
and
statistical
computing.
B
B
I
just
want
to
mention
two
here
and
again:
sean
will
have
some
information
in
the
resource
slide
about
this,
but
tidy.
Verse
is
one
package
that
I
think
is
really
helpful
when
you
are
working
with
data
and
r,
and
you
know
manipulating
data
once
you
have
the
data
in
the
form
that
you
needed
in
to
make
the
the
visualizations
shiny
is
the
package
that
you
can
actually
use
to
create
the
data
tools
and
so
again,
we'll
have
some
resources
on
this.
But
those
are
two
packages
I
just
wanted
to
mention.
B
B
B
Typically,
this
report
comes
in
at
around
250
pages.
It's
a
lengthy
report.
Again,
it
is
something
we
update.
We
try
to
update
annually,
included
with
the
program
descriptions
and
the
recent
historical
data.
There
are
hundreds
of
maps
and
data
tables
data
tables
that
display
all
the
variables
that
are
in
the
report.
B
Here's
just
a
sample
of
what
the
old
version
of
the
report
used
to
look
like
on
the
left
is
sort
of
a
typical
map
that
you
would
find
in
the
old
version
of
the
report
you
can
see.
Some
of
these
visualizations
were
starting
to
look
a
little
bit
dated
because
this
was
a
printed
document
and
it
was
very
lengthy.
B
This
shows
each
aid
in
tax,
that's
included
in
the
report
and
the
value
for
each
of
those
variables
for
a
particular
county,
and
then
it
compares
those
values
to
a
larger
geographical
region
that
that
county
is
a
part
of
and
the
statewide
totals
as
well.
So
you
can
see
there's
a
ton
of
information
on
that
table
on
the
right-hand
side
of
your
slide,
and
there
were
hundreds
of
these
tables
within
the
report
itself.
B
The
first
was
usability,
so
we
knew
that
the
typical
users
of
this
report
were
not
reading
the
document
cover
to
cover
what
was
more
common.
Is
that
a
user
you
know,
maybe
a
legislator
or
a
caucus
staffer.
I
was
more
interested
in
a
particular
region
like
a
county.
That's
a
part
of
the
legislators
district
and
the
distribution
of
certain
aids
or
taxes
within
that
read
within
that
region.
B
So
what
they
were
doing
is
you
know,
maybe
taking
this
150
or
sorry
250,
page
report
sifting
through
for
maybe
just
one
or
two
pages,
and
you
know
a
couple
of
numbers
on
on
one
or
two
pages
of
this
very
long
report.
B
Now
we
also
knew
that
the
users
of
the
report
were
accessing
the
report
either
on
their
computer
or
on
their
phone.
So
sort
of
gone
were
the
days
of
someone
stopping
by
our
office
and
picking
up
a
hard
copy
of
this
report.
Most
people
were
accessing
it
online
and
the
second
consideration
was
sort
of
the
work
that
goes
into
creating
the
report.
So
you
know
sean
and
I
put
a
lot
of
time
into
updating
this
each
year.
B
B
You
know
all
of
the
maps
and
all
the
tables
within
the
report
were
created
using
macros
in
excel,
and
while
the
macros
did
save
time,
what
they
would
do
is
save
off
each
individual
map
in
each
table
and
and
we
would
have
to
compile
those
into
one
document
at
the
end.
So
it
was
a
little
bit
clumsy
assembling
the
report
and
a
lot
of
time
went
into
that
step.
B
B
What
I
want
to
just
scroll
through
real
quick
is
an
old
version
of
the
report,
so
this
this
is
sort
of
the
middle
of
the
report,
and
you
can
see
you
know.
Much
of
this
report
is
sort
of
page
after
page
of
of
maps
and
different
data
table
data
tables
and
everything
we're
going
to
see
in
the
interactive
data
tool
replaces
all
of
these
tables
that
I'm
scrolling
through
here,
and
you
know
I
could
keep
going
for
another
130
pages,
and
it
would
look
much
the
same.
B
So
this
is
the
new
major
state,
aids
and
taxes
interactive
data
tool.
What
we've
created
here
is
a
sort
of
an
interface
that
has
a
display
pane
in
the
middle
of
the
page
and
then
right
above
that
main
display
pane
are
a
few
different
tabs
that
allow
users
to
create
different
data
visualizations.
B
So
the
first
tab
is
the
single
year
map
and
on
the
left
pane,
the
user
can
select
a
variable
from
a
drop
down
a
drop
down
menu.
Again.
This
includes
every
variable
that
we
had
included
in
the
old
version
of
the
report.
The
user
has
the
option
to
adjust
these
values.
For
inflation
and
display
them
on
a
per
capita
basis
or
on
the
actual
dollar
amount
in
this
case,
and
then
the
the
final
option
the
user
has
is
to
select
a
year
of
the
report
from
the
drop
down
menu.
B
The
map
will
generate
automatically,
as
does
the
legend
users
can
zoom
in
to
the
map
and
zoom
back
out.
They
can
also
hover
over
individual
counties
and
when
they
move
their
mouse
over
a
particular
county.
The
county
name
will
display
the
year
and
the
variable
will
display,
as
well
as
the
value
for
that
particular
variable
below
the
main
display
panel
is
an
option
for
the
user
to
download
the
map
that
they've
just
created
and
download
the
data
that
was
used
to
create
that
visualization.
B
Make
it
a
little
bit
clearer
when
it
prints
so
yeah.
That's
an
option
available
as
well.
We
have
one
other
map
that
users
can
create
from
this
interactive
tool
and
that's
the
changeover
time
map.
So
again,
they
would
just
come
up
to
the
tabs
above
the
main
display
pane
switch
over
to
the
changeover
time
map
and
then
again
select
their
variable
from
the
left
pane.
All
the
same
variables
are
available
again.
They
can
adjust
for
inflation,
display
the
numbers
per
capita
or
just
the
raw
dollar
amounts.
B
This
sort
of
tidy
little
tab
here
replaces
all
hundreds
of
those
tables
that
we
were
just
looking
at,
so
the
user
can
again
select
a
given
year
this
time,
there's
an
additional
option
to
pick
a
geography
type,
so
they
can
choose
what
types
of
geography
geographies
display
in
the
region
drop
down,
menu,
statewide,
metro
and
greater
minnesota
is
one
option
where
you
just
get
those
three
different:
three
different
geographies,
but
a
user
could
select
counties
for
example,
and
all
87
counties
will
then
display
in
the
drop
down
once
a
county
is
selected,
the
table
updates
automatically
and
it
displays
all
the
variables
that
are
in
the
report
for
the
given
county
and
then
has
the
statewide
totals
just
as
a
reference
comparison.
B
So
the
old
version
of
the
report
had
similar
maps
to
what
we've
looked
at
and
tables
similar
to
this.
But
what
we've
been
able
to
add
by
creating
this
interactive
data
tool
is
the
ability
for
the
users
to
create
bar
charts
as
well.
So
these
were
not
in
the
original
version
of
the
report,
but
users
now
have
sort
of
two
options
for
creating
bar
charts.
B
B
One
other
option
that
the
users
have
related
to
bar
charts
is
the
compare
variables
tab
and
this
allows
the
user
to
compare
multiple
variables
across
multiple
regions.
So,
rather
than
just
having
one
variable
to
select
up
here,
the
user
can
select
a
comparison
variable,
I'm
going
to
select
two
that
are
a
little
bit
closer
to
each
other
in
value.
So
one
doesn't
get
washed
out
here,
so
they
can
select
first,
two
variables
that
they
want
to
compare,
and
then
they
can
select
the
two
different
regions
that
they
want
to
compare
those
two
variables
across
again.
B
The
bar
charts
generate
automatically,
and
you
can
see
the
the
title
also
generates
automatically
and
produces
two
bar
charts,
one
that
contains
each
variable
for
the
first
county
selected
and
the
other
that
contains
each
variable
for
the
second
county
selected.
Again,
you
can
download
the
plot
can
download
the
data.
B
The
last
thing
that
we
decided
to
include
in
the
interactive
data
tool
was
a
background
tab,
and
this
is
just
a
place
where
we
can
give
a
little
bit
more
context
to
the
variables
that
are
in
the
data
tool.
So
if
someone
is
using
the
tool-
and
they
aren't
sure
what
is
included
in
the
total
aids
variable,
for
example,
the
background
tab
will
has
a
definition
for
each
variable
and
and
tells
the
user
all
of
what's
included
in
some
of
the
totals
the
variables
that
are
our
totals.
B
So
that's
a
look
at
the
major
state
aids
interactive
data
tool.
You
know
what
we
ended
up
deciding
to
do
with
with
the
new
format
of
this
250-page
report
is
to
still
keep
some
of
the
some
of
the
written
portions.
So
we
want
it.
B
We
thought
that
you
know
that
the
descriptions
of
all
of
the
variables
and
some
of
the
legislative
history
and
historical
context
for
some
of
these
aids
and
taxes
was
important
to
keep
around,
but
we
were
able
to
replace
about
two-thirds
of
the
document
with
the
interactive
data
tool.
B
Some
of
the
benefits
of
having
this
data
tool
instead
of
relying
on
the
old
version
of
the
report,
is
that
you
know
users
can
now
create
their
own
visualizations
for
the
regions
that
they're
interested
in
it's
a
lot
faster
and
easier
for
them
to
just
use
the
drop
down
to
select.
You
know,
maybe
the
county
that
they're
looking
for
the
aid
or
credit
that
they're
looking
for
rather
than
sifting
through
the
hundreds
of
pages
of
the
old
version
of
the
report,
the
visualizations
have
an
updated
look.
You
know
now
they're
available
in
color.
B
You
know
with
with
r
and
with
the
interactive
data
tool
if
we
do
ever
want
to
kind
of
refresh
the
look
to
some
of
these
visualizations.
It's
pretty
easy
to
do.
B
I
think
the
biggest
benefit
of
this
is
that,
without
changing
any
of
the
data
that
we
collected
for
producing
this
report,
we
now
offer
the
users
a
lot
more
information
than
they
had
before,
especially
with
the
the
ability
to
make
comparisons
over
time.
So
if
users
wanted
to
do
that
in
the
past,
they'd
have,
to
you
know,
get
out
old
copies
of
the
report
and
try
to
track
down
numbers,
and
you
know
maybe
write
them
down
or
put
them
to
a
spread
into
a
spreadsheet
on
their
own.
B
B
The
data
tool
is
mobile
friendly
again,
it's
a
lot
easier
than
using
a
printed
report
or
a
pdf,
and
users
can
print
their
own
visualizations
and
download
the
underlying
data
that
they
use
to
create
them,
and
then,
lastly,
on
the
report
creation
side
of
things
and
we
replaced
all
of
those
macros
that
were
in
excel
with
scripts
that
run
in
r.
B
I
will
say
that
there
there
was,
you
know
a
little
bit
more
up
front
work
to
to
write
the
code
to
produce
all
of
these
maps
and
tables,
but
once
the
code
was
in
place,
it's
a
lot
easier
to.
C
So
I'm
going
to
talk
about
a
couple
of
examples
that
are
smaller
and
maybe
less
visually
striking
than
what
jared
describes,
but
I
think
there
are
other
examples
of
how
using
web-based
and
interactive
tools
can
sort
of
add
additional
function,
and
you
know
enhance
the
reports
that
the
information
you
can
provide
to
legislators.
C
C
C
So
this
one
of
these
examples
is
someone
who's
65
years
or
older,
has
16
000
in
social
security
benefits
and
then
at
different
income
levels,
how
much
of
their
tax
their
social
security
income
is
subject
to
tax
and
then
how
much
they're
benefiting
from
our
existing
state
subtraction
for
social
security
income
on
the
web
page
web-based
version
of
this
report.
There's
a
separate
interactive
calculator
that
sort
of
displays
these
example
taxpayers
under
different
policy
approaches.
C
C
It's
it's
one
single
table
and
you
can
do
things
like
change
the
income
level
for
this
person
other
than
social
security.
You
can
change
how
much
they
have
in
social
security
income.
You
can
change
their
tax
filing
status,
so
this
is
a
single
person.
This
is
a
married
taxpayer,
finding
a
joint
return
and
sort
of
some
of
the
benefits
of
doing
it.
C
This
way,
I
think
that
those
of
you
that
work
with
legislators
regularly
know
that
oftentimes
everyone
has
sort
of
this
ideal
model,
constituent
in
their
mind
and
hopefully,
by
giving
them
a
little
bit
more
control
over
the
tool
and
they
can
sort
of
plug
in
that
person
and
see
what
the
sort
of
tax
situation
for
that
person
would
be
in
this
case,
or
you
know,
sort
of
see
how
a
particular
policy
affects
that
person.
C
The
other
thing
I
like
about
this
is
that
it's
it's
a
lot
denser
and
it's
just
fewer
numbers
than
you're
getting
with
this.
You
know
essentially
two
pages
of
text
in
this
table,
and
I
would
also
say
that
there's
actually
more
information
in
here,
so
you
can
see
that
we've
included
sort
of
three
columns.
What
would
happen
if
there's
not
a
state?
C
We
have
a
state
subtraction
for
social
security
income,
so
this
shows
how
their
attacks
would
change
if
that
was
eliminated
and
also
shows
how
much
their
tax
would
change
if
there's
a
100
exemption
for
all
social
security
income,
so
you
can
see,
there's
sort
of
more
information
displayed
in
a
smaller
area
and
once
again,
a
legislator
might
have
more
control
over
what
they
see
there.
C
The
next
example
I'm
going
to
talk
about
relates
to
the
property
tax
refund
program
in
minnesota.
I
again
have
a
short
publication
sort
of
explaining
how
this
program
is
calculated.
You
can
see
on
a
slide
here
that
there's
13
steps
in
the
property
tax
refund
calculation
in,
in
our
example,
publications,
screenshot
format,
it's
pretty
confusing
for
formula
for
people
and
legislators
often
have
questions
about
it.
C
There's
a
lot
of
different
policy
levers
built
into
it.
So,
during
the
last
legislative
session,
I
was
working
with
a
member
who's
kind
of
interested
in
potentially
changing
this
program
and
that
legislator,
I
said
the
publication
that
we
had
done
that
was
kind
of
a
traditional
text-based
report
with
this
table
built
into
it.
C
We
talked
through
a
couple
of
times
how
the
calculation
worked,
but
I
didn't
feel,
like
the
legislator,
had
a
sort
of
good
feel
for
what
the
different
policy
levels
available
were
and
what
potential
changes
they
could
make
so-
and
this
is
again
looks
pretty
rough
because
I
sort
of
did
this
quickly
during
session.
C
But
again,
I
sort
of
put
together
this
little
interactive
calculator
that
lets
you
put
in
different
income
levels
and
different
amounts
of
property
taxes
paid
number
of
dependents,
and
then
these
are
sort
of
the
three
policy
levers
that
you
have
a
lot
of
control
over
over.
So
this
is
the
threshold
of
property
taxes
paid
relative
to
income
over
which
you
get
a
refund
in
minnesota.
C
So
you
can
reduce
that
threshold,
which
means
that
you
have
to
have
a
lower
amount
of
property
taxes
relative
to
your
income
data
refund.
So
you
can
kind
of
see
right
here.
What
the
base
amount
would
be,
what
the
proposal
would
be
if
you
change
that
threshold,
how
much
the
change
in
the
refund
would
be
to
the
taxpayer.
C
C
If
you
want
to
decrease
those,
you
can
see
you
get
a
bigger
refund.
So
again,
this
is
a
pretty
small,
not
super
visually
striking,
in
the
same
way
that
the
major
state
aids
report
is.
But
I
think
it's
a
good
teaching
tool
and
it's
kind
of
a
different
way
of
thinking
about
explaining
a
program
to
a
legislator
when
they're
thinking
about
changing
it.
C
The
last
example
I'm
going
to
talk
about
today
relates
to
the
frontline
worker
commission,
so
some
background
on
this
program.
The
2021
legislature
in
minnesota
established
a
commission
to
design
a
250
million
dollar
program
to
distribute
bonus
payments
to
frontline
workers
in
the
state.
C
One
of
the
questions
that
was
left
to
the
commission
was
determining
which
workers
would
qualify
for
these
bonus
payments.
There's
kind
of
a
fixed
budget
established
in
the
commission
enacting
legislation,
so
the
amount
that
workers
might
get
through
this
program
sort
of
would
be
depend
on.
You
know
who's
in
how
many
workers
are
in
what
the
eligible
pool
is,
and
so
during
the
work
on
that
commission,
the
minnesota
department
of
employment
and
economic
development.
C
C
So
they've
got
a
very
comprehensive
list
here
of
different
makes
codes
and
sub
codes
all
the
way
down
to,
I
think
the
six
digit
mixed
code
level
and
so
right
now
it's
got
ambulatory
and
healthcare,
hospitals
and
nursing
residential
care
facilities
selected.
So
you
can
see
they
show
the
total
number
of
workers.
If
you
gave
a
payment
to
everyone,
how
much
you
know
might
be
given
out
and
then
it
talks
about.
C
It
shows
the
number
there's
an
estimate
built
in
about
how
many
workers
in
that
sector
could
tell
a
work
or
not
and
sort
of
assuming
that
the
commission
might
not
want
to
give
frontline
order
pay
to
those
individuals,
and
then
you
can
go
into
here.
Maybe
you
wanted
to
add
meatpackers.
That
was
a
conversation
during
the
commission,
and
so
you
check
the
box
there
for
that
sector
and
I'm
not
sure
if
that's
actually
meat
packers,
it's
even
meat
project
merchant
wholesalers,
but
you
can
see
that
it
automatically
updates.
C
It
reduces
the
the
average
payment
across
the
total
program.
If
you
want
to
use,
maybe
everyone
in
education,
that's
a
big
sector,
and
so
you
can
see
again,
the
total
average
payment
dropped
from
770
to
542..
C
So
again,
this
is
a
tool
where
legislators
can
sort
of
play
around
with
sort
of
the
programmers
that
are
in
front
of
them
choose
kind
of
who
they
think
their
target
would
be,
and
it's
a
really
kind
of
dynamic
and
interactive
way
for
someone
that
doesn't
have
a
lot
of
technical
or
data
experience
to
sort
of
kind
of
come
up
with
scenarios
do
so
without
having
to
use
excel
or
other
statistical.
Software.
C
C
C
You
know,
sort
of
giving
more
access
to
these
kinds
of
charts
might
increase
the
risk
that
they're
used
by
advocacy
groups
or
partisan
campaigns
so
that
that
major
state
age
tool
that
jared
and
I
created
there-
was
a
report
commissioned
by
the
minneapolis
regional
chamber
of
commerce,
it's
kind
of
about
the
balance
of
payments
within
the
state
of
minnesota
and
they
hired
a
consultant
to
create
this
report
and
the
consultant,
you
know,
spit
out
our
reports
from
our
interactive
tool
and
put
them
right
in
there.
C
And,
lastly,
I
think
that
you
know
you
have
a
lot
of
control
and
capacity
to
build
in
context
when
you're
writing
a
written
report.
You
can
kind
of
give
caveats.
You
can
talk
about
how
data
sources
have
changed.
You
can
talk
a
lot
about
methodologies,
limitations
of
the
data
and
those
sorts
of
things
and,
where
possible,
on
our
tools,
we
kind
of
built
that
in
some
of
them
that's
more
important
than
others,
but
you
might
have
a
less
of
an
ability
to
do
that
in
the
context
of
interactive
tools.
C
Lastly,
I
wanted
to
just
talk
briefly
about
a
few
resources
for
people
using
r,
because
that's
the
software
package
that
jared
and
I
are
more
familiar
with
using
you-
can
download
the
r
itself,
which
is
kind
of
the
statistical
programming
language.
Our
studio
is
a
development
environment
for
sort
of
working
in
r
and
almost
everyone.
I
know
that
uses
r
likes
to
work
in
our
studio.
It's
very
user
friendly.
It's
also
free,
as
jared
mentioned,
there's
kind
of
a
pat
group
of
packages
called
the
tidyburst,
which
are
very
helpful
for
manipulating
data.
C
C
There
there's
a
text
there's
a
printed
version,
but
there's
also
a
free
online
version
and
that
you
know
it
doesn't
presume
necessarily
much
knowledge
of
r
itself,
but
it
does
presume
just
a
little
bit
of
familiarity
working
with
data
tools
and
programming,
but
you
can
really
pick
up
chapter
one
of
that
book
and
sort
of
work
through
making
graphs,
manipulating
data.
Those
sorts
of
things
there's
exercises
at
the
end
and
I
think
that's
a
really
good
place
to
start.
C
There's
a
number
of
online
courses
available.
There's
some
on
the
mooc
platforms.
Datacamp
is
another
online
service.
It
has
some
free
tools
and
also
pay
courses
that
you
can
use
to
learn
about.
R
and
programming
are
anyone.
That's
done.
Programming
stuff
is
familiar
with
stack
overflow
and
if
you
get
funny
error
messages
or
things
you're
not
familiar
with
it's
great
to
type
those
into
google,
and
hopefully
someone
on
stack
overflows,
have
the
same
problem
and
then,
lastly,
our
studio
has
these
cheat
sheets
on
their
website.
C
The
short
reviews
show
commonly
used,
commands
and
programming
tools
that
I
think
are
really
helpful
for
working
in
r
and
I
sort
of
keep
those
at
hand
and
look
at
them
frequently
when
I'm
trying
to
do
something.
I'm
not
super
comfortable
with
and
that's
the
end
of
our
presentation.
So
maybe
I'll
turn
it
back
to
angela
and
see
if
anyone
has
any
questions
or
we're
happy
to
stamp.
A
Typical,
well
thanks,
so
much
sean
and
jared
for
sharing
this
information
and
how
you've
taken
some
of
your
reports
in
term
put
them
online
and
redesigning
them
for
online
viewing.
We
do
have
a
few
questions
and
the
first
question
is
about
accessibility,
and
it
is
a
question
of
to
what
extent
are
you
able
to
meet
accessibility
standards
through
your
online
display
of
data
and
information.
B
Maybe
I'll
I'll
just
mention
a
couple
things
and
and
sean
if
you
have
anything
else
to
add,
feel
free.
I
guess
one
one
accessibility
consideration
is,
you
know
it's
always
with
the
the
colorblind
palettes
and
making
sure
you're
using
colors
that
are
accessible
to
folks
who
who
are
colorblind
the
the
major
status
and
taxes
maps
that
we
were
looking
at,
do
use
a
colorblind,
safe
palette
and
r.
B
Has
you
know
a
number
of
different
color
blind,
safe
palettes
that
you
can
choose
from
shiny
I
mentioned
is:
is
the
package
with
an
r
that
you
actually
use
to
create
the
interactive
tools?
And
you
know
I
know
it.
It
has
the
ability
to
add
alt
text,
so
you
can
add
alt
text
to
you
know
some
of
these
web
applications.
B
I
believe
that
screen
readers
should
be
fine,
reading
the
drop
down
menus
as
well,
but
that's
something
I
guess
I
would
have
to
look
into
just
to
make
sure,
but
I
I
think
that
would
be.
I
don't
think
that
would
be
an
issue,
but
it
is
something
that
you
know
it's
not
automatic
and
so
that
the
colors
that
you're
choosing
or
adding
the
alt
text-
and
you
know
it's
stuff-
that
you
actually
have
to
write
into
the
code
that
you're
you're
working
with
with
shiny
but
the
I
guess
the
functionality
is
there.
A
Okay,
well,
another
question
that
came
up
and
this
is,
I
think,
on
the
hills
of
I'm
sean.
You
sharing
the
final
slide
around
our
resources,
but
the
question
is:
do
you
share
our
code
publicly
or
privately
with
any
other
research
departments.
C
So
I'm
happy
to
answer
that
one
so
far
we
have
not,
but
I
think
we'd
be
happy
to
too,
and
we
could
certainly
put
some
of
these
tools
and
do
github
archives
and
those
sorts
of
things
so
we'd
be
happy
to
share
it.
Yeah.
A
Sounds
good?
The
other
question
is
about
utilizing
another
platform
and
it
is
about
utilizing
microsoft.
Bi.
To
create
interactive
visuals
for
legislators.
Is
that
a
platform
you
two
have
used
and
if
so
has
there
been
successes
or
challenges.
B
I
have
not
used
that
you
know
this
is
sort
of
the
you
know
getting
into
using
interactive
data
tools.
Is
it's
just
something
that
that
we've
pretty
recently
started
doing,
and
you
know
the
tools
that
we've
used
are
basically
what
we've
presented
here.
I
I
haven't
used
that
in
the
past
either
I
don't
know
if
I
don't
think
sean
has,
but
no
yeah
either.
One
of
us
would
use
that
yet.
A
Okay,
thank
you.
So
I'm
gonna
ask
two
two
other
questions
that
have
come
in
and
it's
really
about
how
legislators
have
used
this.
This
data
that
you've
presented
online
and
the
first
is
what
reaction.
If
any,
have
you
heard
from
legislators
about
changes?
A
C
I
can
maybe
take
that
one.
This
is
here
to
mention
the
major
state,
aids
and
taxes
report
we've
been
putting
out
for
longer
than
I
have
been
alive.
So
members
that
have
been
here
for
a
long
time
are
familiar
with
it,
and
you
know
many
of
them
really
liked
getting
the
old
version.
C
This
paper-bound
set
of
tables
and
numbers
they,
you
know,
love
to
look
up
their
county
that
way,
and
so
it's
a
pretty
labor-intensive
product,
and
we
were
we
just
outreached
just
to
see
you
know-
is
this
worth
putting
a
lot
of
step
resources
into
producing
every
year,
and
we
generally
got
the
sense
that
members
like
this
report
and
they
like
wanted
our
office
to
keep
working
on
it,
but
we're
open
to
changes
and
to
the
extent
that
we've
shared
them
with
members.
C
I
think
we've
gotten
a
pretty
positive
feedback
on
the
tool
and
same
thing
from
staff
we've
worked
with
nonpartisan
and
partisan
staff.
I
think
people
think
it's
pretty
helpful
to
be
able
to
sort
of
play
with
those
numbers
directly
and
particularly
for
you
know,
partisan
research
staff.
It
might
be
get
questions
you
know.
C
I
think
everyone's
familiar
with
just
sometimes
a
question
could
be
answered
by
our
office
or
could
be
answered
by
a
partisan
office
as
well,
and
you
know
it's
nice
to
be
able
to
get
that
public
information
out
there,
so
other
people
could
respond
to
requests
without
having
to
funnel
them
through
us.
So
I
think
that
they
appreciate
that.
A
Thank
you.
This
is
another
question
around
usability
by
legislators
and
just
in
kind
of
the
approaches
to
data
data
visualization.
So
I'm
going
to
actually
read
the
question
word
for
word:
have
you
found
different
approaches
to
data
visually?
This
visualization.
Excuse
me
for
legislators
versus
analysts.
B
I
I'll
start
sean,
obviously
feel
free
to
add.
You
know,
I
think
it
it's
just
going
to
be.
You
know
dependent
on
the
person.
Obviously
you
know
if
we're
talking
about
analysts
versus
members,
you
know
people
who
who
tend
to
work
with
data
more
and
are
maybe
more
comfortable
with
it
are
likely
more
comfortable
with
using
maybe
tools
that
are
a
little
bit
more
complex,
but
I
you
know,
I
they'll
use
the
property
tax
refund
tool
that
sean
went
through.
B
You
know
that
was
designed
specifically
for
a
member
that
you
know.
I
think,
if
you
ask
this
person,
do
they
consider
themselves.
You
know
a
you
know:
high
high
level
of
computer
literacy
or
data
literacy.
You
know,
are
they?
Are
they
really
familiar
with?
You
know,
working
in
with
data
analysis,
they
would
probably
say
no,
but
they
were
able
to
to
use
a
tool
like
that,
and
I
you
know
I
think
it
went
really
well.
B
I
I
would
imagine
that
sean
you
know
spent
some
time
showing
how
to
use
it
and
that's
probably
helpful,
but
of
the
examples
that
we've
gone
through
today.
I,
I
don't
think
that
you
know.
I
don't
think
that
the
sort
of
complexity
surpasses
members
ability,
at
least
as
far
as
we've
as
we've
experienced
so
far.
You
know
these
tools
are
meant
to
make
it.
You
know
kind
of
easier
to
explore
these
data
sets.
So
things
like
drop
down
tools.
B
You
know
radio
buttons
that
you
click
to
turn
things
on
and
off.
You
know
I
I
think
that
that's
been
something
that
the
people
we've
worked
with
so
far
have
been
able
to
handle.
C
And
I
I
might
just
add,
I
think
this
is
similar
to
what
jared
said,
but
a
different
way
of
looking
at
it
is,
I
sort
of
view,
there's
just
a
lot
of
legislators
that
have
different
kind
of
levels
of
interest
in
a
particular
policy
area,
but
also
different
learning
styles.
I
think
one
thing
I
like
about
this
is
you
can
sort
of,
if
someone's
a
very
visual
learner,
then
maybe
building
a
graph
or
a
map,
or
something
like
that
might
be
a
good
way
to
explain
information
to
them.
C
If
someone's
really,
you
know,
I'm
thinking
of
a
particular
member
that
really
likes
to
do
those
calculations
step
by
step
and
wants
to
see
them
all
laid
out
in
front
of
them,
and
so
you
know,
there's
tools
that
sort
of
show
the
step-by-step
calculation
and
how
it
might
change.
C
So
I
think
that
you
know
it
as
always
with
communicating,
I
think,
just
knowing
what
your
audience
needs,
how
that
person,
or
those
people
tend
to
learn
and
having
different
strategies
for
communicating
with
people
depending
on
what
their
learning
style
is
is,
is
a
good
approach.
A
Thanks,
another
question
that
we
have
is
are
all
of
your
visualizations,
available
to
the
public
and
replacing
your
publications.
C
So
I
can
maybe
step
we.
We
certainly
haven't
replaced
all
of
our
publications
with
interactive
data
tools.
Some
obviously
don't
lend
themselves
super
well
to
that,
and
but
the
the
one
that
jared
showed
the
major
state
aids
tool
is
available
to
the
public.
I've
made
that
property
tax
refund
one
that
I
just
demonstrated.
I
made
that
sort
of
working
with
a
particular
legislator
to
sort
of
help
explain
that
policy
area
to
that
legislator,
but
I
will
say
I
thought
it
was
a
useful
tool
and
the
legislators
thought
so
as
well.
C
So
I
think
that
you
know
one
of
the
things
I'm
going
to
work
on.
This
interim
is
potentially
putting
that
up
on
our
website
as
a
publication,
that's
available
to
the
public,
because
I
don't
see
any
reason
not
to
there's
no
real
non-public
information
in
there,
and
so
we
try
to
make.
I
think
that
you
know
we
generally
put
all
of
our
publications
on
our
website,
but
we,
you
know,
as
as
always,
do
some
work
confidentially
with
with
members
of
the
legislature
as
well.
A
Thanks
and
one
other
question
is
about
archiving:
how
do
you
archive
this
material?
Are
these
not
considered
public
documents
records
and
are
they
subject
to
a
retention
schedule?
So
I
think
that's
a
question
jared.
If
you
want
to
speak
to
that
or.
B
Yeah
sure
you
know
I
I
guess
with
that
question,
I'm
I'm
going
to
make
the
assumption
that
maybe
they're
referring
to
the
major
state
aids
tool.
You
know
it
there's
nothing
that
has
the
the
data
that's
up
there
right
now
is
the
most
current
data
as
well,
as
you
know,
going
back,
maybe
15
years
or
so
so
we
haven't.
You
know
there
are
old
versions
of
the
report
that
are,
I
believe,
are
still
archived
on
our
website.
I'd
have
to
check,
but
you
know
these.
B
The
data
tools
haven't
been
around
long
enough.
I
guess
to
to
run
into
that
issue.
You
know.
I
think
that
our
office
will
have
a
policy
likely
on
on
that
in
the
future,
but
I
guess
it's
not
something
that
we've
run
into
yet
where
we
need
to.
You
know,
follow
any
certain
retention
policies
or
archiving
policies
with
with
these
data
tools,
but
you
know
likely.
That
is
something
that
we'll
come
across
in
the
future.
A
Thank
you
and
one
other
question:
I'm
seeing
in
the
chat
function
is
a
request
to
show
the
property
tax
tool
again,
so
I'm
wondering
we
still
have
a
screen
up
you
can.
You
might
want
to
share
that
one
more
time
thank
sean
and
maybe
run
through
it
again
and
show
folks.
A
While
we're
waiting
for
it
to
reload,
I
want
to
thank
everybody
for
their
questions
today
and
just
a
reminder
that
this,
our
webinar,
is
being
archived
and
will
be
posted
on
ncsl's
webpage
within
this
week,
as
long
as
well
as
the
slide
deck
that
jared
and
sean
presented
as
well.
So
just
want
to
make
sure
everybody
knows
that.
So
here
we
are,
it's
loaded
again
go
ahead.
Sean.
C
Yeah,
so
this
is,
I
explained
it's
a
little
bit,
but
this
is
related
to
the
property
tax
refund
program
in
minnesota
and
so
sort
of
what
you
have
here
is
different
example:
taxpayers
with
different
levels
of
income,
property
taxes,
paid
numbers
of
dependents
and
then
there's
a
feature
of
the
program
that
gives
larger
refunds
to
individuals
with
disabilities
or
who
are
65
or
older.
C
So
if
you
reduce
the
statutory
copays,
you
can
sort
of
see
up
here
how
the
proposal
would
the
refund
for
that
individual
with
this
level
of
income
would
change,
and
if
you
were
to
maybe
change
that
person's
income,
they
get
a
little
bit
higher
income
person.
C
You
could
see
how
the
refund
would
change
as
well,
maybe
if
they
paid
a
lot
more
in
property
taxes
oops
at
that
point
they.
I
know
why
that
didn't
change
under
this
change
so
in
any
case
that's
sort
of
how
the
tool
works.
It's
it's
not
super
complicated
or
visually
striking,
but
I
think
it
was
useful
for
as
a
teaching
tool.
A
All
right
well,
thank
you
so
much,
I
don't
see
any
other
questions
either
in
the
q
a
section
of
this
platform
or
in
the
chat.
So
I
want
to
take
this
moment
to
thank
both
of
you
for
sharing
this
information
and
how
you've
redesigned
some
of
your
publications
and
put
them
online
in
a
user-friendly
way
for
legislators.
A
So
thank
you
for
that
again.
As
I
had
mentioned,
this
webinar
is
being
recorded
and
will
be
posted
on
csl's
webpage
as
well
as
we
will
share
this
slide
deck
on
the
web
page
as
well.
So
with
that,
I
want
to
thank
everybody
for
your
time
today.
Thank
you
for
joining
this
webinar
and
a
big
thank
you
to
jared
and
sean
for
sharing
your
information
take
care
everyone.
Thank
you.