Excel in Data Visualization Worksheet
Step 0: Understand the dataStep 1: Define tables and change table namesStep 2: Set relationships among tables : is to link the tables using identifiers. Primary Key: an attribute (column) that uniquely identifies each row (observation) in a tableForeign Key: the other tables primary key that is in current table and will be used to link the other table. Step 3: Set and modify attributes for Visualizations using pivot table and pivot chartStep 4: Output bar chart for Total sales amount by store locationsStep 5: Output bar chart for sales amount of Hypericum by store locations
