Create Template for a District Quarterly Issues Report

Closed
Yonge North York BIA
Toronto, Ontario, Canada
WB
Executive Director
(12)
4
Preferred learners
  • Anywhere
  • Academic experience
Categories
Data visualization Data analysis Databases Data science
Skills
data visualization tableau (business intelligence software) templates geographic information systems data import/export
Project scope
What is the main goal for this project?

Our organization utilizes software for tracking and reporting of issues within our district. Our street team uses the software to report a range of issues such as broken bins, postering on poles, sidewalk damage and more, and then track their resolution. This data needs to be extracted and organized in a visual manner in a report, which can be shared with Staff, Board of Directors, our Municipality and relevant departments. The project will involve developing template and training materials, as well as generating initial reports.

What tasks will learners need to complete to achieve the project goal?
  • Further refine the list of data sets to include and make recommendations as to how to clearly present the information in a visual manner, and incorporate Staff feedback.
  • Develop a detailed user-friendly process for creating quarterly reports with subsections for departments from data exports from our GEOPal (TotalMobile) account, a GIS based software as well as potentially from supplier reports.
  • Create multi-excel file templates to import into GEOPal if required to achieve the objective for generating custom report exports from the system.
  • Provide a template in Tableau or a similar data visualization software within budget (to be determined in conjunction with the organization) for Board reports.
  • Generate a report final sample for an annual 2022 report, and 2023 quarterly reports to date.
  • Create a training materials for BIA Staff, which should include one recorded seminar and/or succinct manual, with an opportunity for Q&A.

About the company

The Yonge North York Business Improvement Area (BIA) was recently established and is one of over 80 BIAs in Toronto. Our organization is overseen by a voluntary Board of Directors from our business community. Representing over 1600 business and commercial property members, with over 30,000 employees and 51,000 residents within our district, we are one of the largest BIA’s in Toronto. Located along the Yonge corridor between Hwy 401 and just North of Finch Avenue, our urban district is experiencing significant development. The Yonge North York BIA’s vision is to be the preferred destination in North Toronto for businesses, residents, visitors and workers to live, work and play: By promoting the area as an accessible, safe, urban, vibrant and alternative destination to downtown Toronto and the suburbs; By creating economic growth and opportunity for members; and By improving the quality of life through business attraction, capacity building, events, marketing, public realm, retention and revitalization.