Data Science
Create an excel-based client relationship management tracker and dashboard for professional fitness coaches at Xtraliving
 Create an excel-based client relationship management tracker and dashboard for professional fitness coaches at Xtraliving 
About this Menternship
 Opportunity:
Xtraliving trains people of all ages to be their fittest and healthiest version. They are a fitness company that hosts group and solo sessions for adults and kids online, and run an offline fitness center called X60 CrossFit. At the heart of Xtraliving’s online programs are one-to-one fitness mentoring which includes goal setting, regular monitoring and tracking of goals, need-based mentoring and celebration of milestones. 
Xtraliving ensures a standardized experience for all trainees on their apps and gym by basing all of their training on common principles of healthy nutrition and CrossFit exercising. 

Problem:
Fitness platforms like Xtraliving rely on excel-based fitness plans and trackers for their clients. In the early days of the platforms, as the tech product is still evolving - low-tech excel spreadsheets help trainers share fitness plan, monitor progress and base their coaching decision on data. New age fitness is a very data-centric industry as the emergence of wearable fitness trackers enables precise data collection like never before. Now our fitness coaches can help us track how a change in our exercising and diet habits has an immediate impact on our resting heart rate and sleep - both of which in turn boost our long-term health and immunity. However, with this great opportunity comes the great challenge of collecting, monitoring and using this data in an efficient manner. This is where an ingeniously design Excel-based tracker can solve this business challenge.

Deliverable:
Use advanced MS Excel functions to create an automated fitness tracker and dashboard for clients of Xtraliving 
Why take up this Menternship?
On completing this Menternship, you will learn about
You will explore: 
Advanced Analytics
MS Excel - Pivot, VLookup, IF condition, and Dashboard building

You will apply:
Database management
Data visualization

You will create:
An automated excel dashboard for tracking and monitoring fitness activity and goals 
Expected Output
  1. Present your vision for an ideal fitness tracker
  2. Live tracker and dashboard for tracking fitness goals
  3. Video of Self
Create an excel-based client relationship management tracker and dashboard for professional fitness coaches at Xtraliving
Build Real Skills through practical experience.
Each Menternship is rooted in MentorMind's experiential learning model that guides you on how to apply all theoretical learnings into real world practice at work.
Do Real Work that matches corporate expectations.
Every Menternship is specially designed on real work that is done in the field at the company. All work outputs you are guided to produce over the duration & different phases of a Menternship will match corporate expectations.
Showcase your Official Certification.
You get officially certified by our partner company on successfully completing a Menternship. Simply add it on your CV and your LinkedIn as a proof of your real skills & work experience to gain a headstart in opportunities that come your way!