Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Savvy Managers Expand / Collapse
Author
Message
Posted Monday, November 26, 2007 3:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
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
Post #426063
Posted Monday, November 26, 2007 9:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:15 PM
Points: 2,834, Visits: 3,071
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. :D
Post #426133
Posted Monday, November 26, 2007 9:53 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 5,178, Visits: 12,032
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' :)
PP



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

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #426142
Posted Tuesday, November 27, 2007 7:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
Doh!

That one always gets me. Must be my accent ;)







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #426378
Posted Tuesday, November 27, 2007 10:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 5, 2011 12:58 PM
Points: 230, 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





Post #426486
Posted Tuesday, November 27, 2007 10:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
That's data quality in Alaska for you!

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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #426500
Posted Tuesday, November 27, 2007 10:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 11:13 AM
Points: 150, 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
Post #426503
Posted Tuesday, November 27, 2007 11:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 5, 2011 12:58 PM
Points: 230, Visits: 262
Fingers are plenty warm.

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

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

Or is that just an Oracle saying...

Post #426523
Posted Wednesday, November 7, 2012 7:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 2, 2013 6:30 AM
Points: 346, Visits: 691
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

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? )

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.
Post #1381971
Posted Wednesday, November 7, 2012 7:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 1,707, Visits: 4,853
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.
Post #1381983
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse