BA SKILLS + TOOLS Flashcards
What tools do you use for requirement gathering and management?
- JIRA, Confluence, Trello.
- Microsoft Excel, Microsoft Word.
- Visio for process mapping.
What software tools do you use for process modeling?
- Microsoft Visio.
- Lucidchart.
- BPMN tools (e.g., Draw.io, Bizagi).
How do you conduct data analysis for business insights?
- Excel for pivot tables and VLOOKUP.
- SQL for querying databases.
- Tableau/Power BI for visualizations.
What testing tools are you familiar with for UAT or system testing?
- Selenium.
- TestRail.
- JIRA for tracking test cases.
What project management tools have you used?
- Microsoft Project.
- Asana.
- Monday.com for task tracking.
How do you document requirements effectively?
- Use user stories, use cases, and functional requirements documents.
- Ensure clarity and include acceptance criteria.
- Validate documents with stakeholders.
What diagramming tools do you use for workflow visualization?
- Microsoft Visio.
- Draw.io for quick diagrams.
- Lucidchart for collaboration with teams.
What SQL skills do you use in your BA role?
- Writing SELECT queries for data retrieval.
- Using JOINs to combine multiple tables.
- Aggregating data with GROUP BY and filtering with WHERE.
How do you use Excel in your business analysis work?
- Create pivot tables for data analysis.
- Use formulas like VLOOKUP, SUMIF, and INDEX/MATCH.
- Build charts and graphs for data presentation.
What is your experience with Agile frameworks like Scrum?
- Participate in sprint planning, daily stand-ups, and retrospectives.
- Write user stories and prioritize backlog.
- Work closely with product owners and development teams.
What methodologies do you use for process improvement?
- Six Sigma for identifying inefficiencies.
- Lean principles to eliminate waste.
- Use root cause analysis for problem-solving.
What wireframing tools do you use for UI/UX design?
- Balsamiq for low-fidelity wireframes.
- Sketch for higher fidelity designs.
- Adobe XD for collaborative UI/UX design.
How do you prioritize tasks in a project?
- Use MoSCoW prioritization (Must, Should, Could, Won’t).
- Collaborate with stakeholders to align priorities with business goals.
- Regularly reassess priorities based on project progress.
What techniques do you use for stakeholder management?
- Conduct stakeholder mapping to identify influence and interest.
- Use regular updates and feedback loops for engagement.
- Address concerns early to build trust and buy-in.
What change management practices do you follow?
- Implement a structured change request process.
- Assess the impact of changes on timelines, costs, and scope.
- Communicate changes to all stakeholders to ensure alignment.
What documentation do you typically create as a BA?
- Requirements documentation, use cases, and business cases.
- Functional and non-functional specifications.
- Test cases for user acceptance testing.
How do you approach gap analysis?
- Identify the current state and desired future state.
- Highlight gaps in processes or systems.
- Recommend solutions to bridge the gaps.
How do you ensure data integrity in your analysis?
- Perform data validation checks.
- Cross-check data sources for consistency.
- Use automated data entry and audit tools.
What CRM systems have you worked with?
- Salesforce for customer management.
- Microsoft Dynamics CRM.
- HubSpot for marketing automation.
How do you facilitate requirement workshops?
- Prepare an agenda and key objectives.
- Use brainstorming or focus group techniques for input.
- Document outcomes and decisions clearly.
What KPIs do you commonly track for business performance?
- Revenue growth and profit margins.
- Customer satisfaction and churn rate.
- Process efficiency and cycle time.
What ERP systems have you worked with?
- Oracle ERP Cloud.
- ERPNext for small and medium-sized businesses.
- MS Dynamic 365 for enterprise resource planning.
What prototyping tools do you use?
- Figma for UI prototypes.
- InVision for interactive designs.
- Axure for more complex, high-fidelity prototypes.
What risk management tools or frameworks do you use?
- SWOT analysis for identifying risks and opportunities.
- Risk matrices for assessing likelihood and impact.
- Microsoft Project for tracking risk management plans.