RR 338: Data Warehousing with Trae Robrock
Devchat.tv Episode Roundup
English - November 28, 2017 23:50 - 51 minutes - 47.1 MBHow To Education Business Careers programming javascript web framework development front end developer programmer internet node Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Panel:
Charles Max Wood
Dave Kimura
David Richards
Special Guest:
Trae Robrock
In this episode, the Ruby Rogues speaks with Trae Robrock. Trae is on Ruby Rogues to talk about his current business Green Bits. Green Bits creates point of sale (POS) inventory management software for the legal cannabis industry. Green Bits has been in business for the last 3 years since 2014, and they have launched alongside Washington states recreational program. Green Bits is functioning 7 states and is running 80% of the Washington market.
Trae explains about the real-time mapping built-in the tracking system in the APIs. Furthermore, Trae talks about the tracking system between the seed to the customer purchase. Lastly, Ruby Rogues digs deep and learn how the infrastructure works for a growing industry.
In particular, we dive pretty deep on:
The controversial company Green Bits
Schedule 1 drug
Banking with this business and industry
Cash-based business with no paper trail
Paper trail only on the product
Tracking data and finances
600 customer base
Track systems APIs
We are just a startup company starting a real business not potheads
Modeling Data
Naming system
Opening Replicator
Scaling the system
ETL - Sub 1 minutes times
Rebuilding databases
How long does it take to get up to speed?
Accounting knowledge
How do you get started with a Warehousing system like this?
AWS Lamda
Star Schema
and much much more.
Links:
Green Bits
Refactoring Patterns by Martin Fowler
[email protected]
@trobrock
Picks:
Trae
Dave
Beats Headphones
Charles
Hensal Minutes Podcast
.NetRocks
Two Keto Dudes
NYC
David
The 3 Important Things I know about Consumers I Learned From Bartending