Scaling your Tableau - Migrating from Tableau Online to a proper DWH solution / Munich Tableau User Group - Feb 26, 2015

Initially storing data with Tableau Online storage could sound like a good idea, mainly because you get it for free. From another side Tableau doesn't say they provide a DWH platform, so you can not expect any kind of production use-cases from the storage of Tableau Online. In the talk, we will go through the process of automatically duplicating your Tableau datasources to Amazon Redshift. That will enable us to be more flexible with scaling your data, be sure about backup strategies and many-many more points. We will introduce our python toolchain that helps us in a daily management of our BI.

Transcript

1. S T Y L I G H T . C O M Scaling your Tableau – Migrating from Tableau Online to a proper DWH solution. S T Y L I G H T . C O M S E R G I I K H O M E N K O , D A T A S C I E N T I S T , S E R G I I . K H O M E N K O @ S T Y L I G H T . C O M , @ l c 0 d 3 r
2. T a b l e a u O n l i n e D a t a S t o r a g e M i g r a t i n g D a t a f r o m T a b l e a u O n l i n e R e a d i n g T a b l e a u T D S f i l e D W H w i t h A m a z o n R e d s h i f t A G E N D A
3. S T Y L I G H T . C O M Tableau Online Data Storage Simple,  Cheap,  Just  works
5. P i c t u r e o f t h e o l d s e t u p
8. Pros and Cons • E a s y t o s t a r t u s i n g • W o r k s f o r f r e e • A l l d a t a s o u r c e s i n o n e p l a c e • U n i f i e d r o u t i n e
9. Pros and Cons • H a r d t o s c a l e • N o t p r o d u c t i o n r e a d y • N o b a c k u p s • N o c o n t r o l o v e r d a t a • N o c o n t r o l o v e r f a i l u r e s
10. S T Y L I G H T . C O M Migrating Data from Tableau Online
11. • T a b l e a u i s a g o o d D S e d i t o r • W e a l r e a d y h a v e s o m a n y D S • C u r r e n t t a s k s a n d s p r i n t s
13. S T Y L I G H T . C O M Reading Tableau TDS file
14. P i c t u r e o f t h e o l d s e t u p
17. Issues, plans • W e h a v e a l l D S a c c e s s i b l e • W e k n o w w h e r e d a t a c o m e s f r o m • S t r u c t u r e r e - c r e a t i o n • M i g r a t i o n w i t h o u t a n y m a n u a l i n p u t
18. S T Y L I G H T . C O M DWH with Amazon Redshift ..  and  other  cool  things
21. P i c t u r e o f t h e o l d s e t u p
23. Benefits • C o n t r o l o v e r b a c k u p s • C o n t r o l o v e r r e f r e s h e s • S c a l e D W H u p t o p e t a b y t e s c a l e • E a s y t o a d d n e w E T L s t a g e s ( E M R ) • M o r e o p e n f o r n e w c h a l l e n g e s
26. S T Y L I G H T . C O M Future plans
27. Make it even cooler! • O p e n S o u r c e o u r P y t h o n t o o l s • I n t e r n a l D W H m a p p i n g s e r v e r • F l e x i b l e t o i n t e g r a t e n e w t h i n g s • G o o g l e S p r e a d s h e e t i n t e g r a t i o n
28. Thanks for your attention!
29. S T Y L I G H T . C O M STYLIGHT GmbH Nymphenburger Straße 86 80636 Munich, Germany Join us on Facebook: facebook.com/stylight Follow us on Twitter: twitter.com/stylight Follow us on Instagram: instagram.com/stylight