Increasing Digital Footprint Mad Labs Vapor Ryan Cox

Increasing Digital Footprint Mad Labs Vapor Ryan Cox, Joelle Kabeya, Kenneth Nguyen, Brendan Perenchio

Team Background Artificial Clouds of Intelligence: ● Ryan Cox - Database (Team Lead) ● Joelle Kabeya - Analyst ● Kenneth Nguyen - Technical Writer ● Brendan Perenchio - UI/UX

Agenda ● ● ● ● Client Background Client Needs and System Requirements Solution Overview Mad Labs Database Mad Labs Website Implementation discussion Summary/lessons learned

Client ● Mad Labs Vapor (Denton, Tx) ● Sole proprietor - Adam Zavala ○ Several employees ● Heavily focused on customer service ● Inspired to help analog smokers find a healthy alternative ● Vape & Related Products ○ ○ Mods, Tanks, Accessories, Juice CBD oil & drops

Client Needs and System Requirements ● Online Web Presence ● Inventory Tracking ● Customer Relationship Management Software

Solution Overview ● Full Stack Website Server ○ UX/UI examples provided ● Local Database ○ ○ ○ Easy to manage Customizable Reasonable cost ● Inventory Tracking ○ Done through Database

Mad Labs Database ● Manipulate data related to CBD products ● Products and retail price are real ● Used for both front-end and back-end operations

Back-end Queries: For the Business ● Allows the business to run more efficiently ● Can track multiple processes ● Predicts patterns

Queries: Ordered & Sold ● Allows tracking of dates items were ordered and sold ● Can narrow to specific product or date ● See total number sold per day

Front-end queries: For the Customer ● Helps narrow a search for a product ● Remembers previous orders ● Customer notified of deals

Mad Labs Website https: //ci 6 ad 5. axshare. com

Implementation discussion ● Testing plan ○ ○ Custom development ■ Background check Packaged solution ■ Vendor check ● Pilot conversion style ● Training associates ● Documentation ○ Maintenance

Summary/lessons learned ● ● ● Relationship Management Database Architecture Fundamentals of Great UX/UI Design Technical Writing and Formatting Diagram Modeling