WELCOME
DOMO DEPLOYMENT & SETTING YOURSELF UP TO SCALE: WHAT I WISH I KNEW WHEN I STARTED Joshua Stan Director of Finance, Dal-Tile Corporation Josh.Stan@Daltile.com LinkedIn.com/in/jstan 3
AGENDA Dal-Tile’s Journey & Objectives with Domo • Initial Hurdles We Overcame • The Basics: Anyone Can Be a Success with Domo • Scoping Use Cases • Connecting to Data and Understanding It • Organizing Domo • Driving User Adoption • 4
USED THROUGHOUT THE PRESENTATION Helpful tips Since we couldn’t go skiing at Domopalooza this year… Warning: Potential Pitfalls Skill Level Required Beginner Intermediate Advanced 5
DAL-TILE OVERVIEW Subsidiary of Mohawk Industries (MHK), the largest flooring manufacturer • in the world Dal-Tile has more than a dozen Manufacturing Plants in the U.S., Mexico • and Brazil Sell through 250+ stores in the U.S. and Canada along with Home Centers • and Independent Distributors throughout North & South America 6
OUR JOURNEY WITH DOMO Pre-Domo: Business analysts lived in excel and manual data • extracts The search for a more efficient solution led us to Domo • Just passed our third anniversary on the platform with ~1100 users • Originally scoped 16 use cases and 20 different data sources • Now: • 60+ data sources connected • Thousands of datasets • Billions of rows of data • Domo is used throughout the enterprise • 7
OUR KEY OBJECTIVES DEPLOYING DOMO 1. Improve Data Availability 2. Automation of Processes 3. Broad Adoption 8
INITIAL HURDLES WE HAD TO OVERCOME Overcommitted on Initial Deployment • Lacked a data connection strategy • Didn’t understand the data • No plan on how to roll out Domo • 9
NO NEED TO BE A DEER IN HEADLIGHTS If 2 finance guys can make Domo a success, SO CAN YOU!!! Wayne 6ft Josh Photo by VITALIY ANOKHIN on Unsplash 10
BASICS TO GET DOMO UP AND RUNNING Minimum Individual that is curious about data – if you can use Excel and PowerPoint, you • can use and administer Domo Access to data you want to bring into Domo • Windows Server for Workbench: If you are uploading Domo from data stored on • premise (non-cloud), then you will likely want a Windows Server We run a 4 core, 16GB RAM, 500GB SSD virtual server for 1500 jobs/day without • issue If behind a firewall, Domo IPs need to be whitelisted Recommended Single-sign on for user credentialing will save you a lot of time down the road • Whitelist Domo Email addresses and mail server IPs in your company’s SPAM • filter 11
KEYS TO SCOPING USE CASES Go for Quick Wins Develop Departmental Major Domos • Know your audience (and future audiences) • Data: Sources and Validation Long & wide datasets • are no problem in Domo Ownership: Now and in the Future • Pages Source Datasets in Data Cards Scheduled Reports Data Domo Transforms Alerts Users, Groups, PDP, Page Organization, Access Everyone in your organization can have an ownership stake in Domo – democratize the data and ownership 12
SUCCESS WITH DATA: BE PREPARED Have a Data Strategy Connections: Things to consider • Credentials • Connection On Prem vs. Cloud • Firewalls • API access & licensing • Ownership Credentials IP Whitelisting • Automating your future: • Job Monitoring Limitations on extracts (timing, • • Dataset types, names & tags speed, volume limits) • Naming conventions Building custom connectors • Sharing Frequency Document as you go • We have 60+ data sources connected, Security only 1 remains a manual feed 13
UNDERSTANDING DATA Now you’re connected to the data, but what does the data mean? The GL table in SAP is called what? At Dal-Tile, we connected to 3 FAGLFLEXA different ERP systems. From SAP alone, we have synced Field names didn’t get any easier: over 500 tables to Domo. Fiscal Year: GJAHR • Fiscal Month: POPER • Organization Hierarchy: RBUKRS, SEGMENT & RBUSA • Product Categories: PRCTR • Having someone that understands the You can find major ERP schemas data, can greatly speed your deployment. online, including SAP & JD Edwards 14
CONSIDER YOUR DATA OPTIONS Workbench with an ODBC driver (Append/Replace) Domo assumes all data/time • data uploaded is in UTC Workbench with a custom plug in • Raw Data Upserts • Partitioned Datasets • Connectors • Stacker • Transforms Magic ETL, SQL ETL • Data Fusions • Materialized Fusions • Unlimited Write-Back Connectors • Potential Custom Apps & Connectors • APIs • 15
ORGANIZING DOMO ASSETS Assets Managed Tools to Simplify Your Life as an Online/Workbench Admin Use trusted attributes with SSO Define schemas on production Dataflows SSO • • Active Directory to Assign PDP datasets to help creators Datasets Excel Admin Plug-In • • Manage PDP & Access by Groups Users PDP Tool • • vs. Individual User Groups CLI Tool • • Personalized Data Permissions Domo APIs • • Pages • Cards • Certification • Beast Mode Management • Currently, scheduled report Scheduled Reports & Alerts • owners cannot be changed Develop the Domo Platform with Unlimited Scalability in Mind 16
KEY THINGS TO REMEMBER WITH DOMO ASSETS Naming conventions matter (table, field, DF, beast modes, groups) • Keep a healthy Domo environment with quarterly cleaning • Document as you go • Automate the backend as much as possible • 17
DRIVING USER ADOPTION Executive sponsor that is willing to extensively use Domo • Deliver a unique experience – find the wow factor • Training, training and more training The No. 1 Feedback we get is • there is not enough training Regular Communication & Engagement • Develop departmental major Domos Spread ownership to expand • Domo’s usage Publicize your wins & recover quickly from your missteps • Above all, make it fun and easy to Consume in Domo!!! 18
YOU ARE NOT ALONE – EVEN IF YOU ARE QUARANTINED Resources to Help You Be Successful Domo Resources • Knowledge Base • Dojo • Support • Customer Success Manager (CSM) • Outside Resources • Other Domo Customers • 19
KEY TAKEAWAYS Everyone can be successful with Domo Start small, think big • Develop your data strategy • Find people that understand the data to speed deployment • Democratize data and spread ownership throughout the • organization Document as you go • Make Domo fun & easy • Don’t be afraid to reach out for help if you need it • 20
THANK YOU
Recommend
More recommend