10 fictional AI personas. Exploratory perspectives, not a survey of real customers. Methodology & limitations

Lisa Hoeger

Lisa Hoeger

Product analyst at an ecommerce company

Full-depth AI personas

Why this persona fits the audience

Pulls MySQL exports for funnel and retention work, cleans them in spreadsheets, and maintains recurring analysis in Looker and CSV files. Works mainly with standard office tools and the company’s free SQL access; has not paid for a dedicated desktop SQL client before.

  • Age: 29
  • Location: Manchester, UK
  • Occupation: Product analyst
  • Income: £52k
  • Education: MSc in Business Analytics
  • Company size: Mid-sized (150-300 employees)
  • Years in role: 4
“It's all about finding the signal in the noise, isn't it? If the data isn't clean, the signal gets lost, and then we're just guessing.”

Lisa Hoeger grew up in a working-class family in Leeds, where her parents instilled in her a strong work ethic and a sense of fiscal responsibility. Her academic journey was driven by a fascination with understanding patterns and optimizing processes, leading her to pursue a BSc in Economics followed by an MSc in Business Analytics. She excelled in her postgraduate studies, particularly in modules focused on statistical modeling and data visualization, which solidified her career aspirations. Upon graduating, she secured a role as a Junior Analyst at a growing ecommerce company, quickly demonstrating her aptitude for extracting meaningful insights from complex datasets. Over the past four years, she has progressed to a Product Analyst role, becoming a go-to person for funnel analysis and retention metrics. Her current responsibilities involve a significant amount of manual data manipulation, pulling raw data from the company's MySQL database, meticulously cleaning and transforming it using spreadsheets, and then presenting findings through Looker dashboards and recurring CSV reports. She is acutely aware of the inefficiencies in her workflow, particularly the time spent on data preparation, but has largely made do with the company's standard toolset, which includes free SQL access and office productivity software. While she's proficient with these tools, she often finds herself wishing for more streamlined methods to explore and interrogate data. Lisa is pragmatic about her career progression, focusing on building a solid foundation of analytical skills and contributing tangible value to her team. She is saving diligently for a property deposit, viewing homeownership as a key milestone for financial security and independence. Her personal life is balanced by her passion for running, which provides a crucial outlet for stress and a sense of personal achievement outside of her demanding professional life. She values accuracy and usefulness above all else in her work, driven by a desire to ensure that business decisions are informed by reliable data, even if the process to get there is sometimes arduous.

Background & daily life

A day in their life

Lisa's day typically begins with her early morning run, followed by a quick breakfast of overnight oats. She commutes to the office, arriving around 8:45 AM. The first few hours are spent reviewing overnight data imports and responding to urgent Slack messages. Mid-morning involves pulling MySQL data for a new A/B test analysis, which she then exports to CSV. Lunch is usually a packed meal eaten at her desk while scanning industry newsletters. The afternoon is dedicated to cleaning the exported data in Excel, building charts, and preparing a summary for the product team meeting at 3 PM. She often stays a little late to refine a Looker dashboard or document her analysis process, leaving the office around 6 PM.

Lifestyle

Lisa lives in a modest but tidy three-bedroom terrace in Fallowfield, sharing costs with two colleagues to keep rent down. Her routine is anchored by a consistent 5:30 AM run around Heaton Park, which serves as her mental reset before the commute via tram to Deansgate. She is financially cautious, prioritizing savings for a potential mortgage deposit over frequent dining out or impulse purchases. Evenings are often spent meal-prepping for the week or catching up on industry blogs. Socially, she prefers smaller gatherings with close friends over large parties, valuing deep conversations.

Work life

Lisa's role as a Product Analyst involves a significant amount of data wrangling. Her days are a cycle of pulling raw data from MySQL, often in large CSV exports, which she then meticulously cleans and transforms in Excel or Google Sheets. She builds recurring dashboards and reports in Looker, but finds the interface can be clunky for ad-hoc exploration. Collaboration with the product managers and engineers is frequent, often involving explaining complex data findings in simple terms. The pressure is on to deliver accurate insights quickly, especially during product launch cycles or A/B test analysis, which can lead to late nights wrestling with data inconsistencies.

Relationships

Lisa maintains close ties with her parents and younger brother back in her hometown of Leeds, speaking to them weekly. Her Manchester social circle is small but strong, primarily consisting of her flatmates and a few university friends she met during her MSc. She also has a running club acquaintance, Mark, who shares her passion for data and occasionally swaps tips on efficient analysis techniques.

How they decide

Lisa is a methodical decision-maker. She gathers information from multiple sources, weighs the pros and cons carefully, and often seeks input from trusted colleagues before committing. She values practicality and evidence of effectiveness, preferring solutions that demonstrably solve a problem without introducing unnecessary complexity.

How they sound

Speaks with a clear, measured Northern English accent. Tends to be articulate and precise, avoiding excessive slang or jargon unless discussing technical topics with peers. Her tone is generally calm and professional, but can become more animated when discussing data findings or a particularly interesting analytical challenge. She often uses phrases like 'essentially,' 'the crux of it is,' and 'from what I can see.'

Personality traits

  • meticulously organized
  • quietly persistent
  • data-skeptical
  • efficiency-driven
  • team-oriented
  • pragmatic
  • detail-obsessed
  • reserved in meetings
  • reliable under pressure
  • curious about tech stacks

Goals

  • Achieve a senior analyst position within her company or a similar ecommerce firm.
  • Develop a more robust understanding of data warehousing and ETL processes.
  • Save enough for a deposit on a small flat in a desirable Manchester neighbourhood.
  • Complete a half-marathon in under two hours.
  • Contribute to open-source projects related to data analysis tools.

Problems & frictions

  • The manual process of cleaning and preparing data is time-consuming and prone to human error.
  • Limited access to advanced data exploration tools hinders deeper, more complex analysis.
  • Communicating nuanced data insights to non-technical stakeholders can be challenging.
  • Balancing the demand for rapid analysis with the need for thorough data validation.
  • Feeling constrained by the existing toolset, wishing for more efficient ways to query and visualize data.

Values

  • accuracy
  • usefulness
  • collaboration
  • practicality

Interests

  • ecommerce analytics
  • spreadsheets
  • A/B testing
  • running

Media habits

  • Substack newsletters on data engineering
  • LinkedIn for industry trends
  • Spotify 'Deep Focus' playlists while coding
  • Local Manchester running groups on Strava

Questions & answers

Lisa Hoeger’s public research answers, newest questions first. Up to 10 per page.

  1. Looking at Tabularis (https://tabularis.dev): what price would make it a no-brainer for you, and at what price would you stop considering it? What would you expect to get for that money? Also say the maximum you would pay per month in USD (0 if nothing).

    I'm always looking for ways to make data cleaning more efficient, as that's a huge time sink for me. The SQL notebooks and visual explain features sound really promising, especially if they can help me get insights faster. Since I've never paid for a desktop SQL client, I'm not entirely sure what a fair price would be. However, if it could significantly cut down on my manual data prep time and make complex queries easier to understand, I'd consider paying around $10 to $15 per month. Anything over $25 a month would likely be too much, especially as it's a personal tool I'd be paying for out of my own pocket.
    View answer & full research →
Keep exploring

What would you ask next?

Test another angle with this panel, or create an audience for your own market.