WELCOME DOMO DEPLOYMENT & SETTING YOURSELF UP TO SCALE: WHAT I - - PowerPoint PPT Presentation

WELCOME

DOMO DEPLOYMENT & SETTING YOURSELF UP TO SCALE: WHAT I WISH I KNEW WHEN I STARTED

Joshua Stan

Director of Finance, Dal-Tile Corporation

3

Josh.Stan@Daltile.com LinkedIn.com/in/jstan

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

5

Helpful tips Warning: Potential Pitfalls Beginner Intermediate Advanced Skill Level Required

Since we couldn’t go skiing at Domopalooza this year…

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

10

Photo by VITALIY ANOKHIN on Unsplash

If 2 finance guys can make Domo a success, SO CAN YOU!!!

Josh Wayne 6ft

BASICS TO GET DOMO UP AND RUNNING

11

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

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

If behind a firewall, Domo IPs need to be whitelisted

• Go for Quick Wins

Develop Departmental Major Domos

• Know your audience (and future audiences)
• Data: Sources and Validation
• Ownership: Now and in the Future

KEYS TO SCOPING USE CASES

12

Everyone in your organization can have an ownership stake in Domo – democratize the data and ownership

Long & wide datasets are no problem in Domo

Datasets in Domo Source Data Data Transforms Pages Cards Scheduled Reports Alerts Users, Groups, PDP, Page Organization, Access

SUCCESS WITH DATA: BE PREPARED

• Connections: Things to consider
• Credentials
• On Prem vs. Cloud
• Firewalls
• API access & licensing
• IP Whitelisting
• Limitations on extracts (timing,

speed, volume limits)

• Building custom connectors
• Document as you go

13

Have a Data Strategy

Connection Credentials Frequency Security Sharing Ownership

Automating your future:

• Job Monitoring
• Dataset types, names & tags
• Naming conventions

We have 60+ data sources connected,

• nly 1 remains a manual feed

UNDERSTANDING DATA

Now you’re connected to the data, but what does the data mean?

The GL table in SAP is called what? FAGLFLEXA Field names didn’t get any easier:

• Fiscal Year: GJAHR
• Fiscal Month: POPER
• Organization Hierarchy: RBUKRS, SEGMENT & RBUSA
• Product Categories: PRCTR

14

At Dal-Tile, we connected to 3 different ERP systems. From SAP alone, we have synced

• ver 500 tables to Domo.

Having someone that understands the data, can greatly speed your deployment.

You can find major ERP schemas

• nline, including SAP & JD Edwards

CONSIDER YOUR DATA OPTIONS

• Workbench with an ODBC driver (Append/Replace)
• Workbench with a custom plug in
• Upserts
• Partitioned Datasets
• Connectors
• Stacker
• Magic ETL, SQL ETL
• Fusions
• Materialized Fusions
• Write-Back Connectors
• Custom Apps & Connectors
• APIs

15

Domo assumes all data/time data uploaded is in UTC

Raw Data Data Transforms Unlimited Potential

ORGANIZING DOMO ASSETS

Assets Managed Online/Workbench

• Dataflows
• Datasets
• Users
• Groups
• Personalized Data Permissions
• Pages
• Cards
• Certification
• Beast Mode Management
• Scheduled Reports & Alerts

16

Develop the Domo Platform with Unlimited Scalability in Mind

Manage PDP & Access by Groups

• vs. Individual User

Currently, scheduled report

• wners cannot be changed

Tools to Simplify Your Life as an Admin

• SSO
• Excel Admin Plug-In
• PDP Tool
• CLI Tool
• Domo APIs

Use trusted attributes with SSO Active Directory to Assign PDP Define schemas on production datasets to help creators

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
• Regular Communication & Engagement
• Develop departmental major Domos
• Publicize your wins & recover quickly from your missteps

18

Above all, make it fun and easy to Consume in Domo!!!

Spread ownership to expand Domo’s usage

The No. 1 Feedback we get is there is not enough training

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
• rganization
• Document as you go
• Make Domo fun & easy
• Don’t be afraid to reach out for help if you need it

20

THANK YOU