Scoring guide $($Rubric$)-$ SQL and Databases $-$ Project

Criteria Points

Answering the Business Questions

Total $10$ questions: $[1]$ Q$2,$ Q$3,$ Q$5,$ Q$7$ and Q$9$ carry each $3$ pts$.[2]$ Q$1,$ Q$4,$ Q$6,$ Q$8$ and Q$10$ carry each $2$ pts

$25$

Quarterly Business Report

$[1]0\mathrm{.}5$ pts for each metric present in the overview slide $($Total Revenue, Total Orders, Total Customers, Average Rating, Last Quarter Revenue, Last Quarter Orders, Average Days to Ship, $\%$ Good Feedback$)(0\mathrm{.}5*8)[2]$ Overall $8$ pts for observations $/$ findings $[3]$ Overall $8$ pts for insights and recommendations

$20$

SQL Query Hygiene

$[1]3$ pts for well formatted & indented SQL code $[2]2$ pts for standard naming conventions are followed $[3]2$ pts for aliases are given to aggregated columns

$7$

Report Design Elements

Overall $5$ marks for the following things below$-[1]1\mathrm{.}5$ pts for standard fonts used in the whole presentation $[2]1\mathrm{.}5$ pts for charts are cleanly visible with labels $[3]2$ pts for findings and observations are written in a crisp manner $[4]3$ pts for overall aesthetics and feel of the report $($Color choices, Font Sizes, Object Placements and Alignments, etc$)$