Tools for your Next Data Project

Ever wondered how to go about building your data analytics platform? Well, I went on a mission to explore this unknown world

Transcript

1. TOOLS FOR YOUR NEXT DATA PROJECT
2. ABOUT ME?  CTO @ourMshule  Co-organizer @EdTechNairobi | Lead Developer @arcturuske  Laravel specialist |Open-source advocate | New technologies geek | Future Astronaut “@OtienoJulie1”
4. COOL DOCKER APPS  Portainer  MySQL 8.0  Metabase  Cachet  Cuttlefish  Fathom Analytics
5. PORTAINER.IO Portainer IS HOW TO DOCKER ON PRODUCTION FOR DUMMIES Portainer is an open-source lightweight management ui which allows you to easily manage your docker host or swarm cluster
6. MYSQL 8.011 GA  SQL catching up with 2003 Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes.  JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data  Performance InnoDB is significantly better at Read/Write workloads, IO bound workloads, and high contention “hot spot” workloads  Descending Indexes MySQL 8.0 delivers support for indexes in descending order.  MySQL 8.0 makes UTF8MB4 the default character set from “latin1”
7. MYSQL 8.011 GA
8. METABASE Metabase is an easy open source way for everyone in your company to ask questions and learn from data
9. CACHET Cachet is a free and open source status page system for your API, service or company. Use it today to communicate downtime or system outages to your customers, teams and shareholders
10. CUTTLEFISH Cuttlefish is an open source transactional mail solution Still in better but offers you some get features as a cheap alternative to Sendgrid, Mailgun and Mandrill
11. FATHOM ANALYTICS Fathom Analythic is a simple, trustworthy website anlytics
12. DEMO? Let’s see how we can get all this platform running on our servers using Docker and manage them using portainer
13. COOL GIVEAWAYS  https://studddent.com  Freenom “Seriously, before you pay for something ask me on twitter” @otienojulie1
14. THANK U!! Twitter: @otienojulie1 Email: otienojulie@gmail.com GitHub: @otienoh Blog: www.otienojulie.com Talk: speakerdeck.com/otienoh