![Page 1: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/1.jpg)
From Students…
…to Professionals
The Capstone Experience
Project PlanFord Mobility Product Metrics
Team FordYangkai He
Weilin LiangSamuel Wakeman
Romi Yun
Department of Computer Science and EngineeringMichigan State University
Fall 2019
![Page 2: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/2.jpg)
Functional Specifications
• Deliver Ford developers a convenient way to monitor API and website usage by communicating with a Slack or WebEx Teams chatbot
• Create a pixel tracker to analyze data from tracking pixels on web pages
• Visualize the pixel tracker data to view metrics configurable by product and time periods on a Grafana dashboard
The Capstone Experience Team Ford Project Plan Presentation 2
![Page 3: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/3.jpg)
Design Specifications
• WebEx Teams & Slack Chatbots
• Pixel Tracker: Analytical tool for tracking pixels
• Metrics Dashboard: Website to display visualized data
• Data Interface: Interface for pulling data from databases
The Capstone Experience Team Ford Project Plan Presentation 3
![Page 4: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/4.jpg)
Interactive ChatBot
The Capstone Experience 4Team Ford Project Plan Presentation
![Page 5: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/5.jpg)
Reports Chatbot
The Capstone Experience 5Team Ford Project Plan Presentation
![Page 6: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/6.jpg)
Grafana Dashboard
The Capstone Experience 6Team Ford Project Plan Presentation
![Page 7: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/7.jpg)
Pixel Tracker Mockup
The Capstone Experience 7Team Ford Project Plan Presentation
![Page 8: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/8.jpg)
Technical Specifications
• OpenPixel
• Slack/WebEx Teams API
• Grafana
• MySQL
• Chart.js
• Azure Log Analytics
• Chatbot engine
• Pixel Tracker
The Capstone Experience Team Ford Project Plan Presentation 8
![Page 9: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/9.jpg)
System Architecture
The Capstone Experience Team Ford Project Plan Presentation 9
![Page 10: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/10.jpg)
System Components
• Hardware Platforms▪ Ubuntu Server(rack)
• Software Platforms / Technologies▪ Ubuntu
▪ Azure
▪ MySQL
▪ MacOS
▪ Web platform
The Capstone Experience Team Ford Project Plan Presentation 10
![Page 11: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/11.jpg)
Risks
• Risk 1▪ How do we make a chatbot engine? ▪ Created a basic chatbot to become familiar with it
• Risk 2▪ The chatbot may not recognize every question the user asks▪ Train and test the chatbot in addition to implementing fuzzy
string matching
• Risk 3▪ Collecting bad pixel tracker data (i.e. web crawler)▪ Create a filter to analyze the metadata (i.e. timesamps, UID)
• Risk 4▪ Malicious access of MySQL database through data leaks▪ Create a firewall to limit the IP addresses
The Capstone Experience Team Ford Project Plan Presentation 11
![Page 12: Project Plan Ford Mobility Product MetricsProject Plan Ford Mobility Product Metrics Team Ford Yangkai He Weilin Liang Samuel Wakeman Romi Yun Department of Computer Science and Engineering](https://reader031.vdocuments.us/reader031/viewer/2022040612/5f052db27e708231d411aa3f/html5/thumbnails/12.jpg)
Questions?
The Capstone Experience Team Ford Project Plan Presentation 12
?
? ??
?
?
?
?
?