April 4, 2011 at 8:06 am
Jeff Moden (4/4/2011)
Dang... Johan beat me to the punch on the target thing. Since more than one of us said it, it must be true. 😛
He caught me in a clear and sharp moment. 😉
Maybe you should also enjoy a shot of scotch for a guestimated number of cars that will cross you on the first day you drive your new car :hehe::-D
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 4, 2011 at 8:15 am
I think then I have to remove quite a bit of target stickers. I think the target sticker is on me... 😀
First they tried to hit me from the back, then they tried to hit me from the side door. Since they could not hit me as easily like that, this time they tried to hit me head on.. 😀
-Roy
April 4, 2011 at 8:16 am
Roy Ernest (4/4/2011)
Jeff, I have been having some bad time with accidents during the past one and a half years. One car was totaled and bought this new one. This is the third accident in this new car. Not even one of them was my mistake. They all seem to target me and crash into me. I think it is time to sell this car or stop driving a car. 🙁
Sounds like what you need is a tank.
Glad to hear that you are doing well.
April 4, 2011 at 8:42 am
Roy Ernest (4/4/2011)
Jeff, I have been having some bad time with accidents during the past one and a half years. One car was totaled and bought this new one. This is the third accident in this new car. Not even one of them was my mistake. They all seem to target me and crash into me. I think it is time to sell this car or stop driving a car. 🙁
Turn off the high-power electromagnets in the trunk.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 4, 2011 at 9:19 am
Lynn Pettis (4/4/2011)
Roy Ernest (4/4/2011)
Jeff, I have been having some bad time with accidents during the past one and a half years. One car was totaled and bought this new one. This is the third accident in this new car. Not even one of them was my mistake. They all seem to target me and crash into me. I think it is time to sell this car or stop driving a car. 🙁Sounds like what you need is a tank.
Glad to hear that you are doing well.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 4, 2011 at 9:26 am
Looks like I need a tank just you all are saying... 🙂
-Roy
April 4, 2011 at 11:30 am
Since it is pretty slow on The Thread today, I'll ask a question.
I'm trying to research using data analysis to detect shrinkage in a retail setting. Primarily through a data warehouse. Anyone have any suggestions for articles to read or books to check out?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 4, 2011 at 11:52 am
Sounds interesting, looking for unreported (or under reported) sales of merchandise. I haven't heard of any articles on doing this but sounds like an interesting research project.
What type of data do you currently and capture and is any of the merchandise perishable (tracking expired products)?
April 4, 2011 at 11:57 am
Lynn Pettis (4/4/2011)
Sounds interesting, looking for unreported (or under reported) sales of merchandise. I haven't heard of any articles on doing this but sounds like an interesting research project.What type of data do you currently and capture and is any of the merchandise perishable (tracking expired products)?
Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...
Most of the merchandise is food so I'd say the majority is perishable. I'm not sure what kind of tracking of such things we do, but that's a good place to look. Primarily I believe the first place we want to look is POS patterns, voided sales, unusual dollar amounts, etc...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 4, 2011 at 12:00 pm
Stefan Krzywicki (4/4/2011)
Lynn Pettis (4/4/2011)
Sounds interesting, looking for unreported (or under reported) sales of merchandise. I haven't heard of any articles on doing this but sounds like an interesting research project.What type of data do you currently and capture and is any of the merchandise perishable (tracking expired products)?
Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...
Most of the merchandise is food so I'd say the majority is perishable. I'm not sure what kind of tracking of such things we do, but that's a good place to look. Primarily I believe the first place we want to look is POS patterns, voided sales, unusual dollar amounts, etc...
Do you already have a warehouse or any cubes established for tracking POS sales?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 4, 2011 at 12:17 pm
Stefan Krzywicki (4/4/2011)
Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...Most of the merchandise is food so I'd say the majority is perishable. I'm not sure what kind of tracking of such things we do, but that's a good place to look. Primarily I believe the first place we want to look is POS patterns, voided sales, unusual dollar amounts, etc...
Interesting place to look. Having worked in retail, the cash register is not the place to look for shrinkage... it's the backdoor/lunchsack.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 4, 2011 at 12:42 pm
CirquedeSQLeil (4/4/2011)
Stefan Krzywicki (4/4/2011)
Lynn Pettis (4/4/2011)
Sounds interesting, looking for unreported (or under reported) sales of merchandise. I haven't heard of any articles on doing this but sounds like an interesting research project.What type of data do you currently and capture and is any of the merchandise perishable (tracking expired products)?
Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...
Most of the merchandise is food so I'd say the majority is perishable. I'm not sure what kind of tracking of such things we do, but that's a good place to look. Primarily I believe the first place we want to look is POS patterns, voided sales, unusual dollar amounts, etc...
Do you already have a warehouse or any cubes established for tracking POS sales?
We have a warehouse, but no cubes directly pointed at this. We do have some cubes are can create more once I know what kind of algorithms to use. What I'm looking for are articles on what kinds or metrics to examine.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 4, 2011 at 12:43 pm
Craig Farrell (4/4/2011)
Stefan Krzywicki (4/4/2011)
Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...Most of the merchandise is food so I'd say the majority is perishable. I'm not sure what kind of tracking of such things we do, but that's a good place to look. Primarily I believe the first place we want to look is POS patterns, voided sales, unusual dollar amounts, etc...
Interesting place to look. Having worked in retail, the cash register is not the place to look for shrinkage... it's the backdoor/lunchsack.
Quite true. I believe there are other people looking at that kind of shrinkage in addition to our efforts in examining the data.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 4, 2011 at 12:47 pm
Do you know what shrinkage is, from a data standpoint? Or is that where you are looking for guidance?
Once you define it, then you might play with the data mining algorithms a little, maybe even the Excel add-in to try and detect what you expect.
If you're looking for ways to define this, then I might ask managers how they detect it, other than catching someone in the act.
April 4, 2011 at 12:53 pm
Steve Jones - SSC Editor (4/4/2011)
Do you know what shrinkage is, from a data standpoint? Or is that where you are looking for guidance?Once you define it, then you might play with the data mining algorithms a little, maybe even the Excel add-in to try and detect what you expect.
If you're looking for ways to define this, then I might ask managers how they detect it, other than catching someone in the act.
That is one of the areas I'm looking for guidance. What kinds of patterns should I be looking for? I don't think they currently do detect it other than catching someone in the act. Someone ringing up the same order 10 times in an hour when that isn't usually rung up 10 times in an hour? Someone ringing up an unusually large sale? Someone ringing up 1000 ketchup packets as a side? Someone ringing up an unusually small sale?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 25,336 through 25,350 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply