What was our GWP by line of business last quarter?Scrape competitor pricing from these 5 carrier websitesFind Slack messages about the Allied renewalWrite a script to deduplicate our broker contact listWhat was our GWP by line of business last quarter?Scrape competitor pricing from these 5 carrier websitesFind Slack messages about the Allied renewalWrite a script to deduplicate our broker contact listWhat was our GWP by line of business last quarter?Scrape competitor pricing from these 5 carrier websitesFind Slack messages about the Allied renewalWrite a script to deduplicate our broker contact list
Show loss ratio trends by state for the last 3 yearsSummarize yesterday's underwriting committee notesBuild a chart comparing quote-to-bind ratesSearch my email for anything about the Garcia claimShow loss ratio trends by state for the last 3 yearsSummarize yesterday's underwriting committee notesBuild a chart comparing quote-to-bind ratesSearch my email for anything about the Garcia claimShow loss ratio trends by state for the last 3 yearsSummarize yesterday's underwriting committee notesBuild a chart comparing quote-to-bind ratesSearch my email for anything about the Garcia claim
Generate a weekly pipeline report as a PDFWhat's our average claim severity for auto liability?Pull all open Jira tickets tagged as P0Create a Python script to parse these loss runsGenerate a weekly pipeline report as a PDFWhat's our average claim severity for auto liability?Pull all open Jira tickets tagged as P0Create a Python script to parse these loss runsGenerate a weekly pipeline report as a PDFWhat's our average claim severity for auto liability?Pull all open Jira tickets tagged as P0Create a Python script to parse these loss runs
How many policies did we bind in January?Draft a summary of this quarter's premium growthFind who mentioned the new rating algorithm in SlackCompare retention rate vs last year by segmentHow many policies did we bind in January?Draft a summary of this quarter's premium growthFind who mentioned the new rating algorithm in SlackCompare retention rate vs last year by segmentHow many policies did we bind in January?Draft a summary of this quarter's premium growthFind who mentioned the new rating algorithm in SlackCompare retention rate vs last year by segment
Scrape NAIC filing data for our top 10 competitorsWhat were the top 5 claim causes in Q4?Run a correlation analysis on loss ratio vs fleet sizeSummarize the emails I got today about renewalsScrape NAIC filing data for our top 10 competitorsWhat were the top 5 claim causes in Q4?Run a correlation analysis on loss ratio vs fleet sizeSummarize the emails I got today about renewalsScrape NAIC filing data for our top 10 competitorsWhat were the top 5 claim causes in Q4?Run a correlation analysis on loss ratio vs fleet sizeSummarize the emails I got today about renewals
Build a dashboard of monthly bind volume by stateWrite a web scraper for DOT carrier safety ratingsWhat's the average time to close a claim this year?Find all Slack threads where someone mentioned churnBuild a dashboard of monthly bind volume by stateWrite a web scraper for DOT carrier safety ratingsWhat's the average time to close a claim this year?Find all Slack threads where someone mentioned churnBuild a dashboard of monthly bind volume by stateWrite a web scraper for DOT carrier safety ratingsWhat's the average time to close a claim this year?Find all Slack threads where someone mentioned churn
Export our top 50 accounts by premium as a CSVHow does our combined ratio compare to last quarter?Search for any emails about the XYZ program launchGenerate a loss triangle for our commercial auto bookExport our top 50 accounts by premium as a CSVHow does our combined ratio compare to last quarter?Search for any emails about the XYZ program launchGenerate a loss triangle for our commercial auto bookExport our top 50 accounts by premium as a CSVHow does our combined ratio compare to last quarter?Search for any emails about the XYZ program launchGenerate a loss triangle for our commercial auto book
What's the 12-month rolling loss ratio for fleet?Scrape AM Best ratings for our reinsurance panelHow many quotes did we issue last week by state?Write a script to reconcile premium vs commission dataWhat's the 12-month rolling loss ratio for fleet?Scrape AM Best ratings for our reinsurance panelHow many quotes did we issue last week by state?Write a script to reconcile premium vs commission dataWhat's the 12-month rolling loss ratio for fleet?Scrape AM Best ratings for our reinsurance panelHow many quotes did we issue last week by state?Write a script to reconcile premium vs commission data
Show me all claims over $100K opened this quarterFind Slack messages from underwriting about pricingBuild a renewal timeline for accounts expiring in MarchWhat percent of submissions convert to quotes?Show me all claims over $100K opened this quarterFind Slack messages from underwriting about pricingBuild a renewal timeline for accounts expiring in MarchWhat percent of submissions convert to quotes?Show me all claims over $100K opened this quarterFind Slack messages from underwriting about pricingBuild a renewal timeline for accounts expiring in MarchWhat percent of submissions convert to quotes?
Create an executive summary of our Q4 performancePull DOT inspection data for our top 20 fleetsWhat's the trend in average premium per vehicle?Search Linear for open bugs in the rating engineCreate an executive summary of our Q4 performancePull DOT inspection data for our top 20 fleetsWhat's the trend in average premium per vehicle?Search Linear for open bugs in the rating engineCreate an executive summary of our Q4 performancePull DOT inspection data for our top 20 fleetsWhat's the trend in average premium per vehicle?Search Linear for open bugs in the rating engine
Generate a broker scorecard ranked by GWPWrite a Python notebook to analyze claim frequencyHow did our expense ratio change year over year?Find emails about the new commercial auto programGenerate a broker scorecard ranked by GWPWrite a Python notebook to analyze claim frequencyHow did our expense ratio change year over year?Find emails about the new commercial auto programGenerate a broker scorecard ranked by GWPWrite a Python notebook to analyze claim frequencyHow did our expense ratio change year over year?Find emails about the new commercial auto program
