YBI Data Detective Challenge — Aarunya Renewables
Step into a practical renewable-energy business challenge. Understand the business, analyse the supplied Q3 (July–September) data, verify your findings and submit an evidence-based solution.
Analyse a renewable-energy business through actual work
Aarunya Renewables serves residential, small-business and commercial customers with Rooftop Solar, Solar + Battery and Commercial Solar solutions.
Company & Business Context
Aarunya Renewables supports customers through consultation, solution design, installation coordination, maintenance and performance monitoring.
Management wants a clearer evidence-based view of Q3 (July–September) performance across regions, cities, products, customer segments, discounts, costs, profitability, installation progress and customer experience.
Who Can Participate?
- B.Tech, BCA, MCA, BBA, MBA and related college learners.
- Beginners who want practical exposure to business data analysis.
- Learners using Microsoft Excel or Google Sheets.
- Students who want to build evidence of what they can do through actual challenge work.
Turn business data into evidence-based findings
Investigate
- Sales & profitability
- Discounts & costs
- Regions & cities
- Products & customer segments
- Installation status
- Customer ratings
Produce
- Visible working, calculations and summaries
- At least 2 meaningful, readable charts
- Exactly 3 key findings
- Exactly 1 unusual observation
- Exactly 2 practical recommendations
Understand → Do the Work → Check → Submit → Mentor Evaluation → Showcase
Welcome to the Challenge
Understand how the challenge works, the milestones and the recognition journey.
Meet the Company
Learn about Aarunya Renewables, its solutions, customers, operations and key business leaders.
Your Business Challenge
Understand the business problem, stakeholder ask, learner role, resources and expected work.
Level 1 — Understand the Problem
Review the Company Profile, Challenge Brief and Data Dictionary, then complete the Level 1 Task.
Do the Work
Analyse the official Q3 Business Workbook in Excel or Google Sheets and keep your working file ready.
Level 2 — Check Your Solution
Use your completed analysis to answer the Level 2 Task and verify your findings.
Submit Your Solution
After Level 2 is cleared, submit your completed workbook and Findings Summary.
Mentor Evaluation
Submitted work may be reviewed for quality, Merit and further challenge recognition.
Showcase
Present your achievement accurately, build portfolio evidence and keep practising through future challenges.
Level 1 — Understand the Problem
10 questions shown randomly.
Minimum 6 correct answers out of 10.
Earned after successful Level 1 completion.
Do the Work
- Review the Business Data and Data Dictionary.
- Use formulas, filters, summaries and comparisons.
- Use pivot-style analysis where helpful.
- Create at least two meaningful charts.
- Record evidence-based observations in the Findings Summary.
- Keep your working file ready for Level 2.
Level 2 — Check Your Solution
- 20-question bank; 10 shown randomly.
- Pass > 50% — minimum 6 correct out of 10.
- Questions require completed analysis.
- You may refer to your own working file.
- Clearing Level 2 unlocks final solution submission.
Your completed workbook should show the work
Final submission
- Completed Excel workbook (.xlsx) or accepted Google Sheets equivalent
- Visible working, calculations, summaries and analysis
- Minimum 2 meaningful, readable and clearly labelled charts
- Clear workbook structure and labels
Findings Summary
- 3 key findings
- 1 unusual observation
- 2 practical recommendations
Every statement should be supported by evidence from your analysis.
Your progress is recognised by milestone
| Milestone | Recognition |
|---|---|
| Clear Level 1 | YBI National Challenge — Participation Certificate |
| Clear Level 2 + valid final submission | YBI National Challenge — Completion Certificate |
| After Mentor Evaluation | High-quality work may receive Completion with Merit |
| Outstanding work | May receive Finalist, Winner or relevant Special Recognition |
Mentor Evaluation
After valid final submission, the work may be considered for Mentor Evaluation. Mentors may review:
- Correctness
- Completeness
- Quality of analysis
- Clarity / presentation
- Interpretation
- Recommendations
Tools & Resources
- Microsoft Excel or Google Sheets
- Company Profile
- Challenge Brief
- Q3 (July–September) Business Workbook
- Business Data
- Data Dictionary
- Analysis Workspace
- Findings Summary
AI-Assisted Policy
AI may be used to help understand formulas, clarify concepts or troubleshoot. You remain responsible for verifying every result, understanding the analysis and submitting work that reflects your own reasoning and effort.
LinkedIn & Portfolio Guidance
- After valid final submission, download the Challenge Completion Certificate.
- Share the achievement on LinkedIn if you choose.
- Describe accurately what you analysed, built, solved and learned.
- You may tag the official YBI Foundation page so the team can notice and acknowledge your effort.
- Use appropriate challenge work as portfolio evidence.
- Do not present the challenge as employment, an internship, hiring or an interview.
- A LinkedIn recommendation is not promised.
Common questions
Who is this challenge for?
College learners including B.Tech, BCA, MCA, BBA, MBA and related programs who want practical business-data experience.
Which tools can I use?
Microsoft Excel or Google Sheets.
Do I need advanced data-analysis experience?
No. The challenge is beginner level, but you are expected to complete the practical work yourself.
How does Level 1 work?
Level 1 checks understanding of the company, problem, stakeholders, resources and required work. Ten questions are shown from a 20-question bank; more than 50% is required to pass.
What happens after I clear Level 1?
You earn the Challenge Participation Certificate and move into the Do the Work phase.
What does Level 2 check?
Level 2 checks findings and outputs that should be available only after you complete the actual analysis.
What do I submit at the end?
A completed Excel workbook or accepted Google Sheets equivalent with working, summaries, at least two meaningful charts and the required Findings Summary.
When do I earn the Completion Certificate?
After Level 2 is cleared and a valid final solution is submitted.
How does Merit work?
High-quality submitted solutions may receive Completion with Merit after Mentor Evaluation. It is not automatic.
Can I use AI?
Yes, for understanding and troubleshooting. You must verify the output and take responsibility for your final work.
Can I share the challenge on LinkedIn?
Yes. Share the achievement accurately, describe what you analysed or built, and tag the official YBI Foundation page if you choose.
Does this guarantee an internship, interview or job?
No. Participation does not create an employment relationship and does not guarantee an internship, interview, hiring or job opportunity.
Ready to test your skills through actual work?
Take the YBI Data Detective Challenge — Aarunya Renewables.