Product Recommendations with SQL Server 2017

Use the graph features in SQL Server 2017 to perform market basket analysis and provide product recommendations for your users.

Get Started

1. Download the preview version of SQL Server 2017.
2. Create a Basket folder on the C drive.
3. Copy the Receipts.csv file to the Basket folder.
4. Create a Basket database.
5. Run the commands in the Basket.sql file.

References

• Million Song Dataset in SQL Server 2017
• An overview of Graph data in SQL Server
• Architecture details for Graph data in SQL Server
• The official sample for Graph data in SQL Server

Dataset Citation

The receipts.csv file is a reformatted version of the Groceries Data Set from Salem Marafi’s blog that can be found here.