Data Analysis & BI: Retail Operation Insights and Efficiency

This report analyzes a retail organization's data using Tableau to establish the relationship between average sales and average profits across different product categories (office supplies, furniture, and technology). The analysis identifies sales and profitability trends, comparing average discounts and total discounts offered on various product categories. The findings indicate that fax and copiers within the technology category have the highest sales and profitability, despite having the highest average discounts. The report concludes by highlighting the importance of understanding these relationships for informed business decision-making and provides a list of references. Desklib provides access to this and similar solved assignments for students.

BUSINESS DECISION ANALYSIS

INTRODUCTION
• The organization which is considered deals in office supplies,
furniture and technology products categories.
• The presentation would be aim to establish a relationship between
the average sales and average profits which is generated by the
business.
• To gain insights into the functioning of the retail organization
“Tableau” is used.

CONCLUSION
• The above analysis effective shows the relationship between average profits and average sales
which is generated from the three category profits which is offered by the business. The
relationship between averages and average profits is shown on the basis on product wise as
well as quarter wise.
• In addition to this, comparison is also made on the basis of average discounts and average total
discounts which is offered on the three categories of products.
• The graphical presentation shows that fax and copiers which forms a part of technology goods
have highest sales and profitability even though the average discounts on the same is also
highest.

REFERENCE AND
BIBLIOGRAPHY
• Anderson, E., Malin, B.A., Nakamura, E., Simester, D. and Steinsson, J., 2017. Informational rigidities and the stickiness
of temporary sales. Journal of Monetary Economics, 90, pp.64-83.
• Choi, H., Medlin, D. and Hunsinger, S., 2017. The effects of discount pricing strategy on sales of software-as-a-service
(SaaS): online video game market context. Journal of Information Systems Applied Research, 10(1), p.55.
• Gandy, D.L., 2015. Small business strategies for company profitability and sustainability.
• Lee, M. and Law, D., 2018. Frankie (2015); The discount framing in different pricing schemes: Combined versus
partitioned pricing. Journal of Social Sciences (COES&RJ-JSS), 4(1), pp.705-725.
• Mathuva, D., 2015. The Influence of working capital management components on corporate profitability.
• O'brien, J., 2015. Category management in purchasing: A strategic approach to maximize business profitability. Kogan
Page Publishers.
• Scott, J.T., 2017. The Sustainable Business: A Practitioner's Guide to Achieving Long-Term Profitability and
Competitiveness. Routledge.
• Shahriar, A.Z.M., Schwarz, S. and Newman, A., 2016. Profit orientation of microfinance institutions and provision of
financial capital to business start-ups. International Small Business Journal, 34(4), pp.532-552.

THANKING YOU