References

Data Sources

NYC 311 Service Requests
NYC Open Data. 311 Service Requests from 2010 to Present.
URL: https://data.cityofnewyork.us/Social-Services/NYC-311-Data/jrb2-thup/about_data
Curator: NYC Department of Information Technology and Telecommunications (DoITT)
Accessed: (Spring/2026)

DOT Automated Traffic Volume Counts
NYC Open Data. Automated Traffic Volume Counts.
URL: https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-waep
Curator: NYC Department of Transportation (DOT)
Accessed: (Spring/2026)

Tools & Software

Google BigQuery
Google LLC. BigQuery: Cloud Data Warehouse.
URL: https://cloud.google.com/bigquery

dbt (data build tool)
dbt Labs. dbt Core: open-source data transformation tool.
URL: https://www.getdbt.com
Version: (add version used)

Looker Studio (formerly Google Data Studio)
Google LLC. Looker Studio: free data visualization and BI tool.
URL: https://lookerstudio.google.com

Socrata Open Data API
Tyler Technologies. Socrata API documentation.
URL: https://dev.socrata.com

dbdiagram.io
Holistics Software. dbdiagram.io: Database Relationship Diagram Tool.
URL: https://dbdiagram.io

Quarto
Posit, PBC. Quarto: An Open-Source Scientific and Technical Publishing System.
URL: https://quarto.org
Version: (add version used)

R / RStudio
R Core Team. R: A Language and Environment for Statistical Computing.
URL: https://www.r-project.org
Posit, PBC. RStudio Desktop.
URL: https://posit.co/products/open-source/rstudio/

Google Cloud Functions
Google LLC. Cloud Functions: Serverless compute platform.
URL: https://cloud.google.com/functions

Project Repository & Warehouse Links

GitHub Repository
URL: https://github.com/RaulSolaNavarro/nyc-analytics-project-rjsn

BigQuery Project
Project: raul-cis-9440-spring2026
Datasets: group_3_raw, group_3_staging, group_3_marts
Access shared with: jaclyn.cohen@baruch.cuny.edu

