Unpicked sales in WorldWideImporters database causes purchases to increase indefinitely?
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
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.
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.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
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.
More from microsoft/sql-server-samples
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
microsoft/sql-server-samples#1499 ·
-
Difficulty 1/5 1-3 hours Newbie friendliness 76/100
microsoft/sql-server-samples#1495 · 3 reactions ·
-
Difficulty 1/5 Under an hour Newbie friendliness 62/100
microsoft/sql-server-samples#1341 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 64/100
microsoft/sql-server-samples#276 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 35/100
microsoft/sql-server-samples#1497 ·
All issues in microsoft/sql-server-samples
Similar issues
-
Add: BuyPass TV Openchannels:add check:passed
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
use-agent-os/agent-os#3312 ·
-
documentation help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
registrystack/registry-stack#1282 ·