Business Analyst for Business Intelligence

Topics covered

logistic concepts, microsoft office, database, SQL, SDLC, Analytical thinking, operations concepts, written communication

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

A Business Intelligence Business Analyst mainly works on functional specifications for their customers and accordingly prepare reports and analytical solutions. 

The Business Intelligence Business Analyst Test has is designed mainly to assess the candidate in the areas of dimensional data modelling knowledge, data interpretation, strong analytical and problem solving skills, documentation of data flow and system diagrams, designing reporting instruments and excellent interpersonal skills. This test consists of meaningful questions on logistic concepts, microsoft office, database, SQL, SDLC, Analytical thinking, operations concepts, written communication and many more. 

Using powerful reporting, you will have detailed analysis of test results to help you make better decisions and predict candidate and employee success. 

This pre-employment test is useful for hiring:
  • Senior Business Intelligence Business Analyst (1-3 years experience)
  • Junior Business Intelligence Business Analyst (0-2 years experience)

Test details:

The test enables employers and recruiters to identify potential hires by evaluating working skills and job readiness. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge. 

Questions - 30
Duration - 30 minutes 
 

  • Business Analyst: 10 Questions 10 minutes

  • Business Objects & Databases: 10 Questions 10 minutes

  • Analytical Thinking: 5 Questions 5 minutes

  • Writing Skills: 5 Questions 5 minutes

Business Intelligence Analyst Test

Question #1 of 2

You are a Business Analyst at BD Bank. You are involved in a software project that is replacing an out-dated, inefficient legacy system (System X) with an efficient, process-driven web-based solution. There are however a number of challenges facing the project team. 

The project has requested a detailed stakeholder matrix. You have documented the stakeholder matrix in the RACI format. The stakeholder matrix identifies several key stakeholders. 

RACI legend:
Responsible - Those who do the work to achieve the task. 
Accountable - Signs off various project outputs and ensures thorough completion of each task
Consulted - Required to provide feedback on documents / in workshops.
Informed - Kept up to date on progress. 



Which of the following statements is not correct pertaining to the Business Analyst’s responsibilities as documented in the RACI matrix?

    • The business analyst will provide input into the development process and support the senior developer

    • The business analyst will document the Functional Requirement specification in accordance with the project governance principles

    • The business analyst will analyse the documented process and provide feedback to the stakeholders

    • The business analyst will send project progress communications to project stakeholders

Question #2 of 2

You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?

    • =[Revenue]/RefValue([Revenue])

    • =[Revenue]/PreValue([Revenue])

    • =[Revenue]/HistValue([Revenue])

    • =[Revenue]/BaseValue([Revenue])

SAMPLE REPORT
Candidate Name: David Messi Test Date: 28-May-2014
Test Name: Business Intelligence Analyst Test Test Start Time: 13.30

Score: 23 Out Of 30

Percentage: 76

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
Analytical Thinking
Score: 5/5
Writing Skills
Score: 2/5
Business Objects & Databases
Score: 7/10
Business Analyst
Score: 9/10
STRENGTH AND WEAKNESS
Strength Analytical Thinking, Business Analyst
Weakness Writing Skills
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
ONLINE PROCTORING
0%
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
CANDIDATE DETAILS
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : Analytical Thinking, Business Analyst Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo