Your

Mod

erat

or

Karen LopezSr. Project Manager / Architect

Infoadvisors@datachick

#BCDModeling

Your

Pan

elis

t

Donna BurbankVP Information Management Services, Enterprise Architects

@donnaburbank

Carol LehnDatabase Designer,

PepsiCo@lehnca

The Need for SpeedFaster Data Models…and Data Modelers

Karen Lopez

Welcome!

#BCDModelingChatQ&ASlidesAftershow

2

Need for Speed

Sprints, marathons and trainingRace cars, horses, carts, and feetQualifiers and RacesRules, tickets and enforcementFads, gadgets and automationRed, yellow, green and checkered flagsHow do you know when to stop racing?

3

Sprints, Marathons & Training

Agile & SCRUMTraining versus racingSprintsLSDsWalkbreaksHurdlesRest

4

Make it faster…

1. Know the process/methodology2. Refuse to sprint a marathon3. Insist on walk breaks4. Insist on resources for

maintenance5. Put hurdles in writing, then

report on their status

5

Race cars, Horses & Feet

Maintaining cars, horses and feetPit crewTraining the crewSpare parts & shoesUpgrades

6

Make it faster…

1. Maintain stuff2. Train your team mates3. Have spares4. Don’t use old tools5. Use professional tools

7

“

”

Trained team members put up fewer obstacles and get their

own jobs done faster.- Karen Lopez

Quote me… 8

Qualifiers & Races

Resumes versus SkillsTests versus portfoliosSize mattersCollaboration matters more

9

“

”

In my observations, the project gains from having an experienced

data modeler: 2-3x faster to deliver usable models.

- Karen Lopez

Quote me… 10

Make it faster…

1. Hire good people with real world experience

2. Train inexperienced people3. Mentor inexperienced people4. Rate fit high

11

Rules, Tickets and Enforcement

Our RulesYour RulesInspectionAutomation

12

Make it faster…

1. Automate everything you can, and more

2. Inspect and report, don’t tattletale

3. Log it in issue management system

13

Fads, Gadgets and Automation

MethodologiesMacros & ScriptsLazy Data Modeler is BestGadgets, Tablets, Laptops

14

Make it faster…

1. Automate everything you can, and more

2. Be lazy…automate more…3. Make use of modern

technology

15

“

”

The best data modeler is a lazy data modeler

- Karen Lopez

Quote me…. 16

Red, Yellow, Green and Checkered flags

PrioritiesPerfection versus successDeliver!

17

Make it faster…

1. Automate everything you can, and more

2. Understand deliverables…yours versus theirs

3. Do maintenance during down times

4. Have a pit crew

18

How do you know when to stop racing and go back to training? 19