JCS Analytics
JCS Analytics
  • Home
  • About
  • Privacy

JCS Analytics - We are analysts. We Ask. We Automate. We Discover.

Details
By J. Smith
J. Smith
Articles
August 14,2025
Last Updated: 14 August 2025
Hits: 458
  • Tableau
  • Python
  • CGM Data
  • BGM Comparison
  • Sensor Placement

Aligning CGM and BGM Readings Using Python and Tableau

BGM CGM Alignment

A data-driven look at how well continuous glucose monitor (CGM) readings align with blood glucose meter (BGM) readings—and what it reveals about device performance and sensor placement.

Abstract

Explore how Python and Tableau can be used to evaluate the alignment between continuous glucose monitor (CGM) and blood glucose meter (BGM) readings. By pairing readings within a 15-minute window and analyzing percent differences over time and by sensor location, the project identifies patterns in device performance and helps validate sensor placement.

Key Points

  • Pairing Logic: Python is used to match BGM readings with the nearest CGM reading within a 15-minute window to account for physiological lag.
  • Sensor Location Handling: merge_asof() enables accurate assignment of CGM sensor location data without requiring exact timestamp matches.
  • Data Scope: The analysis uses cleaned BGM and CGM datasets, covering the most recent 90 days.
  • Visualization Design: Tableau dashboards display daily trends, alignment by location, and AM/PM breakdowns, with parameters and filters to support interaction.
  • Application: The workflow highlights how differences in alignment can point to sensor performance issues, placement variability, or expected physiological lag.

Read more: Aligning CGM and BGM Readings Using Python and Tableau

Details
By J. Smith
J. Smith
Articles
July 4,2025
Last Updated: 03 November 2025
Hits: 487
  • 5K@ADA
  • Tableau Visualizations
  • SQLite
  • ADA Race Results
  • Data Workflow Optimization

Adapting the 5K@ADA Race Results Project for 2025

5K@ADA 2025 Race Results

A project’s real value comes from how well it adapts as the data changes.

Abstract

The 5K@ADA race results project has been updated for 2025 with improvements to data storage, cleaning, and visualization. Key enhancements include the use of SQLite for managing multi-year data, SQL-based deduplication, handling of multilingual gender values, and updated Tableau dashboards with year-based logic. These changes improve scalability, accuracy, and long-term usability.

Key Points

  • Integrated SQLite to support multi-year data storage and eliminate reliance on separate CSV files.
  • Shifted deduplication to SQL, improving efficiency and simplifying logic.
  • Added handling for foreign language values in the Gender column during data cleaning.
  • Removed the Name column before export to streamline the dataset and protect privacy.
  • Updated Tableau visualizations to support dynamic year selection and adaptable group labels.

Read more: Adapting the 5K@ADA Race Results Project for 2025

Details
By J. Smith
J. Smith
Articles
July 1,2025
Last Updated: 05 November 2025
Hits: 432
  • AI Interaction
  • Generative AI
  • Prompt Engineering
  • Hidden Strengths
  • Human-AI Collaboration

What's Your Hidden Superpower? Ask AI the Right Way.

Person and AI Conversing

A deeper look at what surfaced when I asked ChatGPT to assess strengths, weaknesses, and why the results stood out.

A casual question—What’s my hidden superpower?—led to one of the more insightful AI interactions I’ve had. What started as a moment of curiosity turned into a deeper conversation about how we ask questions, how AI responds, and what makes some exchanges far more productive than others.

Read more: What's Your Hidden Superpower? Ask AI the Right Way.

Details
By J. Smith
J. Smith
Articles
May 31,2025
Last Updated: 31 May 2025
Hits: 372
  • Data Visualization
  • Health Data
  • Clinical Context
  • Cross-Disciplinary Skills
  • Advanced Data Skills

Why I Took Medical Courses to Strengthen My Data Skills

Abstract

This post explores how taking medical and healthcare-focused courses strengthened my data analysis and visualization skills. By engaging with real-world clinical content, I improved how I interpret, structure, and present complex health data — especially in tools like Tableau and Python.

Key Points

  • Medical courses provided valuable context for analyzing health data more accurately.
  • Exposure to clinical reasoning improved how I structure data visualizations.
  • CME and university-level content offered insights into data use in real-world healthcare.
  • Visualizing CGM data became a way to explore advanced design techniques.
  • Courses helped connect medical insight with technical skill development.

Read more: Why I Took Medical Courses to Strengthen My Data Skills

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

Page 2 of 8

Recent Activity

January 2026

  • Lilly and NVIDIA Launch AI Lab Focused on Scalable, Data-Driven Discovery

Articles

  • 5K@EASD Race Results: Trends from 2023 and 2024
  • Adapting the 5K@ADA Race Results Project for 2025
  • Advanced Data Retrieval with Python
  • Aligning CGM and BGM Readings Using Python and Tableau
  • Analysis and Visualization of Public Health Agency of Canada COVID Cases
  • Bridging Data and Healthcare in the Nordics
  • Complex Web Scraping with Python
  • Creating a Calculated Field in Tableau to Get Get Data Aggregated by Month in the Correct Order
  • Data Analyst vs. Business Analyst: Similarities and Differences
  • Data Analytics for Type 2 Diabetes
  • Data Science and Responsible AI in the Pharmaceutical Industry: A Case Study of Novo Nordisk
  • Denmark's Leap into AI Innovation: A Model for Future Research and Development
  • Denmark’s Gefion AI Supercomputer Revolutionizes AI-driven Research
  • Eli Lilly’s AI Strategy: Opening High-Value Drug Discovery Models to the Biotech Ecosystem
  • Embracing AI: Balancing Augmentation, Ethics, and Environmental Impact
  • Enhancing Data Analysis and Visualization Workflows with AI
  • Exploring the 2023 5K@EASD Virtual Run: A Tableau Analysis
  • Exploring the Growth of GLP-1 RA Sales
  • How an Hour-by-Hour View Transforms Time in Range Insights
  • How Novo Nordisk is Utilizing AI for Drug Discovery

Top Subjects

  • Tableau
  • Python
  • Data Analytics
  • Data Visualization
  • Novo Nordisk
  • Tableau Visualizations
  • AI
  • 5K@EASD
  • Data Analysis
  • 5K@ADA
  • Type 2 Diabetes
  • Data Cleaning
  • Drug Discovery
  • AI Innovation
  • Quantum Computing
  • Diabetes Management
  • Race Results
  • Diabetes Awareness
  • Virtual 5K
  • Continuous Glucose Monitor
  • SQLite
  • SQLite Database Management
  • Continuous Glucose Monitoring
  • CGM Data Analysis
  • Artificial Intelligence
  • AI in Healthcare
  • Healthcare Data
  • AI in Drug Discovery
  • NVIDIA
  • DATETRUNC

Contact Me

Search

End Diabetes Stigma

5K@ADA

5K@EASD

World Diabetes Day

Rochen Web Hosting

Bluesky Social

  • You are here:  
  • Home
  • Articles
 
Copyright © 2026 JCS Analytics. All Rights Reserved.
Joomla! is Free Software released under the GNU General Public License.