TopAceEssays

Using SQL for Data Analysis // Project: Music SQL Database SQL Queries Criteria Submission Requirements 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. The JOIN or JOINs should be necessary to the query. If a question does not require a JOIN please change the question to be one that does. Example: SELECT * FROM Album 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. 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. Presentation Criteria Submission Requirements The student’s slides are organized well and are easy to read and understand. Each slide should have an appropriate title and the visualization desсrіptions 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 chart title x axis title x axis labels y axis title y axis labels Submission Phase Criteria Submission Requirements 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 Suggestions to Make Your Project Stand Out To make you project standout, consider the following: Look for interesting patterns and insights in the data rather than simply providing summary statistics. Use other advanced SQL functions, such as the case function. Make good use of color, size, and shape in your visualizations. Use the slide title and/or chart desсrіption on each slide to state the key insight of the visualization. /// This is what the presentation entails: Your presentation should include: Four slides One visualization per slide A 1-2 sentence explanation of each slide The SQL query is used to create the data used in the visualization.

Get Homework Help Now