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
January 7,2024
Hits: 482
  • Data Analytics
  • Type 2 Diabetes
  • Predictive Modelling

Data Analytics for Type 2 Diabetes

As a data analyst living with type 2 diabetes, I have a unique perspective on the intersection of data analytics and health outcomes. The power of data analytics is transforming the way we manage chronic diseases such as type 2 diabetes, leading to improved health outcomes and quality of life for patients.

Data analytics can significantly improve health outcomes for people with Type 2 Diabetes (T2D) in several ways:

  1. Predictive Analytics: Data analytics can be used to build predictive models that forecast health outcomes for individuals with T2D. These models can use patient data such as history of comorbidities and medications to predict future health outcomes, including life expectancy. Predictive analytics can also identify patients who are likely to benefit from intensified treatment, thereby improving health outcomes at lower costs.
  2. Patient-Generated Health Data (PGHD) Analysis: Large volumes of PGHD can help detect patterns of health behavior in people living with T2D. This can provide insights into current health behaviors and make predictions about future health outcomes.
  3. Intervention Evaluation: Data analysis can be used to monitor and evaluate the effectiveness of interventions. This involves collecting and analyzing data on the process and outcomes of interventions, such as changes in blood glucose levels, complications, quality of life, and patient satisfaction. The data can then be compared with baseline data and expected results to identify achievements, challenges, or areas for improvement.
  4. Big Data Analytics: Big data analytics can provide real-time analyses of large sets of varied input data to diagnose and predict complications of diabetes. This can lead to improvements in managing chronic diseases.
  5. Real-Time Health Data and Health Information Technology (HIT): Real-time Electronic Health Record (EHR) data provides a high-volume data source that can be used to assess the social needs and place-based social determinants of health (SDOH) of patients with T2D. This can help in reducing diabetes risk.
  6. Data-Driven Modelling: Data-driven models can simulate the occurrence of diabetes-associated complications and all-cause death for T2D patients over their lifetime.
  7. Data Analytics Suite: A data analytics suite can be developed for exploratory, predictive, and visual analysis of T2D data. This can help clinicians and patients formulate strategies for diabetes management.

Data analytics is a powerful tool in improving health outcomes for people with T2D by enabling predictive modeling, intervention evaluation, behavior pattern detection, real-time health data analysis, and data-driven modeling.

Please visit https://jcst2d.com/ to learn more about type 2 diabetes.

Frequently Asked Questions

How do patients contribute their data for analysis, and what are the privacy implications?
Patients contribute data through various means including electronic health records, wearable devices, and mobile apps. Privacy is protected by laws like HIPAA in the U.S., ensuring data is anonymized and securely handled to prevent unauthorized access.

What are some specific examples of interventions that have been evaluated using data analytics, and what were their outcomes?
Specific examples might include programs aimed at lifestyle modification, medication adherence, or remote monitoring systems. Outcomes often measure improvements in glycemic control, reduced hospital admissions, or enhanced patient engagement.

How accessible are these data analytics tools and models to healthcare providers, especially those in resource-limited settings?
These tools' accessibility varies widely. In resource-rich settings, hospitals and clinics might integrate sophisticated analytics into their systems. However, in resource-limited settings, the high cost and technical requirements can be significant barriers, though simpler, low-cost solutions are being developed to bridge this gap.

Details
By J. Smith
J. Smith
Articles
January 6,2024
Hits: 1738
  • TELUS
  • Google Cloud
  • AI
  • Data Analytics
  • Contact Center

How TELUS Transformed Data Analysis with Contact Center AI

TELUS Corp., a prominent player in the telecommunications industry, has leveraged Google's Contact Center AI (CCAI) to revolutionize its approach to data analysis and customer service. Google Contact Center AI is a platform designed to enhance customer interactions by providing human-like, AI-powered experiences. It enables virtual agents to conduct natural and accurate multi-turn conversations, supports human agents with real-time information and guidance, and turns conversations into actionable insights through advanced analytics and reporting.

By adopting Google CCAI, TELUS has been able to improve the efficiency and effectiveness of its contact centers. The AI analyzes up to 60,000 contact center calls daily, helping TELUS to accurately identify customer intentions and sentiments. This deep understanding of customer interactions allows TELUS to discover opportunities for improvement and deliver a more personalized service experience.

The strategic alliance formed between TELUS and Google Cloud in 2021 has been pivotal in TELUS's digital transformation journey. Through this partnership, TELUS has committed to utilizing Google Cloud's technologies, including CCAI, to reinvent customer experiences and achieve significant cost savings. The collaboration also focuses on co-innovating new industry solutions and strategies, starting with communications technology, healthcare, agriculture, security, and automation.

TELUS' innovative use of generative AI models, as part of its broader AI strategy, has been a game-changer in customer service. These AI models can generate new content, which can be used to train call agents and improve customer interactions. The generative AI models by Google, demonstrated by TELUS, are a testament to the transformative power of AI in driving out inefficiencies and reducing redundant workflows.

TELUS' transformation of data analysis with Google Contact Center AI exemplifies how AI can automate contact centers, empower teams with insights, and ultimately delight customers with improved service while lowering operational costs.

Contact Center AI (CCAI) Platform
https://cloud.google.com/solutions/contact-center-ai-platform

Frequently Asked Questions

What specific challenges did TELUS face with their previous data analysis processes before adopting Google's Contact Center AI?

Before adopting Google's Contact Center AI, TELUS faced several specific challenges with their previous data analysis processes:

Siloed Data Assets: TELUS had data assets that were siloed, which hindered the efficient use and analysis of data across the organization. This fragmentation made it difficult to gain a comprehensive understanding of data and leverage it for strategic decision-making.

Inefficient Data Engineering Tasks: The process of data engineering, which includes data collection, storage, and preprocessing, was slow and cumbersome. This inefficiency delayed the time to insights and made it challenging to respond quickly to business needs.

Limited Data Democratization: Before the modernization, data was not easily accessible across different business units within TELUS. This limited the ability to share insights and collaborate on data-driven projects, especially given TELUS's diverse operations spanning telecommunications, healthcare, security, and agriculture.

Complex Data Governance: Ensuring data governance, including the management of data access, quality, and compliance, was complex due to the dispersed nature of data assets. This complexity made it challenging to maintain a single source of truth and ensure data reliability.

Security and Privacy Concerns: As TELUS's data science practice expanded, maintaining the security and privacy of data became increasingly critical. The company needed to ensure that data used for analysis could not be attributed to any single subscriber, while also meeting data sovereignty requirements.

Slow Innovation and Experimentation: The previous infrastructure and processes at TELUS did not support rapid experimentation and innovation. The need for a faster framework to test ideas and iterate them was evident to minimize the impact of failures and quickly identify successful projects.

How did the implementation of Google's Contact Center AI impact TELUS's operational costs and customer satisfaction metrics specifically?

Operational Costs Reduction

Automated Systems Success Increase: The use of automated systems to resolve customer issues increased by 50%, indicating a significant improvement in efficiency and a potential reduction in the need for human intervention, which can be costly.
Data Processing Acceleration: Data processing times were accelerated by 20 times, suggesting that TELUS could handle customer data and inquiries much faster, leading to potential cost savings in operations and customer service.
Customer Service Costs: The implementation of Google's CCAI directly contributed to reducing customer service costs. This reduction is likely due to the increased efficiency and automation capabilities provided by the AI, which reduces the workload on human agents and the resources needed to manage customer inquiries.

Customer Satisfaction Metrics Improvement

Customer Experience Improvement: The use of Google's CCAI not only reduced costs but also improved customer experiences. This improvement could be attributed to faster response times, more accurate and helpful automated responses, and a more personalized service through better data management and analysis.
Increased App Users: The number of app users grew from 400,000 to 1.2 million, indicating a broader acceptance and satisfaction with the digital services provided by TELUS. This growth suggests that customers found the app more useful and engaging, which can be a direct result of the improved functionalities enabled by the AI technologies.
Efficiency in Contact Center Operations: The integration of Google Cloud Contact Center AI and Automation Anywhere’s Automation 360 RPA platform led to a 66% improvement in the efficiency of contact center operations. This efficiency not only reduces operational costs but also enhances customer satisfaction by ensuring quicker and more accurate responses to inquiries.

Are there any case studies or examples of how TELUS's use of generative AI models has directly improved customer service interactions?

Automated Customer Service Solutions

TELUS International has developed automated customer service solutions that utilize GenAI to provide immediate, 24/7 support to customers. These solutions are designed to handle a wide range of customer inquiries, from simple questions to more complex issues, without the need for human intervention. This not only speeds up response times but also allows human customer service representatives to focus on more complex and nuanced customer needs.

Virtual Agent and Conversational App Building

The company has also invested in virtual agent and conversational app building, leveraging GenAI to create more natural and engaging interactions with customers. These virtual agents are capable of understanding and responding to customer inquiries in a way that mimics human conversation, making the customer service experience more seamless and enjoyable.

Automated Summarization for Interaction Overviews

Another innovative application of GenAI by TELUS International is automated summarization for interaction overviews, knowledge bases, and self-service FAQs. This technology can quickly summarize the content of customer interactions, making it easier for customer service agents to understand the context of a customer's issue and provide more accurate and personalized support.

Language Translation

TELUS International's GenAI solutions also include language translation features with automated detection and omnichannel support. This capability ensures that customers can receive support in their preferred language, breaking down language barriers and making customer service more accessible to a wider audience.

Personalization at Scale

A key benefit of GenAI in customer service is its ability to facilitate personalization at scale. TELUS International leverages GenAI to generate personalized content and recommendations for customers, enhancing the overall customer experience by making interactions more relevant and tailored to individual needs.

Continuous Improvement

TELUS International's approach to GenAI in customer service is not static; the company continuously seeks to enhance its GenAI solutions with new capabilities and improvements. This ongoing commitment to innovation ensures that TELUS International remains at the forefront of leveraging AI to improve customer service interactions.

Details
By J. Smith
J. Smith
Articles
January 6,2024
Hits: 607
  • Tableau
  • DATETRUNC
  • Calculated Field

Creating a Calculated Field in Tableau to Get Get Data Aggregated by Month in the Correct Order

Creating a visualization for the most recent 12 months in Tableau can be a common requirement for time series analysis. To achieve this, you can use the `DATETRUNC` function to truncate your date data to the first day of each month, ensuring that your months will be in the correct order when aggregated. Here's how to use the `DATE(DATETRUNC('month',[Date]))` function effectively in Tableau for this purpose.

Understanding the DATETRUNC Function

The `DATETRUNC` function in Tableau truncates a given date to the specified date part, such as the year, quarter, or month. When you use `DATETRUNC('month', [Date])`, it will return the first day of the month for each date in your dataset. This is useful for creating consistent monthly data points for visualization purposes.

Steps

  1. Create a Calculated Field: In Tableau, create a new calculated field using the formula `DATE(DATETRUNC('month',[Date]))`. This will convert all dates in your dataset to the first of their respective months, without including the time along with the date. Only the date is necessary.
  2. Apply a Relative Date Filter: To focus on the most recent 12 months, apply a relative date filter to your worksheet. Add the date dimension to the filter and select 'relative date', then choose 'last twelve months'. This filter will automatically update as time progresses, ensuring that your visualization always represents the latest 12-month period.
  3. Use the Calculated Field in Your Visualization: Drag your new calculated field to the appropriate shelf (usually Columns) to use it as the axis for your visualization. This will ensure that your data is aggregated by the truncated month date, which will sort the months in chronological order.
  4. Adjust Aggregation as Needed: If you need to aggregate your data in a specific way (e.g., sum, average), make sure to adjust the aggregation settings for your measure values accordingly.
  5. Customize Your Visualization: You can now build your visualization as desired, whether it's a line chart, bar chart, or any other type that benefits from a monthly time series analysis.

Benefits of Using DATETRUNC

  • Consistency: By truncating dates to the first of the month, you ensure that each month is represented consistently, which is crucial for accurate comparisons and trend analysis.
  • Ordering: Truncated dates will naturally fall into chronological order, which is essential for time series visualizations.
  • Flexibility: You can easily adjust the level of date truncation (e.g., to quarters or years) if you need to analyze your data at a different granularity.

Using the `DATE(DATETRUNC('month',[Date]))` function in Tableau is a powerful way to prepare your data for visualizations that require monthly aggregation. It ensures that your months are in order and that your visualization reflects the most recent 12-month period. This approach is part of Tableau's robust time series analysis capabilities, which allow for insightful trend spotting and variance analysis over time.

Frequently Asked Questions

Can this method be applied to other time units (like weeks or days) and if so, how would the approach change? 
The DATETRUNC function can indeed be applied to other time units such as weeks or days. The approach remains similar, but the unit of truncation in the function needs to change (e.g., 'week' or 'day') to reflect the desired aggregation level.

How can you use the calculated field created with DATETRUNC in Tableau to compare year-over-year data? 
To compare year-over-year data using DATETRUNC, you can create separate calculated fields for the current and previous years by manipulating the date part of your DATETRUNC calculation. Then, use these fields in your visualization to compare performance across different years.

What are the best practices for ensuring that the date formatting in the calculated field matches the rest of the dashboard elements in Tableau?
Best practices for consistent date formatting include setting the default date format in the data source, using calculated fields to standardize date formats, and applying consistent formatting settings across dashboard elements directly within Tableau's format options.

 

Details
By J. Smith
J. Smith
Articles
October 18,2023
Hits: 799
  • Tableau
  • 5K@EASD
  • Data Visualization

Exploring the 2023 5K@EASD Virtual Run: A Tableau Analysis

Delve into the fascinating statistics from the 2023 5K@EASD virtual run. This analysis serves as a testament to the power of Tableau, a tool that allows us to visualize and understand data in a matter of minutes.

You can explore the full analysis in our 5K@EASD Story Points on Tableau Public.

Story Points Breakdown

  1. Welcome: An introduction to the analysis.
  2. Participants by Country: A vibrant, color-coded map that displays the number of participants from each country.
  3. Countries with 100 or More Participants: Interactive bar charts that show the number of participants by country and gender. You can select any combination of country and gender to see how the counts change.
  4. My Bib and Results: A personal touch to the analysis.

We hope this analysis provides you with a clear understanding of the 2023 5K@EASD virtual run's reach and impact. We also hope it demonstrates the potential of Tableau as a powerful tool for data visualization and analysis.

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

Page 8 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.