~/talk

60 Reporting Tips in 60 Minutes

on YouTube 01h 04m
Talkat PASS Business Analytics Conference 2015 · 2015-04-20..04-22· [data-engineering]

speaker

name:Ike Ellis
links:none on file

resources

video:https://youtu.be/MAmRP5ef8bY
slides:none on file

summary

Sixty rapid, practical tips catalog specific tools and fixes: use LavishBootstrap for hex colors, ColorBrewer for palettes, and Redgate SQL Search to find columns and code; prefer views and store colors/formats in the database for consistent reports; convert heaps to clustered indexes to flip performance from “an hour to five seconds”; use CONCAT and TRY_CAST/TRY_CONVERT to avoid nulls and casting errors; run SSIS by right‑click execute to avoid accidental truncates; add row count and execution date to report footers, audit usage, and delete unused reports.

AI-written summary · about

chapters (49)

  1. 0:00Introduction to 60 reporting tips
  2. 0:41Using Lavish Bootstrap for color extraction
  3. 2:03Avoiding IP issues with Morg Files
  4. 3:07Optimizing SSMS with query shortcuts
  5. 4:35Formatting SQL with leading commas
  6. 6:01Creating a memory jar for gratitude
  7. 6:44Boosting SQL performance with clustered indexes
  8. 8:08Choosing readable font sizes for presentations
  9. 8:51Launching SSIS packages correctly
  10. 9:53Using color effectively in dashboards
  11. 11:40Placing key KPIs in the upper left corner
  12. 12:01Displaying row counts on the first page
  13. 12:23Concatenating strings with CONCAT function
  14. 14:29Finding news summaries on Wikipedia
  15. 15:13Searching SQL Server objects with F7
  16. 16:40Finding SQL objects with Redgate SQL Search
  17. 17:41Using Visual Studio Quick Launch
  18. 18:24Simplifying queries with window functions
  19. 21:58Adding text overlays to images
  20. 23:48Managing multiple SQL servers with Registered Servers
  21. 25:14Using date tables for easier date calculations
  22. 27:26Motorcycle hand signals for avoiding cops
  23. 27:46Handling casting errors with TRY_CAST
  24. 29:30Automating tasks with SQL Sharp tools
  25. 32:03Saving query shortcuts in SSMS
  26. 33:06Auditing report usage for cleanup
  27. 35:59Focusing on deep work for productivity
  28. 37:03Storing colors in the database for consistency
  29. 40:56Using expressions for dynamic formatting
  30. 42:20Limiting report exports to two formats
  31. 43:45Decoupling SQL from reports with views
  32. 44:05Tracking daily accomplishments in a journal
  33. 44:48Replacing Analysis Services data source views
  34. 46:11Managing report permissions efficiently
  35. 49:04Gathering report requirements one-on-one
  36. 50:27Identifying key people for efficient feedback
  37. 51:11Changing one thing at a time for troubleshooting
  38. 51:54Focusing on key KPIs over many metrics
  39. 52:57Adding report footers with row count and execution date
  40. 53:58Using friendly names for data clarity
  41. 54:39Managing taxonomy with a Wiki
  42. 55:43Learning in groups for better retention
  43. 56:24Customizing SSMS status bar location
  44. 57:06Optimizing pivot tables in Excel
  45. 1:00:14Using script parameters for dynamic queries
  46. 1:01:18Closing tabs with middle mouse button
  47. 1:01:39Quickly aliasing columns in SQL
  48. 1:02:44Sharing secrets securely with one-time links
  49. 1:03:32Q&A and closing remarks

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.