Consulting Services
Real-world solutions to common
problems in reporting & analysis
Rick Losk
SQL Software Engineer
How I Deliver Results
Summary
My goal is to help you
optimize Data Mart ETL
for reporting & analysis.
What's on your project list?
  • Performance: Streamline and
    document ETL code, tune SQL
    for reporting & analytics.
  • Accuracy: Verify metric calcs,
    add post-run data validation
    for all steps in update cycle.
  • Automation: Add logging and
    error-handling, integrate ETL
    processes into schedule.
SQL Services
Erratic results. Slow re-
sponse. Random dead-
locks. Convoluted code.
Make them all go away.
Accurate, reliable data.
Fast-running reports.
Super-productive users.
Dude, that's The Dream!
Critical knowledge is
buried in report code
(and people's heads).
Let's write it down.
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]