Welcome to the test :)

Please download the Test from the Onedrive Link

Download

Contact

For submission or any queries,

please reach out directly

nitin@dataroars.com

+91-9717390165

Read Carefully - For All Power BI Candidates

1. Understand the Requirements:

Carefully analyze the instructions for the Power BI and Excel deliverables. Both test needs to be completed.

2. Quality Check:

Cross-verify your work to ensure it meets the given expectations.
Perform a final comparison between your deliverables and the sample/reference provided.

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:

Deliver it directly where we have communicated. Do not send links or zip files.
Send files directly to nitin@dataroars.com
Only 1 submission is allowed.

5. Delivery of Assignment Deadline:

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

Test 1 - Excel

Before we do big things in Power bi, is our basics clear? Lets brush up our Excel first

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

All three tabs needs to be completed.

Test 2 - Power Bi

There is a requirement file provided in the test download for Power Bi.

The values, color, design, and, format of the dashboard should exactly match from the below 3 pages dashboard pages.

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.

Power BI -

1. First Tab:

Values don't match to the expected correct result as provided above. Incorrect Net Revenue or G2N calculation. Any incorrect value shouldn't be there.
Formats like $ or such basic small details don't match.
Colors don't match.
Charts are missing. Only for Sunburst chart, substitute to Pie charts is permissible.
Filter not set to Tea category.

2. Second Tab:

Values don't match to the expected correct result as provided above.
Formats like $ or such basic small details don't match.
Colors don't match.
Charts are missing.

3. Third Tab: (Most critical tab)

Values don't match to the expected correct result as provided above.
Values not in Millions.
Formats like $ or such basic small details don't match.
Colors don't match.
Charts are missing.
NR Share% is not dynamic. Any chart for that matter, if it is dynamic, then it is not an acceptable solution.
Months are not in proper chronological order.

4. Lack of Calendar table used for time-intelligence functions.

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.

Power BI -

You might think you’re a quick learner and have eased through challenges in life. But Power BI demands more—it rewards persistence, depth, and curiosity.

1 . Do more and more assignments. And don't stop there.

2. Automate all the work you have done. Now think can it be automated more? The answer is mostly always 'yes'

3. Forget Certifications and Theory:

They might look good on a resume, but Power BI is all about practical, hands-on experience.
Build dashboards, explore real-world datasets, and solve complex problems.

4. Focus on What Matters:

You don’t need to master every DAX formula, but you should know the ones that will help you succeed, such as:
- CALCULATE and its pairing with filters.
- Filter functions like ALL, ALLEXCEPT, and ALLSELECTED