Top 2
Prep plan
Updated weekly · Last refresh Sep 22CCC Intelligent Solutions Data Analyst Interview Questions
The questions to prepare for a CCC Intelligent Solutions Data Analyst interview. Questions from real interview reports rank first. Updated daily.
2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →1
data visualizationStart here. 1 question · ~8 min
2
Pivot1 question · ~8 min
Excel Experience and SkillsEasy
Tests practical data handling skills relevant to business analysis work.
PivotData WranglingAggregations
CCC Intelligent Solutions
CCC Intelligent SolutionsSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Find Duplicates in SQLEasy
Practice
Practice drillUse GROUP BY and HAVING to find duplicate policy records in Ryan Specialty data.
Group ByHavingAggregations
Gramener
CarGurus
Fresh Gravity
Gramener
CarGurus
Fresh GravityTop 3 Categories by RevenueMedium
Practice
Practice drillUse joins, aggregation, and a CTE to find the top three completed CCC ONE sales categories by revenue.
RankingGroup ByAggregations
CCC Intelligent Solutions
CCC Intelligent SolutionsRunning Total With Window FunctionsEasy
Practice
Practice drillCalculate each user's running order total over time using a window function.
Window FunctionsDate FunctionsRunning Totals
Bayer
Sparksoft
Western Digital
Bayer
Sparksoft
Western DigitalThe finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.