Partnering with Posit for progress on Environmental Stewardship
summary
Cummins centralizes telematics and onboard diagnostics via ETL, Databricks and PySpark into a SQL warehouse, then serves a R Shiny app on Posit Connect used by 600+ engineers to surface engines with low IUMPR ratios. Duty cycles are inferred with k-means clustering on five engine features (idle%, torque%, motoring%, key cycles/hour, drive avg%), Quarto auto-generates monthly and quarterly reports for 60+ engine families as PDFs and interactive HTML, and monthly ETL refreshes keep Connect data current.
AI-written summary · about
chapters (10)
- 0:00Environmental stewardship intro
- 2:10Project needs and data sources
- 3:53Telematics data extraction
- 5:24Centralizing data in SQL
- 6:32R Shiny app for emissions
- 8:25k-means clustering for duty cycles
- 10:58Quarto automation for reports
- 13:06Pipeline monitoring and maintenance
- 14:36Key reflections and future steps
- 16:26Q&A
related talks
51mFrom Data Confusion to Data Intelligence
26mDriving towards a cleaner future through data
45mOur way to a data-driven enterprise - A Journey by Bosch
20mSucceed in the Life Sciences with R/Python and the Cloud
18mT1A Business Optimization Use Cases
50mBeyond Interactive: Empowering Everyone with Jupyter Notebooks
17mBuilding a data science pipeline for the FT with RStudio Connect
58mPanel: Data & AI-Driven ESG Reporting