Data Preparation – Inventory Management System
Project scope
Categories
Data visualization Data analysis Data modelling Information technology DatabasesSkills
digital transformation inventory management data cleansing data modeling renovation data analysis sales customer relationship management warehousing operationsWhat you’ll do
You will assist Mayk with data preparation, including updates, analysis, remodeling, and validation, for multiple data sources related to product inventory and contact information for retail and assembly operations for an automotive electrical company.
Project Objective: Based on a new data model create prepare, analyze, remodel, and validate data sets (from excel data sources) to provide more complete inventory related data for ecommerce sales channels.
You are:
A learner or learners focused on digital transformation, databases, data analysis. data, technology, and creatives, you will dive into the following project.
This project is suitable for 1 or 2 teams of 4 people depending upon skills and industry background of candidates.
Data source: Excel. For this project there is approximately 4500 records in 7 inventory workbooks. Validation worksheets for part numbers, warehouse location. There are approximately 800 clients in the client and account data.
Tasks for this project:
1. Review data sources
2. Understand date sources (explanations, attributes, etc.)
3. Develop additional validation worksheets for data to support data cleansing and consistency
4. Update inventory with validated date
5. Update additional missing data
6. Provide standardized inventory data worksheets at end of project
7. Provide account and contact files for import into new customer relationship management system
Regular meetings and guidance from subject matter experts
About the company
We are Mayk Ideas - growth advisors and marketing creatives! Ingenuity without boundaries is at the heart of every strategy we envision and execute. We craft people-oriented, brand-building campaigns and business transformations that are intentional and value-driven. Our creative and venture acceleration services lead to measurable return on investment for the firms and brands we work with, as they are informed by data-driven strategies, good business sense, and meaningful connections. Our portfolio of clients includes professional and financial services, sports and entertainment, technology, automotive and other B2B brands. Our clients are growing and so are we!
Please note that the learner market and industry experience is important when selecting this project. Our process includes a review of the learner’s resume, learner transcript review and subsequent contract and NDA for selected candidates. We thank you for your interest!