Business Analytics

Create an excel-based client relationship management tracker and dashboard for professional fitness coaches at Xtraliving

Can an Excel dashboard help you excel at your fitness goals? It can actually. Start with menternship for practicing MS Excel and exploring the world of fitness coaching

Certified by

Role

Business Analyst

Industry

Food & Beverage

Menterns at work

Level

Intermediate

Time Commitment

Submit First Draft in 30 days

Duration

60 days

Tools you’ll learn

Here’s What You Work On

About the Company

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.

Explore

the following work techniques

Advanced Analytics

MS Excel (Pivot VLookup IF condition)

Dashboard building

Learn more about our Menternship Principle

Bridging the gap

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.

Apply

the following skills

Dashboard designing

Data Analysis

Data preparation

Hypothesis testing

Learn more about our Menternship Principle

Expected output

Use advanced MS Excel functions to create an automated fitness tracker and dashboard for clients of Xtraliving

Create

the following deliverables

Needs assessment of fitness tracker requirements of coaches and clients

An automated excel dashboard for tracking and monitoring fitness activity and goals

Learn more about our Menternship Principle

What you’ll need before starting

Advanced Excel

Why Do Menternships?

Build Real Skills by doing work, by experience.

Each Menternship experience is powered by the MentorMind experiential learning model. We empower you as a Mentern to produce your own unique real work output through mentoring, deep-learning & applying your learnings to work.

Do Real Work that matches corporate expectations.

All our Menternships are co-created with companies. They are designed for real-time work in the corporate function which allows all levers of a work experience to flourish in your Menternship experience.

Get active guidance from Real Mentors.

You get access to a guild of industry mentors with remarkably diverse experience in their fields. Mentors help you with expert advice, domain guidance or to understand a specific task better. Moreover, you can always depend on our community of menterns, MentorMind Garage, to seek assistance from your co-menterns, guides & mentors!

Showcase your Official Certification.

Successfully completing a Menternship is no less that having practical, hands-on work experience. You earn a Certificate of Recognition from the Menternship partner company which can be showcased on your CV or your LinkedIn as a proof of your real skills!

Become a member of the Mentern Perks Club.

As a Certified Mentern you earn a spot in the exclusive Mentern Perks Club, a MentorMind community that opens up networking amongst menterns from across the globe. MentorMind empowers the community with our amazing Perks Club guides, Do-With-Us workshops & access to work opportunities with our Corporate Partners!

Meet Our Certified Menterns

It was amazing! I learnt so many things like creating engagement on social media platforms. The 1:1 with mentors were super helpful. I learnt how to create Instagram ads, identify goals & do competitor analysis- so many things.

There was a lot of interactive sessions with Mentors. The Menternship I completed gave me a new perspective to how work has to be done. I truly enjoyed working with real figures & actual industry case studies.

My experience was great as I got a chance to explore subjects like Analytics which are difficult to look for. The Menternship allowed to get subject knowledge and see what goes behind the making and delivering of a product.

My experience was very useful as I learnt so much about Fleet Management & Digital Marketing connected to the real-world scenario. I learnt how to actually work with social media channels like IG & Facebook.

Create an excel-based client relationship management tracker and dashboard for professional fitness coaches at Xtraliving

Can an Excel dashboard help you excel at your fitness goals? It can actually. Start with menternship for practicing MS Excel and exploring the world of fitness coaching

Explore our curated Resource Hub

Get Guidance in One-on-One Mentor Hours

Ask Questions in our Biweekly AMA

Resolve all doubts on Mentor Support Chatbox

Get Actionable Mentor Feedback on your work

Learn & Network at the exclusive Mentern Perks Club