Slide 1: Fast Tracking Business Performance: The Three 'P'-illars
FAST TRACKING BUSINESS PERFORMANCE WITH ADVANCED ANALYTICS AND IT INFRASTRUCTURE SERVICES THE THREE ‘P’-ILLARS Lessons Learned in implementing Andy Vadul @USEReady_CTO
Slide 2: About Us: History and Growth
ABOUT US: HISTORY AND GROWTH Nominated for Tableau’s Founded in Over 250 employees Won Red Herring 100 Winner & Expanded reach in the US with Services, Training and Alliance 2011 globally Inc 5000 Awards in 2015 offices in Austin and Seattle Partner of the year 2016 Soon we spread across 3 Locations
Slide 3: What We Do: BI Deployment and Adoption
WHAT WE DO: BI DEPLOYMENT AND ADOPTION We help you deploy an agile BI ecosystem and establish CoEs in data preparation, visualization, collaboration and governance to ensure that the process of using your data for business gains can begin. 3. System Integration 4. Information Security & Governance 2
Slide 4: Platform
PLATFORM
Slide 5: Platform Overview
PLATFORM OVERVIEW Data Warehouse/ Mart/ Lake REPORTING Staged Data Enrich / Transform Prod Data Raw Data ANALYSIS SSIS Physical/ Virtual extract Alteryx Data Store connect Business live Intelligence Scripts Layer DATA MINING Tabcmd Order of business value Operational Data Store(s)
Slide 6: Platform Changes
PLATFORM CHANGES ¨ Start with the front end and work backwards ¤ Immediate business value ¤ Shows where to focus for optimization ¨ Time to market is everything ¤ Use data warehouse design for optimization ¤ Record performance – end to end ¤ Size (of DW) does matter!
Slide 7: Process
PROCESS
Slide 8: Process Overview
PROCESS OVERVIEW Tableau + Dashboards / Reports Ad Hoc Analysis Snowflake Business Want Can IT Want Can Want Can Business + IT People WATERFALL Manual & Repetitive Process Collaborative Agile Report Factory TABLEAU + Snowflake Excel / Access Platform
Slide 9: Process Changes
PROCESS CHANGES ¨ Focus on Gathering Data ¤ Cloud Data warehouse will continue to evolve ¤ DW Design is vastly simplified – Cloud Data Warehouse ¨ Load testing ¤ Data Load testing as seen from the front end becomes critical ¤ Optimize and rearrange process for performance only ¨ Business Continuity
Slide 10: People
PEOPLE
Slide 11: Kaizen Team
KAIZEN TEAM Business Context Alignment Program Coordinator Seed Business Subject Matter Expert Questions Data Collaborative Agile (Customer) Data Steward (Scrum Team) Tableau Knowledge Training Tableau Artisan Transfer (Scrum Team)
Slide 12: Perspective Changes
PERSPECTIVE CHANGES ¨ Data Steward ¤ Unlearn DW complexity ¤ Train for what to focus on ¨ Tableau Artisan ¤ Live Queries can work just as well! ¤ Join on the fly – Join Culling is magical ¤ Use Level of Detail expressions correctly ¨ Subject Matter expert ¤ ‘Can’t be done’ is only transient! ¤ Requi
Slide 13: Summary: Platform, Process, People
SUMMARY PLATFORM • Value is front to back • Time to Market • Reduced complexity PEOPLE • Unlearn complexity • Focus on end goal PROCESS • Closer business interactions • Focus on data gathering • Test for Load • Process is a lot lighter
Slide 14: Thank You
THANK YOU www.useready.com contact@useready.com +1 (212) 370-0000 805 Third Avenue 11th floor, New York, NY 10022