In the morning we received dashboard requirements from Andy:
The Permitting Dashboard is an online tool for Federal agencies, project developers, and interested members of the public to track the Federal government’s environmental review and authorization processes for large or complex infrastructure projects, part of a government-wide effort to improve coordination, transparency, and accountability.
My steps this day:
- Dive in data set, field definitions
- Defining hierarchy of project/action/milestones
- Questions:
- Who is a audience ? - Federal agencies, project developers and members of public
- What is your data story? - Data shows us project status and actions(milestones) within the project and responsible agency/bureau. Provide information about the work of Federal agencies openly and publicly. Shows agencies performance. Shows information in different level of details
- What question does it answer ? - What is the status of project? How long it take to finish project ? How many action/milestones in project completed? Are projects on target deadlines ?
- What actionable insights are you looking to obtain? - Project that run the lowest of the rest (what factors it depends: sector, agency, etc.). Planning side (Target Time - Actual Time). How many projects completed and in what time. Is there anything that needs special attention.
4. When I answered this questions it lead me to idea what my dashboard will show and how should look like:
- It will show sector/agency/project performance along with specific project information but we need different level of detail because of wide audience and it will be online.
5. Sketch
6. A bit of data prep: extra spaces removing, etc.
7. Building of dashboard.