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: 686
  • 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: 669
  • 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: 617
  • 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
March 3,2025
Last Updated: 03 March 2025
Hits: 1617
  • AI in Healthcare
  • Diagnostic Accuracy
  • AI Chatbots
  • Physician Diagnosis
  • Large Language Models

Study Finds AI Chatbots Do Not Improve Physicians’ Diagnostic Reasoning

Large Language Model Influence on Diagnostic Reasoning
Source: Goh E, Gallo R, Hom J, et al. Large language model influence on diagnostic reasoning: a randomized clinical trial. JAMA Netw Open. 2024;7(10):e2440969. doi:10.1001/jamanetworkopen.2024.40969. Used under CC-BY license.

Abstract

A recent study published in JAMA Network Open examined whether AI chatbots, specifically large language models (LLMs) like ChatGPT-4, improve physicians' diagnostic reasoning. The randomized clinical trial found that while the LLM alone outperformed physicians in diagnostic accuracy, providing physicians with access to the AI tool did not significantly enhance their performance compared to conventional resources. The findings highlight the potential of AI in diagnostics but underscore the need for better integration, clinician training, and further research to optimize AI's role in medical decision-making.

Key Points

  • A JAMA Network Open study assessed the impact of AI chatbots on physicians' diagnostic reasoning.
  • The trial involved 50 physicians diagnosing clinical vignettes with or without LLM assistance.
  • The LLM alone achieved a 92% diagnostic accuracy, outperforming both physician groups.
  • Physicians using the AI tool had similar accuracy (76%) to those using traditional resources (74%).
  • AI's strength lies in processing large data sets and reducing cognitive biases.
  • Experts emphasize the need for better AI integration, clinician training, and model refinement.
  • Future research should explore how AI can consistently support and enhance medical decision-making.

Read more: Study Finds AI Chatbots Do Not Improve Physicians’ Diagnostic Reasoning

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

Page 3 of 9

Recent Activity

July 2026

  • When AI Isn’t Enough: What the FDA’s Purolea Warning Letter Teaches About AI Governance

June 2026

  • Designing Visualizations That Help People Understand the Data
  • Novo Nordisk IT Incident Shows Why Pseudonymized Data Still Requires Serious Protection

May 2026

  • Lundbeck’s AI Days Show How Companies Can Make AI Adoption Practical
  • Sovereign AI Infrastructure and the New Shape of AI Strategy
  • Why I Take Medical Courses as a Data Analyst

April 2026

  • Novo Nordisk Expands Its AI Strategy Through New OpenAI Partnership

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
  • Designing Visualizations That Help People Understand the Data
  • 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 Novo Nordisk is Utilizing AI for Drug Discovery

Top Subjects

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

Contact Me

Search

End Diabetes Stigma

5K@ADA

5K@EASD

World Diabetes Day

Bluesky Social

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