Skip to content

Analyst Case Interview - Grade Sheet

Questions

Questions the candidate should ask

  • About Salesonite
    • How big are they (turnover, employees, etc.)
    • Do they have different offices?
    • How many products?
    • Are they growing?
  • About Clients
    • top Kunden?
    • B2B? B2C, etc.
  • Business model
    • Do they produce their goods? (no, they have suppliers)
    • Sales Conditions? (yes, based on turnover, for some suppliers, )
    • Stock/Warehouse?
    • Online shop?
    • What is the margin?
    • Which products have high/low margin?
    • Top product
    • Sales Process
  • About Dimensions
    • Clients
    • Regions
    • Products and Product Groups
  • About KPIs
    • What is interesting (Sales, Margin, Units)
    • Time periods (monthly, yearly)
    • Comparison (same period last year)
    • Sales Targets?
  • Non-functional requirements
    • daily refresh?
  • About Systems
    • What IT systems do they use?
    • Is the data up to date?
    • On-Prem?
    • API?
    • IT Partner?
  • Data
    • Historic data? (Since when do they have their system?)
  • About their experience with KPIs and data literacy
    • Do they already have a BI system in place?
    • Do they systematically track numbers and data for other business areas?

Evaluation

Area Achievements Maximum Points
Problem Did the candidate ask relevant questions before starting a design? 1
Problem Did the candidate correctly identify the problem of the CEO? 1
Data Sources Did the candidate correctly identify the data sources? 1
Data Access Did the candidate ask relevant questions about the data sources? E.g. how we can access the data. 1
KPI Did the candidate define a KPI that we want to track 1
Wireframe Did the candidate design a wireframe that will solve the problem? 1
Estimate Did the candidate come up with a reasonable estimate? 1
Estimate Was the estimate detailed, and split into efforts for different areas? 1
Consulting Skills Did the candidate help the CEO to improve his ideas, without lecturing or patronizing? 1
Consulting Skills Was the candidate honest about his knowledge and skills? 1
Total 10