ANL203: In the real world of data analysis, when you are not querying the database directly and data is provided to you: Analytics for Decision-Making Assignment, SUSS, Singapore

In the real world of data analysis, when you are not querying the database directly and data is provided to you, it is essential to evaluate the data and ask pertinent questions about the data quality. It enables us to confirm the validity of any insights drawn from the data. The provided dataset contains transaction records from an online retailer.

Each record represents a transaction involving a unique product and a specific customer on a certain day. The Quantity displays the total number of units sold, and the Price displays the Product Code unit price. There may be more than one Product Code in a Receipt. Location is a representation of the customer’s country, and Description is a description of the product.

• Identify one (1) business question statement that can be answered by analyzing the dataset Retail_ TMA.xlsx. Your description should clearly explain what data fields are relevant and how the data fields can be used to answer the business question.
• Create a summary of the dataset Retail_ TMA.xlsx in tabular format. You should identify each data field’s type, examine individual variables, and calculate summary measures when applicable.
• Prepare the dataset Retail_ TMA.xlsx in a form suitable for analysis by fixing the data issues and errors with an explanation and justification of necessary data transformations. Illustrate any necessary data preparation with an example screenshot.
• Employ two graphical charts and one (1) pivot table to present the key features of the data variables or to explore the relationship among the variables in the dataset Restaurant_Grades.xlsx. You may use any software tool to produce the proposed graphical charts and the pivot table. Provide a screenshot of each produced chart/pivot table.