Review guided project: answering business questions using SQL

kevweo · June 14, 2020, 11:40pm

Hello everyone,
I would appreciate feedback on my guided project analysing data from the chinook database using SQL.

I would like some feedback on my analysis to answer the below additional practice business questions from the mission.

Which artist is used in the most playlists?
How many tracks have been purchased vs not purchased?

Thank you!

Please click here to access my guided project on GitHub:

kevweo/data-analytics/blob/master/Project to analyse customer and track sales in chinook digital store.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Project: analyse customer and track sales in chinook digital store\n",
    "The objective for this project is to analyse data from the chinook database, which has information about a fictional digital music shop - kind of like a mini-iTunes store.\n",
    "\n",
    "The chinook database contains information about the artists, songs, and albums from the music shop, as well as information on the shop's employees, customers, and the customers purchases. This information is contained in eleven tables, click [here](https://github.com/lerocha/chinook-database) to visit the github repository.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%capture\n",
    "%load_ext sql\n",

This file has been truncated. show original

Please click here to download file
Project to analyse customer and track sales in chinook digital store.ipynb (28.9 KB)

Click here to view the jupyter notebook file in a new tab

kevweo · June 16, 2020, 7:59pm

Hello everyone,

I made some updates, github link is same. I would appreciate some feedback, thanks!

Project to analyse customer and track sales in chinook digital store.ipynb (37.1 KB)

https://nbviewer.jupyter.org/github/kevweo/data-analytics/blob/master/Project%20to%20analyse%20customer%20and%20track%20sales%20in%20chinook%20digital%20store.ipynb

Click here to view the jupyter notebook file in a new tab

Rucha · June 19, 2020, 11:30am

hi @kevweo

Thank you for participating in the DQ community’s collaborative learning approach by taking your time and providing helpful inputs for the guided projects shared by fellow students.

Coming to your own project, I would encourage you to attempt the additional steps as well. Just in case you may or can try, add some graphical representations too.

Thank you for sharing your project with the community.

kevweo · June 19, 2020, 1:51pm

Thank you so much @Rucha , its great being part of the community. Okay, will definitely put in time and effort to try the additional steps as well and possibly include some graphs, thank you!