Welcome to the test :)

Please download the Test from the Onedrive Link.

Step 1 - Click on the below button

Step 2- Click on each file's 3 dots.

Step 3 - Download

If you are getting an error. Open this website in Incognito mode.

PS- You don't need to open the files in the browser. Just download it, please.

Please go through the instructions below very carefully.

Download

Contact

For submission or any queries,

please reach out directly

rose.sajan@dataroars.com

Read Carefully - For All Power BI Candidates

1. Understand the Requirements:

Carefully analyze the instructions for the Excel deliverables. All 3 tabs needs to be completed.

2. Quality Check:

Cross-verify your work to ensure it meets the given expectations.

3. Minimal Communication:

Avoid unnecessary questions unless clarification is critical. The assignment can be completed without any communication with me. It is one of the main objectives on which you are assessed.
Maintain independence in your workflow to showcase your ability to manage tasks. This will ensure that micromanagement won't be required after you are hired.

4. Delivery Mode:

Send files directly to rose.sajan@dataroars.com
Do not send links or zip files or Google Drive links.
Only 1 submission is allowed.
Excel = Excel file delivery only.

5. Delivery of Assignment Deadline:

Earliest Possible. Maximum 2 days from the day you start.

Test 1 - Excel

The yellow highlighted areas are where you need to provide the values.

All three tabs needs to be completed.

Reasons for Failure:

Common reasons are-

1. Late-delivery

2. Not much knowledge of the tool

3. Values are wrong

4. Instructions not followed

5. Asking for too much guidance. Lack of independence and ownership of work.

Detailed reasons below:

Excel -

1. Volume Tab:

Values don't match to the expected correct result.
Manual formulas such as "If" are used, or worse, manual logic has been applied.
Numbers are hardcoded without formulas.

2. Growth Tab:

Conditions not met correctly
Values don't match to the expected correct result.
Numbers are hardcoded without formulas.

3. NR Consolidation:

Values don't match to the expected correct result.
Manual formulas such as "If" are used, or worse, manual logic has been applied.
Numbers are hardcoded without formulas.

4. You haven't completed all three tabs.

Tips to succeed or perform better next time:

Excel -

Ask Yourself:

Is logical reasoning and problem-solving your passion?
Do you believe you can excel as a Data Analyst?
If your answer is yes, here’s how to improve:

1. Practice Core Functions: Dedicate time to mastering key Excel functions like:

VLOOKUP
SUMIFS
COUNTIFS
SUMPRODUCT
INDEX/MATCH

2. Use Free Resources:

The internet is full of free assignments and tutorials to help you practice.
Dive in and challenge yourself with real-world scenarios.