Be ready to go over:

• Basic Data Extraction – Writing SELECT statements, filtering data with WHERE clauses, and sorting results using ORDER BY.
• Data Aggregation – Utilizing GROUP BY and HAVING clauses alongside functions like COUNT, SUM, AVG, MIN, and MAX.
• Table Joins – Combining data from multiple tables using INNER, LEFT, RIGHT, and FULL OUTER joins.
• Advanced concepts (less common) – Writing subqueries, common table expressions (CTEs), and basic window functions for ranking data.

Example scenarios:

• "Write a query to combine a customer profiles table with a transactions table to find the total revenue generated by customers in Canada."
• "Construct a query that returns the names of all products that have never been purchased by any customer."

Logical Puzzles and Analytical Approach

The final stages of the technical evaluation often include random logical puzzles. The primary objective here is not to see if you know the answer beforehand, but to evaluate your structured approach to problem-solving under pressure.

Be ready to go over:

• Guesstimates – Breaking down large, ambiguous estimation problems into logical formulas and assumptions.
• Mathematical Puzzles – Solving classic logic, weighing, and water-jug puzzles using structured steps.
• Framework Application – Explaining your thought process out loud, outlining your assumptions, and validating your final answer.

Example scenarios:

• "How would you estimate the number of active users on a public transit app in a major metropolitan city on a weekday?"
• "Walk me through your step-by-step approach to solving the classic 3-liter and 5-liter water jug puzzle."

Personal Interview (PI) and Behavioral Fit

The PI round is the final step in the evaluation process. It is a comprehensive conversation designed to evaluate your professional background, communication style, and cultural alignment with the Freshworks team.

Be ready to go over:

• SaaS Business Acumen – Demonstrating familiarity with key SaaS metrics such as churn, customer acquisition cost (CAC), and customer lifetime value (LTV).
• Conflict Resolution – Describing how you handle disagreements with stakeholders or team members regarding data interpretations.
• Adaptability – Explaining how you manage changing priorities and tight deadlines in a dynamic work environment.

Example scenarios:

• "Tell me about a time when your analysis revealed an unexpected business trend, and how you communicated this discovery to your team."
• "Describe a project where you had to collaborate with a cross-functional team of engineers and product managers to achieve a common goal."

As a Business Analyst at Freshworks, your daily activities will center around transforming data into strategic insights. You will collaborate closely with cross-functional teams, including product management, sales operations, marketing, and customer success, to support data-driven decision-making.

Your primary responsibilities will include:

• Developing and Maintaining Dashboards – Designing, building, and updating automated dashboards in Excel or business intelligence tools to track key performance indicators (KPIs) for various business units.
• Conducting Ad-Hoc Data Analysis – Querying databases and analyzing datasets to answer urgent business questions, identify trends, and diagnose operational bottlenecks.
• Collaborating with Cross-Functional Teams – Partnering with product and sales leaders to understand their data needs, scope analytical projects, and deliver actionable recommendations.
• Ensuring Data Governance and Accuracy – Validating data sources, identifying inconsistencies, and working with data engineering teams to maintain clean, reliable data pipelines.
• Translating Data into Business Narratives – Synthesizing complex analytical findings into clear presentations and reports for executive leadership and non-technical stakeholders.

To be competitive for the Business Analyst role at Freshworks, you should possess a strong blend of technical expertise, analytical capabilities, and interpersonal skills.

Technical Skills

• Advanced Excel – Exceptional proficiency in Excel, including advanced lookup functions, aggregate formulas, pivot tables, data visualization, and complex model building.
• SQL Fundamentals – Strong capability in writing SQL queries to extract, clean, and analyze data from relational databases.
• Data Visualization – Experience with BI tools such as Tableau, Power BI, or similar platforms is highly valued.

Experience and Soft Skills

• Professional Background – Prior experience in a business analyst, data analyst, or consulting role, ideally within a SaaS or technology environment.
• Structured Communication – The ability to clearly articulate complex analytical concepts to both technical and non-technical audiences.
• Problem-Solving Mindset – A strong logical approach to breaking down ambiguous business challenges and developing structured solutions.

Qualifications Summary

• Must-have skills – Advanced Excel proficiency, SQL query writing, structured problem-solving, and strong verbal and written communication.
• Nice-to-have skills – Experience with BI visualization tools, familiarity with SaaS business metrics, and basic knowledge of programming languages like Python or R.

Q: What is the overall difficulty level of the Business Analyst interview at Freshworks? A: Candidates generally describe the interview process as average to difficult. The technical rounds, particularly those focusing on hands-on Excel testing and logical puzzles, are rigorous and require thorough preparation.

Q: How long does the entire interview process take? A: The process is exceptionally smooth and punctual, typically taking about three weeks from the initial HR screen to the final offer rollout and background verification.

Q: What is the "PI Round" mentioned in the interview experiences? A: The PI (Personal Interview) round is the final stage of the process. It focuses on your professional background, behavioral competencies, problem-solving approach, and cultural fit with Freshworks.

Q: How important is SQL for this role if I am highly proficient in Excel? A: While Excel is the primary tool tested, basic SQL knowledge is highly recommended. If you do not have extensive SQL experience, be honest with your interviewer; they will assess your logical thinking and learning agility.

Q: Does Freshworks provide timely feedback during the process? A: Yes. Candidates consistently report that the recruitment team is highly punctual, communicative, and provides quick feedback after each interview round.

To maximize your chances of success during the Freshworks hiring journey, consider the following practical tips:

• Practice Excel Hands-On: Do not just read about Excel functions; practice building models, resolving circular references, and creating charts under timed conditions.
• Be Honest About Your Technical Skills: If you do not know a specific SQL function or technical concept, admit it. Freshworks interviewers value honesty and will evaluate your logical approach to learning.
• Think Out Loud During Puzzles: When presented with a logical puzzle, talk through your thought process. The interviewer is assessing your structured approach and analytical methodology, not just your final answer.
• Prepare for the Background Verification (BGV): Because Freshworks has a highly structured onboarding process, ensure your professional references and documentation are organized and ready for the background check.

The Business Analyst position at Freshworks offers an exceptional opportunity to drive data-backed strategies at one of the world's leading SaaS companies. By working closely with cross-functional teams, you will directly influence how products are developed, how customers are supported, and how the business scales globally.

To succeed in this interview process, focus your preparation on mastering Excel fundamentals, practicing basic SQL queries, and refining your structured problem-solving skills for logical puzzles. Combine this technical preparation with clear, concise communication during your behavioral and personal interview rounds to demonstrate that you can translate complex data into business value.

The salary insight module above provides context on the competitive compensation packages offered by Freshworks. Use this data to align your expectations and prepare for the final offer discussions. For more detailed interview preparation resources, real candidate insights, and practice questions, explore the comprehensive tools available on Dataford to give yourself a competitive edge. Good luck with your preparation!