creating dashboards for grants management october 24, 2017 … · 2017-11-07 · creating...
TRANSCRIPT
![Page 1: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/1.jpg)
Creating Dashboards For Grants Management
October 24, 2017Michael Lesiecki
co-PI NACK Support Center
ATE PI Conference
![Page 2: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/2.jpg)
Major Changes in Federal Grants Management 2017
1. Focus on Outcomes2. Performance Metrics3. Risk Assessments4. Financial Management Policies5. Equipment Use6. Micro purchases7. Corrective Action8. Family Friendly Policies9. False Claim Certifications10. Audit Thresholds
Source: Brustein & Manasevit, www.bruman.com
2
![Page 3: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/3.jpg)
Your Knowledge and Skill
• Is increasingly called upon in the grant management area
• You can help set up a viable process for projects to begin tracking their success
3
![Page 4: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/4.jpg)
Dashboard Elements
Dashboard (Sample)Data and Trends
Metrics and Measures
Key Performance Indicators (KPIs)
4
![Page 5: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/5.jpg)
Dashboard Elements
Dashboard (Sample)Data and Trends
Metrics and Measures
Key Performance Indicators (KPIs)
5
![Page 6: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/6.jpg)
Dashboard – Data and Trends
Dashboard (Sample)Data and Trends
Awards by CollegeOccupational Programs
5-year Program Trend5-year Award Trend
Metrics and Measures
6
![Page 7: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/7.jpg)
For Your Project Management Team?
What are the most important trends and data that you track?
7
![Page 8: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/8.jpg)
Elements: Distinguishing
Dashboard (Sample)Data and Trends
Metrics and Measures
Key Performance Indicators (KPIs)
8
![Page 9: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/9.jpg)
Poll #1
Choose the Best KPI
A. Number of workshop attendees
B. Number of workshop attendees implementing model curriculum
9
![Page 10: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/10.jpg)
Poll #2
Choose the Best KPI
A. Program Enrollments
B. Fraction of Underserved Populations Enrolling in Programs
10
![Page 11: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/11.jpg)
Audience?
Do you have Key Performance Indicators?
11
![Page 12: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/12.jpg)
KPIs Distinguished by Direct Link to Big Goals
12
![Page 13: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/13.jpg)
Example KPI for Professional Development
Fraction of participants who made a significant change in their course or curricula after attending
13
![Page 14: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/14.jpg)
Could we move this to the web?
14
![Page 15: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/15.jpg)
Yes
Microsoft Power BI
Tableau also an option
Business Intelligence is cloud service that provides non-technical business users with tools for aggregating, analyzing, visualizing and sharing data
15
![Page 16: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/16.jpg)
16
![Page 17: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/17.jpg)
In the Cloud
• Establish your data in Excel (or CSV)• Determine the relationships you wish to
display• Select the visualization
17
![Page 18: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/18.jpg)
18
![Page 19: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/19.jpg)
Example: Remote Access of Instrumentation for
Nanotechnology
https://app.powerbi.com/view?r=eyJrIjoiZTdlMmQ5MWItMzBjYy00MTU4LWIxODctY2EwNGU4YmIwOGI5IiwidCI6IjhhNWI2ZmQyLWY1MGQtNDU2NS05MTBhLTFmZmU2NDU0ZTM2OCIsImMiOjZ9
19
![Page 20: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/20.jpg)
Microsoft Power PI
powerbi.microsoft.com
20
![Page 21: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/21.jpg)
Difficulties: The Dark Side of Dashboards
• Using the Right data, avoiding the Wrong data
• Too much extraneous information• If you can not really use a dashboard item
then drop it• Keeping it evergreen
21
![Page 22: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/22.jpg)
Make the Title of the Graph Tell the Story
22
![Page 23: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/23.jpg)
23
![Page 24: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/24.jpg)
Practical Hints
• Encourage ownership by including the “Dashboard” as an agenda item in a staff meeting
• Then call for updates• Be able to link to the Big Goals and
Objectives
24
![Page 25: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/25.jpg)
Summary: You Can Now• Describe the elements of a dashboard• Distinguish informational elements from
trends and Key Performance indicators (KPIs)
• Create ownership to make the dashboard a dynamic reporting tool
• Develop your own dashboard• Think about the possibility of moving it to
the web25
![Page 26: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/26.jpg)
Own Your Dashboard!
,
26
![Page 27: Creating Dashboards For Grants Management October 24, 2017 … · 2017-11-07 · Creating Dashboards For Grants Management October 24, 2017 Michael Lesiecki co-PI NACK Support Center](https://reader033.vdocuments.us/reader033/viewer/2022043017/5f39c7ef21ac1114a433e5f5/html5/thumbnails/27.jpg)
• Ownership• Renew/Update process
Make Your Dashboard Real and Evergreen
27