Looker Studio Dashboard
URL: (https://datastudio.google.com/reporting/b7835c43-9acb-4aa1-9cd6-e9230b5421d8)
Access shared with: jaclyn.cohen@baruch.cuny.edu

Course Reference

Cohen, J. CIS 9440: Data Warehousing and Analytics.
Baruch College, Zicklin School of Business. Spring 2026.

AI Tool Usage Disclosure

Portions of this project’s technical implementation and documentation were developed with assistance from Claude (Anthropic), an AI assistant. Specifically, AI assistance was used for:

Project report structure & documentation: Scaffolding the Quarto website layout, section organization, and markdown formatting across all .qmd files
SQL queries: Initial drafts and structural patterns for several BigQuery analytical queries (Queries 1–9); all queries were reviewed, tested, and validated against actual data by the team
Validation pass and revisions: Reconciliation checks of query outputs against source counts, which led to two SQL corrections (de-duplicating dim_incident_location in Query 6, and computing traffic at the segment-day grain in Queries 4, 5, 7 and 9), and to AI-assisted revision of the written findings and conclusions to match the corrected results
dbt model structure: Guidance on staging and mart layer organization, macro usage, and DAG structure
BigQuery / GCP configuration: Assistance with dataset organization, table creation syntax, and Cloud Function architecture patterns
Looker Studio: Guidance on chart configuration, cross-source joins, and dashboard layout decisions
GitHub / version control: Assistance with repository structure, .gitignore configuration, and Quarto-to-GitHub Pages publishing setup

The following work was completed entirely by the team without AI assistance:

The original written analysis and narrative conclusions (drafted before the validation pass described above)
Dimensional model design and all dbdiagram.io ERD work
Data source selection, exploration, and project proposal
All stakeholder framing and KPI definitions

AI-generated content was reviewed and validated by all group members prior to submission. Use of AI tools is disclosed in accordance with course academic honesty policies.

--- title: "References" --- ## Data Sources **NYC 311 Service Requests** NYC Open Data. *311 Service Requests from 2010 to Present.* URL: <https://data.cityofnewyork.us/Social-Services/NYC-311-Data/jrb2-thup/about_data> Curator: NYC Department of Information Technology and Telecommunications (DoITT) Accessed: *(Spring/2026)* **DOT Automated Traffic Volume Counts** NYC Open Data. *Automated Traffic Volume Counts.* URL: <https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-waep> Curator: NYC Department of Transportation (DOT) Accessed: *(Spring/2026)* --- ## Tools & Software **Google BigQuery** Google LLC. *BigQuery: Cloud Data Warehouse.* URL: <https://cloud.google.com/bigquery> **dbt (data build tool)** dbt Labs. *dbt Core: open-source data transformation tool.* URL: <https://www.getdbt.com> Version: *(add version used)* **Looker Studio (formerly Google Data Studio)** Google LLC. *Looker Studio: free data visualization and BI tool.* URL: <https://lookerstudio.google.com> **Socrata Open Data API** Tyler Technologies. *Socrata API documentation.* URL: <https://dev.socrata.com> **dbdiagram.io** Holistics Software. *dbdiagram.io: Database Relationship Diagram Tool.* URL: <https://dbdiagram.io> **Quarto** Posit, PBC. *Quarto: An Open-Source Scientific and Technical Publishing System.* URL: <https://quarto.org> Version: *(add version used)* **R / RStudio** R Core Team. *R: A Language and Environment for Statistical Computing.* URL: <https://www.r-project.org> Posit, PBC. *RStudio Desktop.* URL: <https://posit.co/products/open-source/rstudio/> **Google Cloud Functions** Google LLC. *Cloud Functions: Serverless compute platform.* URL: <https://cloud.google.com/functions> --- ## Project Repository & Warehouse Links **GitHub Repository** URL: <https://github.com/RaulSolaNavarro/nyc-analytics-project-rjsn> **BigQuery Project** Project: `raul-cis-9440-spring2026` Datasets: `group_3_raw`, `group_3_staging`, `group_3_marts` Access shared with: `jaclyn.cohen@baruch.cuny.edu` **Looker Studio Dashboard** URL: *(https://datastudio.google.com/reporting/b7835c43-9acb-4aa1-9cd6-e9230b5421d8)* Access shared with: `jaclyn.cohen@baruch.cuny.edu` --- ## Course Reference Cohen, J. *CIS 9440: Data Warehousing and Analytics.* Baruch College, Zicklin School of Business. Spring 2026. --- ::: {.callout-note collapse="true"} #### AI Tool Usage Disclosure Portions of this project's technical implementation and documentation were developed with assistance from Claude (Anthropic), an AI assistant. Specifically, AI assistance was used for: - **Project report structure & documentation**: Scaffolding the Quarto website layout, section organization, and markdown formatting across all `.qmd` files - **SQL queries**: Initial drafts and structural patterns for several BigQuery analytical queries (Queries 1–9); all queries were reviewed, tested, and validated against actual data by the team - **Validation pass and revisions**: Reconciliation checks of query outputs against source counts, which led to two SQL corrections (de-duplicating `dim_incident_location` in Query 6, and computing traffic at the segment-day grain in Queries 4, 5, 7 and 9), and to AI-assisted revision of the written findings and conclusions to match the corrected results - **dbt model structure**: Guidance on staging and mart layer organization, macro usage, and DAG structure - **BigQuery / GCP configuration**: Assistance with dataset organization, table creation syntax, and Cloud Function architecture patterns - **Looker Studio**: Guidance on chart configuration, cross-source joins, and dashboard layout decisions - **GitHub / version control**: Assistance with repository structure, `.gitignore` configuration, and Quarto-to-GitHub Pages publishing setup The following work was completed entirely by the team without AI assistance: - The original written analysis and narrative conclusions (drafted before the validation pass described above) - Dimensional model design and all dbdiagram.io ERD work - Data source selection, exploration, and project proposal - All stakeholder framing and KPI definitions *AI-generated content was reviewed and validated by all group members prior to submission. Use of AI tools is disclosed in accordance with course academic honesty policies.* :::