microsoft / microsoft/sql-server-samples
Unpicked sales in WorldWideImporters database causes purchases to increase indefinitely?
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
I am exploring this data a little to learn both SQL and PowerBI. From what I've seen, the generated purchases from suppliers are based on previously made orders by customers that have gone unpicked. However, 9 products seem to have unpicked orders from 2013 through to 2016 that seems to accumulate, leading to purchases on these stock items to keep increasing indefinitely. This issue was expounded when I ran the PopulateDataToCurrentData procedure.
Is this an issue on my end? I feel like these early orders should get picked at some stage and not be continually brought in to purchase calculations.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the WorldWideImporters data-generation logic and the PopulateDataToCurrentData procedure. Trace how unpicked customer orders from 2013–2016 affect purchase calculations for the nine products, then determine whether the accumulating purchases are expected or indicate a defect. Done means the behavior is explained and, if incorrect, the relevant procedure or data logic is corrected with appropriate verification.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100