Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
A solution to last week’s challenge can be found here.
This challenge was submitted by Erin Miller, @Erin . Thank you, Erin, for your submission!
You are a data analyst reviewing independent medical review outcomes. Your objective is to identify patterns that influence whether a health plan's decision is upheld or overturned.
Use the dataset to analyze trends and answer the following questions.
- For each diagnosis category, calculate the percentage of cases where the health plan’s decision was upheld and where it was overturned. Exclude any records with missing diagnosis categories.
- For each gender (male or female), identify the age range most commonly associated with overturned decisions.
- Determine which diagnosis and treatment categories have the highest number of overturned decisions.
- Create a graph/chart showing how the percentage of overturned decisions has changed over time, broken down by year.
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
Source: https://www.kaggle.com/datasets/prasad22/ca-independent-medical-review
