We need the add the data from the Needful Things - we are going to use a local SQLite database for the tutorial.
Download the SQLite database here and put it in your my-project folder, renaming the file to
Your folder should now look something like this:
- Navigate to the settings menu in the bottom left corner of the Homepage, and connect the SQLite database.
needful_things.db database has 3 tables:
- ORDERS: data on customer orders, with one row per order (containing only one item each)
- MARKETING_SPEND: data showing how much Needful Things has spent on each paid marketing channels per month
- REVIEWS: stores customers reviews for some orders, which are Net Promoter Scores (NPS) on a scale of 0-10