Data Analytics Study Case : SuperMarket Sales

[sowmya12345]

Here is the description of the attributes in the csv of sales data

• Invoice id: Computer generated sales slip invoice identification number
• Branch: Branch of supercenter (3 branches are available identified by A, B and C).
• City: Location of supercenters
• Customer type: Type of customers, recorded by Members for customers using member card and Normal for without member card.
• Gender: Gender type of customer
• Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports and travel
• Unit price: Price of each product in dollars
• Quantity: Number of products purchased by customer
• Tax 5%: tax fee for customer buying
•  
• Total: Total price including tax
• Date: Date of purchase (Record available from January 2019 to March 2019)
• Time: Purchase time (10am to 9pm)
• Payment: Payment used by customer for purchase (3 methods are available – Cash, Credit card and Ewallet)
• COGS: Cost of goods sold
• Gross margin percentage: Gross margin percentage
• Gross income: Gross income
• Rating: Customer stratification rating on their overall shopping experience (On a scale of 1 to 10)
  
  I have created a powerbi report for the same, So what i dont understand is how to know if i have covered everything and if i am missing any links between any other attributes which can have interesting observations. How do i know this? I am a beginner in data analysis. I am attaching my screenshot of my pbix file
  

[sowmya12345]

Thank you, Can you review my dashboard if possible

[Ritaf1983]

Hi @sowmya12345 

This is an interesting and challenging question, especially for someone who is just starting in data analysis. To answer the user's query, I would suggest the following steps:

1. Data Review:

• Start by reviewing the data structure in the CSV file. Are all the columns mentioned in the description present in your file? Are there additional columns that were not mentioned?
• Check the completeness of the data – are there any missing values or other quality issues?

2. Examining Relationships Between Data:

• Ensure that you are using the correct relationships between the different tables or fields. For example, is every field directly or indirectly related to the "Total" or "Gross Income" fields? Are there other logical relationships that could provide interesting insights?
• Consider analyzing dependencies between different fields, such as the impact of "Customer type" on gross income or the impact of "Product line" on customer rating.

3. Use of Visualizations:

• Ensure you cover all aspects of the data using appropriate visualizations. For instance, have you used charts that show relationships between different data points? Are there insights that are not clearly presented?
• Try creating separate reports based on different segments (e.g., by customer type or product type) to see if there are additional insights that weren't revealed in the general report.

4. Using Models and Functions:

• Consider using advanced Power BI functions to explore more complex relationships in the data. For example, is there a correlation between the time of day and the type of product sold or the payment method used? Is there a field from which you can calculate an additional metric that might interest you?

5. Comparative Analysis:

• Make sure you are comparing the data to industry averages or standards if possible. Check for any anomalies that may indicate the need for further investigation.

6. Requesting Feedback:

• Post the report (not a snapshot) on the forum and ask for feedback from the community. You can request suggestions for improvements or additional checks that you might have missed.

This is a process that requires patience, curiosity, and the use of various data analysis tools. As you gain more experience, you'll be able to discover and understand more relationships between the data and generate new insights

If previous post helped, then please consider Accepting it as the solution to help the other members find it more quickly