Business Analytics
Create an Excel dashboard to catalogue motorcycle brands
Business analysts of small business spend a lot of time making the most of excel. Here is fun challenge for you - create a motorcycle catalogue.
Certified by
Role
Business Analyst
Industry
Automotive Retail
Menterns at work
2
Level
Intermediate
Time Commitment
60
Duration
60 days
Tools you’ll learn
Here’s What You Work On
About the Company
Kinetic started and continues to work with bold vision - A kinetic in every automobile in India. It is interesting to note that while most of us relate this brand with budget motorcycles, auto rickshaws and some heavier transport vehicles. Kinetic is also a major supplier of critical automobile parts to other automobile manufacturers like Tata and Mahindra. Kinetic aims to become the one-stop solution for all budget vehicles in the country.
Explore
the following work techniques
Advanced Analytics
MS Excel (Pivot VLookup IF condition)
Dashboard building
Learn more about our Menternship Principle
Bridging the gap
If you are looking to master advanced excel then cataloging and inventory management are two essential use cases that you must practice to get a handle on how to combine unusual formulas to get to a very efficient dashboard design. In this menternship, the challenge is to create a dynamic catalog dashboard and inventory management system that can be readily used by floor managers of any automobile showroom. Your responsibilities will also include designing a brief training module for managers so that they can use the dashboard created by you to enter new data as and when required and get required updates.
Apply
the following skills
Dashboard designing
Data Analysis
Data preparation
Hypothesis testing
Learn more about our Menternship Principle
Expected output
Design a dynamic catalog and inventory management dashboard using Advanced MS Excel functions
Create
the following deliverables
Workflow for data entry and management
A dynamic catalog and inventory management dashboard for automobile showrooms
Learn more about our Menternship Principle
What you’ll need before starting
Basics of MS Excel
Why Do Menternships?
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.
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.
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!
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!
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 dashboard to catalogue motorcycle brands
Business analysts of small business spend a lot of time making the most of excel. Here is fun challenge for you - create a motorcycle catalogue.
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