1 / 52

How (not) to Lose Your Audience

How (not) to Lose Your Audience. Avoiding Big Blunders. Chris Lawson. What’s the Issue?. Really smart people often do really poor presentations. Sometimes even the featured speaker falls into this trap. This makes it tough for the audience to learn new ideas. It also wastes time.

ashley
Télécharger la présentation

How (not) to Lose Your Audience

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How (not) to Lose Your Audience Avoiding Big Blunders Chris Lawson

  2. What’s the Issue? • Really smart people often do really poor presentations. • Sometimes even the featured speaker falls into this trap. • This makes it tough for the audience to learn new ideas. • It also wastes time.

  3. Why Should I Care? • Your presentation affects how people think about you. • Fair or not, you gain or lose credibility • A great talk will be remembered for years. • An unprepared speaker will likely not be invited back. • Your ideas will be forgotten. • Not the best use of time.

  4. The Good News • Great presentations have little to do with your actual speaking ability. • Most of it has to do with preparation. • Preparation can be time-consuming, but the Payoff is huge.

  5. THIS IS HOW YOUR LISTENERS WILL REACT TO A GOOD PRESENTATION

  6. BUT--YOU CAN’T WIN ‘EM ALL Photo courtesy of: “Guy sleeping behind obama at graduation"

  7. 2 Points to Remember Great speakers aren’t the smartest; they are the best prepared. Consider what the audience will see

  8. Blunder # 1 Failing to check-out room & equipment

  9. How Can I Tell I’m Losing the Audience? Here are some easy ways to see you’re “losing it.”

  10. How Can I Tell I’m Losing the Audience? It may take keen skill to spot when you’re beginning to fade . . .

  11. These Guys Need Help

  12. How Rude!

  13. CASE STUDY:How Can I Tell I’m Losing the Audience?

  14. Be Alert to Subtle SignsPhase 1: Boredom Do I get 17 or 18 weeks vacation? Note Glazed Eyes

  15. Watch for Subtle SignsPhase 2: Restlessness I didn’t know we DBAs were so boring … Vacant stare

  16. Watch for Subtle SignsPhase 3: Loss of Consciousness Not very alert, beginning to drool

  17. Watch for Subtle SignsPhase 4: Coma (or death) No pulse

  18. Blunder # 2The “Cram” Method Show slides with so much information no one can possibly comprehend it. Corollary: Try to impress your audience—the more information the better!

  19. Results • You havelots of coolresults • No one canread this • No one canunderstand this • Graphs areyour friend…

  20. Fastest Database - TPC-H SizeDatabaseHardwareCPU/OSCost 300G Oracle 10g HP/Proliant 8/RHEL4 524K 1T Oracle 10g HP/Superdome 64/HP UX 4.0M 3T Oracle 10g Sun/E25K 72/Solaris 5.8M 10T Oracle 10g Sun/E25K 72/Solaris 5.8M “The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric(QphH@Size). The TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.” Source: www.tpc.org (As of April 19, 2006)

  21. Some Actual Slides I am not joking—the following are real slides from recent speakers

  22. Runtime Trends Do crosstab from RC_BACKUP_PIECE view. Make anything before 4PM part of previous overnight run: CREATE OR REPLACE VIEW ucsc_bkup_trend_insert_vw (...column aliases...) AS SELECTCASE WHEN to_char(p.START_TIME,'HH24') < 16 THEN trunc(p.START_TIME - 1) ELSE trunc(p.START_TIME) END AS bkup_date, sdl.SERVER_NAME, d.name, p.device_type, nvl(max(CASE WHEN backup_type = 'D‘ THEN p.ELAPSED_SECONDS END),0) AS LVL0_secs, nvl(max(CASE WHEN backup_type = 'I' THEN p.ELAPSED_SECONDS END),0) AS LVL1_secs, nvl(max(CASE WHEN backup_type = 'L' THEN p.ELAPSED_SECONDS END),0) AS ARCH_secs, nvl(max(CASE WHEN backup_type = 'D' THEN p.BYTES END),0) AS LVL0_bytes, nvl(max(CASE WHEN backup_type = 'I' THEN p.BYTES END),0) AS LVL1_bytes, nvl(max(CASE WHEN backup_type = 'L' THEN p.BYTES END),0) AS ARCH_bytes, p.START_TIME, p.COMPLETION_TIME FROM rc_backup_piece p, rc_database d, ucsc_server_db_list sdl[...]

  23. Identifying Granules of Parallelism during scans in the plan

  24. Metadata Reporting: Compression Ratio • COMPRESSION_RATIO column is in 10 _summary and _details views, but these are “primarily intended to be used internally by Enterprise Manager.”Before finding that caveat, I had found results to not trust RC_BACKUP_SET_DETAILS --- good to avoid. In following chart, (10.2.0.2 for testing), Input Bytes is same for Level 0 and 1, so calc is from total DB used space.Level 1 ratio is distorted. • The BDF table in RC_BACKUP_DATAFILE view knows about Block Change Tracking, and has count of blocks scanned, so a better ratio could be calculated.

  25. “Please Take this Survey”

  26. Keynote Speaker Slide • Twitter.com • Amazon EC2 • Cuil.com • Apple iStore 2008 • Google Gmail • WolframAlpha Company XYZ Keynote presentation Oct, 23, 2009

  27. What do You Think of this? • The fastest execution plan usually is the one that touches the fewest rows, and this, in turn, is the one that discards the fewest rows, and that discards those rows that must be discarded the earliest, before wasting work on unneeded joins. This usually starts with the best filter condition (the one reaching the smallest fraction of its table), and reaches every large table with the fastest path (usually a filter-column index for the first table and nested loops to a join-key index for the later large tables). • The goal is normally a query that runs in minutes, at the most, without requiring parallel threads.

  28. Reaction to Prior Slide • I believe this person is inept. • This guy is trying to bamboozle me. • This presentation was thrown together • This is going to be really boring. • Is he going to read every line? (Ans: Yes, he did.) • I’m not inviting this guy to my party. • My reaction: I left after 5 minutes. • These reactions might mislead you, because . . .

  29. The Lesson • In actuality, the author of the messy slide is a genuine performance expert. • About 13 years ago, I learned a great tuning technique from his writings. • I use his technique nearly every day. Moral: His presentation worked against him instead of attesting to his skill

  30. Let’s Try a Redesign Here’s the Original . . .

  31. Tips on Performance Tuning • The fastest execution plan usually is the one that touches the fewest rows, and this, in turn, is the one that discards the fewest rows, and that discards those rows that must be discarded the earliest, before wasting work on unneeded joins. This usually starts with the best filter condition (the one reaching the smallest fraction of its table), and reaches every large table with the fastest path (usually a filter-column index for the first table and nested loops to a join-key index for the later large tables). • The goal is normally a query that runs in minutes, at the most, without requiring parallel threads.

  32. Here’s the Redesign. . .

  33. Tips on Performance Tuning For good execution plans touch as few rows as possible • Filter-out rows as early as possible • Start with the best filter condition • Optimize first--use parallelism last.

  34. Try Replacing lots of text with a Picture Let’s try an example.

  35. Example with Text There was once a very small software company that had a small government contract. The founders had some good ideas, but not a lot of money. They were smart, but some of them didn’t even have college degrees. To make things worse, some of them were sort of nerdy, and were not too good at social skills. Some of them even wore “pocket protectors” and put lots of felt-tip pens in their pockets. Nevertheless, they struggled, worked hard, and made lots of money. Today the founders are very famous and rich. If you work hard, you too can be like them.

  36. Example with Picture Do you recognize any of these guys . . . ?

  37. Oracle CorporationOne-year Anniversary Ed Oates, Bruce Scott, Bob Miner, and Larry Ellison

  38. Blunder # 3Dull, Boring Monotone

  39. Blunder # 4 Make slides that cannot be read Corollary: Use colors that are scary

  40. Chilean Exports • Fresh fruit leads Chile's export mix - Chile emerges as major supplier of fresh fruit to world market due to ample natural resources, consumer demand for fresh fruit during winter season in U.S. and Europe, and incentives in agricultural policies of Chilean government, encouraging trend toward diversification of exports and development of nontraditional crops - U.S. Dept. of Agriculture, Economic Research Service Report • Chile is among the developing economies taking advantage of these trends, pursuing a free market economy. This has allowed for diversification through the expansion of fruit production for export, especially to the U.S. and Western Europe. Chile has successfully diversified its agricultural sector to the extent that it is now a major fruit exporting nation. Many countries view Chile's diversification of agriculture as a model to be followed. • Meanwhile, the U.S. remains the largest single market for Chile's fruit exports. However, increasing demand from the EC and Central and East European countries combined may eventually surpass exports to the U.S., spurring further growth in Chile's exports. • If you’ve read this far, your eyes probably hurt and you’ve been reading this tedious long-winded text instead of listening to me. I’m insulted- can’t you see I’m doing a presentation up here? Look at me! Congratulations, however, on having such good eyesight.

  41. Do You Remember this Point? Consider what the audience will see

  42. At Vision-Loss Conference Speaker showed complex slide with small font, and asked, “Can everybody see this okay?”

  43. Have mercy on the poor folks trying to read . . .

  44. Beginner Motorcycles • My personal favorite: the Suzuki Savage • Light weight (~380lbs) • Adequate power (650cc engine) • Low seat height fits most riders

  45. Mommy, my eyes are burning! Mommy, my eyes are burning! • Can you look at this for 45 minutes? • Colors look different on every LCD projector • Colors look different between transparencies and projector • If printing slides, save ink by choosing white background.

  46. Use PowerPoint • Dazzle them with 256,000,000 colors! • Cliché templates! • Sound Effects! • Annoying transitions! • Import video and animations that won't work • Put an annoying header and footer on every slide Terrible Presentations 16/17

  47. Summary: Big Blunders • Failure to prepare the room • Overly complex slides • Monotone presentation • Unreadable slides

More Related