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
July 4,2025
Hits: 252
  • 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
Hits: 257
  • 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
Hits: 183
  • 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

Details
By J. Smith
J. Smith
Articles
April 22,2025
Hits: 238
  • Continuous Glucose Monitor
  • CGM Data Analysis
  • Time in Range
  • Hourly Glucose Trends
  • Diabetes Data Insights

How an Hour-by-Hour View Transforms Time in Range Insights

Time in Range by Hour

A new way to view CGM data that focuses on patterns, not perfection.

Abstract

This post explores how visualizing continuous glucose monitor (CGM) data by hour—rather than by day—reveals deeper insights into when glucose levels shift. By replacing traditional Time in Range charts with dynamic, time-specific visualizations, this approach emphasizes understanding over judgment. It highlights patterns like post-meal spikes and overnight stability, making glucose data more actionable and emotionally neutral.

Key Points

  • Hourly View Adds Context: Reveals when glucose levels go out of range, not just how often.
  • Flexible Range Selection: Users can toggle between 70–180 mg/dL and 70–140 mg/dL thresholds.
  • Reframed Visual Cues: Reversed green-blue color scale avoids framing results as good or bad.
  • Actionable Patterns: Shows consistent overnight control and post-meal variability.
  • Emphasis on Exploration: Focuses on patterns and possibilities, not compliance.
  • Technical Approach: Uses Tableau calculated fields for hourly binning and dynamic formatting.

Read more: How an Hour-by-Hour View Transforms Time in Range Insights

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

Page 2 of 8

Recent Activity

November 2025

  • Eli Lilly’s AI Strategy: Opening High-Value Drug Discovery Models to the Biotech Ecosystem

September 2025

  • Bridging Data and Healthcare in the Nordics

August 2025

  • Aligning CGM and BGM Readings Using Python and Tableau
  • Streamlined Drug Shortage Tracking with Python and SQLite

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

  • AI in Drug Discovery
  • Federated Learning
  • Pharmaceutical Data
  • Biotech Innovation
  • Lilly TuneLab
  • NVIDIA
  • Tableau
  • Python
  • Data Visualization
  • Data Analytics
  • 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

Contact Me

Search

End Diabetes Stigma

5K@ADA

5K@EASD

World Diabetes Day

Rochen Web Hosting

Bluesky Social

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