SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Savvy Managers


Savvy Managers

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81754 Visits: 19211
Comments posted to this topic are about the item Savvy Managers

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Loner
Loner
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4134 Visits: 3353
My former manager was a saavy manager and he wrote all the ETL procedures before he became the manager. He attended the Microsoft BI conference too
but it did not mean he learned anything.
The data came from different sources. He built a database for every source. So the ETL system had at least over 20 databases. After that, there was a staging database to group all the data together to build the dimension tables and then another database to build the real dimension table. Since there was no DBA in the company, so he could do anything he wanted. BigGrin
Phil Parkin
Phil Parkin
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25652 Visits: 20678
Steve, don't want to be picky, but as it's the title of your article ... I think the word you're looking for is 'savvy' Smile
PP


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81754 Visits: 19211
Doh!

That one always gets me. Must be my accent Wink

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Bob Hoffman-209065
Bob Hoffman-209065
Old Hand
Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)

Group: General Forum Members
Points: 394 Visits: 262
Dear Bbo,

Thank you for your recent purchase of {invalid item name}.
As a reminder, we offer an extended warranty for $0.00 per 100 years.

Please cantact me for further information.

Sincerely,

sj

Whistling
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81754 Visits: 19211
That's data quality in Alaska for you!

Must be those cold data entry fingers that keep making mistakes. Tongue

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Bob Abernethy
Bob Abernethy
SSC Veteran
SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)SSC Veteran (276 reputation)

Group: General Forum Members
Points: 276 Visits: 899
Sopmwtimes I wonder if data qualiuty is overrrated./

If e nd busers wer justa litle mor cargful tghen theere woulnd''t be sucha need for alll the work andepxpense that goes into dataquiality.

Anddd we coudl focus on more oimportant thing.s
Bob Hoffman-209065
Bob Hoffman-209065
Old Hand
Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)

Group: General Forum Members
Points: 394 Visits: 262
Fingers are plenty warm.

It's the thick seal skin gloves we have to wear that makes it hard to type!
BigGrin

Isn't data validation part of that old saying "garbage in, garbage out"?

Or is that just an Oracle saying...
roger.plowman
roger.plowman
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1556 Visits: 1285
I find myself in strong disagreement with the editorial.

Sales people:

A) shouldn't be allowed near a computer without at least 3 armed guards to make sure they don't touch anything Laugh

B) NEED every error correction mechanism known to man

and

C) Need a dedicated team of error correction specialists to fix all the entry mistakes made by said sales people.

Lacking that (sigh) you must have strong editing controls at the front end to catch at least some of the bone-headed and (frankly) lazy mistakes and deliberate lack of data entry most sales people consider adequate.

Been there, done that, ate the tee-shirt from sheer frustration bordering on genocidal rage... (sales people are a seperate species, right? :heheSmile

Seriously though, the best time to correct any error is when it's made. Spell checking is the least of your problems when the sales force is allowed to enter data (shudder). Even having a DMZ and über-strong error checking won't help all that much because rejecting a record for data errors--even if you can find them (and most data errors aren't correctable since the data is either missing entirely or not verifiable without access to the actual paper records) isn't much less frustrating for the sales force than error messages at the front end.
Eric M Russell
Eric M Russell
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 10933
When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:
- If Col1 = 'A' then Col2 must be 1, 2, or 3.
- When Col3 is updated, then Col4 must also be updated with Date+Time EST.

The documentation must be continuously revised post-production as the business rules change, be published so that any user who queries the database has access to them, and be endorsed and promoted by mangement.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search