Sergii Khomenko

Setting up your Business intelligence from Tableau to Redshift

Transcript

1. S T Y L I G H T . C O M Setting up your Business Intelligence from Tableau to Redshift 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
4. L i v e i n 1 2 c o u n t r i e s STYLIGHT – international community
5. 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
6. The life before Tableau D I F F E R E N T T O O L S , D I F F E R E N T A P P R O A C H E S
8. D a t a c o n s i s t e n c y N o t f l e x i b l e s t r u c t u r e – r e p o r t c h a n g e D i f f i c u l t t o s c a l e T i m e - c o n s u m i n g – f o r n e w a d - h o c M a i n t a i n a n d s u p p o r t – i n - h o u s e d e v e l o p m e n t I n s h o r t t e r m M o r e f l e x i b l e E a s y t o a d d a l e r t i n g P R O B L E M S :
9. S T Y L I G H T . C O M Tableau Online Data Storage Simple,  Cheap,  Just  works
12. P i c t u r e o f t h e o l d s e t u p
15. 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
16. 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
17. S T Y L I G H T . C O M Migrating Data from Tableau Online
18. • 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
20. S T Y L I G H T . C O M Reading Tableau TDS file
21. P i c t u r e o f t h e o l d s e t u p
24. 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
25. S T Y L I G H T . C O M DWH with Amazon Redshift ..  and  other  cool  things
28. P i c t u r e o f t h e o l d s e t u p
30. 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
33. S T Y L I G H T . C O M Future plans
34. 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
36. Thanks for your attention!
37. http://daho.am/
38. wearabledatahack.com
39. S T Y L I G H T . C O M Sergii Khomenko Data Scientist STYLIGHT GmbH sergii.khomenko@stylight.com @lc0d3r Nymphenburger Straße 86 80636 Munich, Germany