le wagon - product specs 101
TRANSCRIPT
![Page 1: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/1.jpg)
Product Specs 101
@bpapillard
![Page 2: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/2.jpg)
Why this workshop?
2 common mistakes
![Page 3: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/3.jpg)
Vague
![Page 4: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/4.jpg)
Too Specific
![Page 5: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/5.jpg)
1) Product pitch 2) Mockup 3) DB scheme 4) User stories
4 simple steps
![Page 6: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/6.jpg)
vision design
architecture features
1) Product pitch 2) Mockup 3) DB scheme 4) User stories
4 simple steps
![Page 7: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/7.jpg)
Different languages to speak
![Page 8: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/8.jpg)
Architecturebackend development
![Page 9: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/9.jpg)
Designfrontend development / UI / UX
![Page 10: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/10.jpg)
Featuresproduct management
![Page 11: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/11.jpg)
YOU
![Page 12: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/12.jpg)
“We got the best goddamn product so we gonna sell no matter where we are, right? Product, motherf*ckers. Product.”
1) Product Pitch
Stringer Bell
![Page 13: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/13.jpg)
Target Who are my customers?
Pain
What do they suffer from?
Solution How do I answer their need?
![Page 15: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/15.jpg)
2) Live Mockup
![Page 16: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/16.jpg)
3) DB scheme
![Page 17: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/17.jpg)
Focus on core tables
![Page 18: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/18.jpg)
Example
![Page 19: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/19.jpg)
users
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 20: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/20.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 21: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/21.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 22: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/22.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 23: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/23.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 1
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 24: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/24.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 25: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/25.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 3
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 26: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/26.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 27: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/27.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 28: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/28.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
a user has many products
a product belongs to one user
1..N relationship
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 29: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/29.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
primary key primary key foreign key
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 30: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/30.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
upvotes
id user_id product_id date
![Page 31: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/31.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
upvotes
id user_id product_id date1 3 2 17/10/15
![Page 32: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/32.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
upvotes
id user_id product_id date1 3 2 17/10/152 3 1 15/11/15
![Page 33: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/33.jpg)
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
upvotes
id user_id product_id date1 3 2 17/10/152 3 1 15/11/153 2 1 20/01/16
![Page 34: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/34.jpg)
1..Na user has many upvotes
1..Na product has many upvotes
upvotes
id user_id product_id date1 3 2 17/10/152 3 1 15/11/153 2 1 20/01/16
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
![Page 35: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/35.jpg)
a product has many users through upvotes
a user has many products through upvotes
N..N relationship
users products
id name url user_id1 LovelyHood lovely-hood.com 22 Kudoz getkudoz.com 13 uSlide uslide.io 34 Freshest frshst.com 2
id username email1 olivier [email protected] edward [email protected] vincent [email protected]
upvotes
id user_id product_id date1 3 2 17/10/152 3 1 15/11/153 2 1 20/01/16
![Page 37: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/37.jpg)
4) User Stories
As a … , I can …
![Page 38: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/38.jpg)
As a … , I can …
user upvote a product
user post a product
visitor signup
![Page 39: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/39.jpg)
As a … , I can …
owner accept / refuse a booking
user add / book a flat
visitor signup
![Page 40: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/40.jpg)
User Stories
![Page 42: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/42.jpg)
Your Turn!
1) Product pitch 2) Mockup 3) DB scheme 4) User stories
![Page 43: Le Wagon - Product Specs 101](https://reader034.vdocuments.us/reader034/viewer/2022042611/5871ac851a28abda6a8b5b2f/html5/thumbnails/43.jpg)
Thank you