Data Science
Create an Excel dashboard to catalogue motorcycle brands
Design a dynamic motorcycle catalog and inventory management dashboard using Advanced MS Excel
About this Menternship
Opportunity:
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. 


Problem:
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. 

Deliverable:
Design a dynamic catalog and inventory management dashboard using Advanced MS Excel functions 
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:
A dynamic catalog and inventory management dashboard for automobile showrooms


Expected Output
  1. Present your vision for an ideal catalog and inventory system
  2. Dynamic dashboard for catalog and inventory management of an automobile showroom
  3. Video of Self
Create an Excel dashboard to catalogue motorcycle brands
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!