Exploratory Analysis Dashboard for Super Store Corporation

by | Jul 6, 2024 | business

create a dashboard for a given scenario and a data set.
Scenario: Imagine you are an analyst working for the Super Store Corporation. Your boss Shanice is the VP of Sales and she is conducting a review of the company discount policy. As research for her review, she has asked you to perform an exploratory analysis of the Super Store discount data. Specifically, Shanice has asked you to investigate if there is a relationship between discounted sales and profit, and how much the company is profiting or losing based on discounted sales. She also wants to see if there are opportunities for efficiencies with respect to how discounts are handled. Perhaps certain customers are receiving more discounts than other customers. Perhaps certain product categories or product segments are receiving more discounts than others. Shanice has given you wide latitude to explore this question however you see fit and will ultimately make a recommendation to the board of directors based on your findings.

The business question you will answer with the data is Are discounted orders more or less profitable than non-discounted orders?

Next, . Then, explore the Superstore dataset and identify the key performance indicators (KPIs) that will be needed to answer the business question for this project. Write a description of your KPIs, with a brief explanation of why you made that information as key to answering the business question.

For more information about key performance indicators, watch the following video:

Video: (4:55)
Next, create a dashboard consisting of at least 2 KPIs, you identified, that will be used to answer the business question for this project. Your KPIs must apply at least two different principles around around KPIs:

Hierarchies
Actions
Filters
Parameters to guide interactivity (if needed)
Possible KPIs to consider for this project are:

Discounts per customer
Discounts by category
Discounts by segment
Discounts by quantity
Discounts by profit ratio
Finally, you will create the final deliverable dashboard for Shanice to present your analysis to company stakeholders. The story must consist of at least three story points and must explicitly answer the business question(s) in the project brief, specifically: are discounted orders more or less profitable than non-discounted orders?

 

 

Sample solution

Dante Alighieri played a critical role in the literature world through his poem Divine Comedy that was written in the 14th century. The poem contains Inferno, Purgatorio, and Paradiso. The Inferno is a description of the nine circles of torment that are found on the earth. It depicts the realms of the people that have gone against the spiritual values and who, instead, have chosen bestial appetite, violence, or fraud and malice. The nine circles of hell are limbo, lust, gluttony, greed and wrath. Others are heresy, violence, fraud, and treachery. The purpose of this paper is to examine the Dante’s Inferno in the perspective of its portrayal of God’s image and the justification of hell. 

In this epic poem, God is portrayed as a super being guilty of multiple weaknesses including being egotistic, unjust, and hypocritical. Dante, in this poem, depicts God as being more human than divine by challenging God’s omnipotence. Additionally, the manner in which Dante describes Hell is in full contradiction to the morals of God as written in the Bible. When god arranges Hell to flatter Himself, He commits egotism, a sin that is common among human beings (Cheney, 2016). The weakness is depicted in Limbo and on the Gate of Hell where, for instance, God sends those who do not worship Him to Hell. This implies that failure to worship Him is a sin.


This question has been answered

God is also depicted as lacking justice in His actions thus removing the godly image. The injustice is portrayed by the manner in which the sodomites and opportunists are treated. The opportunists are subjected to banner chasing in their lives after death followed by being stung by insects and maggots. They are known to having done neither good nor bad during their lifetimes and, therefore, justice could have demanded that they be granted a neutral punishment having lived a neutral life. The sodomites are also punished unfairly by God when Brunetto Lattini is condemned to hell despite being a good leader (Babor, T. F., McGovern, T., & Robaina, K. (2017). While he commited sodomy, God chooses to ignore all the other good deeds that Brunetto did.

Finally, God is also portrayed as being hypocritical in His actions, a sin that further diminishes His godliness and makes Him more human. A case in point is when God condemns the sin of egotism and goes ahead to commit it repeatedly. Proverbs 29:23 states that “arrogance will bring your downfall, but if you are humble, you will be respected.” When Slattery condemns Dante’s human state as being weak, doubtful, and limited, he is proving God’s hypocrisy because He is also human (Verdicchio, 2015). The actions of God in Hell as portrayed by Dante are inconsistent with the Biblical literature. Both Dante and God are prone to making mistakes, something common among human beings thus making God more human.

To wrap it up, Dante portrays God is more human since He commits the same sins that humans commit: egotism, hypocrisy, and injustice. Hell is justified as being a destination for victims of the mistakes committed by God. The Hell is presented as being a totally different place as compared to what is written about it in the Bible. As a result, reading through the text gives an image of God who is prone to the very mistakes common to humans thus ripping Him off His lofty status of divine and, instead, making Him a mere human. Whether or not Dante did it intentionally is subject to debate but one thing is clear in the poem: the misconstrued notion of God is revealed to future generations.

 

References

Babor, T. F., McGovern, T., & Robaina, K. (2017). Dante’s inferno: Seven deadly sins in scientific publishing and how to avoid them. Addiction Science: A Guide for the Perplexed, 267.

Cheney, L. D. G. (2016). Illustrations for Dante’s Inferno: A Comparative Study of Sandro Botticelli, Giovanni Stradano, and Federico Zuccaro. Cultural and Religious Studies, 4(8), 487.

Verdicchio, M. (2015). Irony and Desire in Dante’s” Inferno” 27. Italica, 285-297.

Sample Answer

Sample Answer

 

 

 

 

Exploratory Analysis Dashboard for Super Store Corporation

Introduction

As an analyst at Super Store Corporation, the VP of Sales, Shanice, has tasked you with conducting an exploratory analysis of the company’s discount data to determine the relationship between discounted sales and profit. The key business question this analysis aims to answer is: Are discounted orders more or less profitable than non-discounted orders?

Key Performance Indicators (KPIs)

To address the business question effectively, the following KPIs have been identified along with a brief explanation of their significance:

1. Discounts per Customer: This KPI will help identify if certain customers are receiving more discounts than others, highlighting potential inefficiencies in discount allocation and customer segmentation.

2. Discounts by Category: Analyzing discounts by product category can reveal if specific product categories are consistently offered higher discounts, indicating potential pricing strategies or market demand variations.

3. Discounts by Segment: Understanding how discounts are distributed across different market segments can provide insights into customer preferences and the effectiveness of targeted marketing strategies.

4. Discounts by Quantity: Examining discounts based on order quantity can reveal if bulk purchases are being incentivized through discounts, impacting overall profitability.

5. Discounts by Profit Ratio: Calculating the profit ratio for discounted orders compared to non-discounted orders can directly address the business question by determining which type of orders are more profitable.

Dashboard Design

Story Points:

1. Overview of Discount Analysis: Provides a summary of total discounts given, average discounts per order, and overall profit distribution between discounted and non-discounted orders.

2. Customer and Category Insights: Explores discounts per customer and by category, highlighting top customers receiving discounts and categories with the highest discount rates.

3. Profitability Analysis: Compares profit ratios between discounted and non-discounted orders, showcasing the impact of discounts on overall profitability.

Dashboard Components:

– Hierarchies: Users can drill down from an overview of discounts to detailed insights on customers and product categories.

– Actions: Interactive elements allow users to filter data based on specific customer segments or product categories for more targeted analysis.

– Filters: Users can adjust parameters to compare different time frames or regions for a comprehensive view of discount trends.

By leveraging these KPIs and interactive dashboard features, Shanice will be equipped to present a comprehensive analysis to company stakeholders, addressing the key business question on the profitability of discounted versus non-discounted orders. This dashboard will facilitate data-driven decision-making and provide valuable insights for optimizing the company’s discount policy.

This question has been answered.

Get Answer