Udacity Business Analytics Nanodegree program is divided into 3 modules culminating in a project after each module.
- Introduction to Data
- Using SQL for Data Analysis
- Data Visualization in Tableau
This project Query a Digital Music Store Database follows the learning covered in the second module Using SQL for Data Analysis.
|The student can write error-free SQL queries.||All SQL queries run without errors and produce the intended results.|
|The student can use joins correctly in SQL queries.||Each SQL query needs to include one or more explicit join(s). The query's JOIN or JOINs should be necessary to answer the question. If a question does not require a JOIN, please change the question to be one that does.
JOIN Track on Track.AlbumID = Album.AlbumID
|The student can use aggregations correctly in SQL queries.||Each SQL query needs to include one or more aggregation(s). This could be a COUNT, AVG, SUM, or other aggregation.|
|Student can answer multiple questions by using SQL||The student has used at least 4 unique SQL queries in their submission.|
|The student’s slides are organized well and are easy to read and understand.||Each slide should have an appropriate title, and the visualization descriptions should be free of significant factual, spelling, and grammar mistakes.|
|The student can create data visualizations that provide useful information.||All visualizations should make logical sense and provide accurate information about the indicated area.|
|The student can format data visualizations clearly and make good use of labeling.||All visualizations include a title and axis labels, have a legend where applicable, and are easily understood.
Every visualization should have
|The student has uploaded all files necessary for review.||A PDF report has been uploaded, and a .txt file with the queries has been uploaded in a single zipped folder file|