A Study on Problems and Prospects of Data Visualization in Super Store using Data Analysis Tools

Smita Shashikant Patil; Babasaheb Jotiram Mohite

doi:10.36948/ijfmr.2024.v06i01.13203

A Study on Problems and Prospects of Data Visualization in Super Store using Data Analysis Tools

Author(s)	Smita Shashikant Patil, Babasaheb Jotiram Mohite
Country	India
Abstract	This study aims to investigate the challenges and opportunities associated with data visualization in superstores utilizing various data analysis tools. By understanding the problems faced and exploring the prospects of effective data visualization this research contributes to the enhancement of decision-making processes within retail sector. In the ever-evolving landscape of retail superstores rely heavily on data-driven insights to make informed decisions and enhance operational efficiency. The sales analysis on Superstore dataset is a comprehensive study that aims to analyze the sales performance of a fictional retail company called "Superstore". The dataset used in this analysis contains information about sales transactions, customers, products, and geographical locations. The analysis involves using Power BI, a data visualization and reporting tool, to create interactive dashboards and reports that provide insights into thesales performance of Superstore. The data is cleaned and transformed using Power Query, and a data model is created using Power BI's data modelling tools. The analysis includes several key metrics, such as sales revenue, profit, and margin, which are visualized using charts, tables, and graphs. The analysis also explores trends in sales over time, product categories, customer segments, and geographical regions. The results of the analysis provide valuable insights into Superstore's sales performance, highlighting areas of strength and weakness. The analysis reveals that Superstore's sales are strongest in the East and West regions of the United States, and that furniture is the most profitable product category. The analysis also identifies opportunities for improvement, such as increasing sales in the Central region and improving customer retention. Overall, the sales analysis on Superstore dataset provides a valuable tool for businesses to better understand their sales performance and make data-driven decisions to improve their sales processes.
Keywords	Sale Analysis,Research,SQL,Relationships,DAX optimization, Dashboard,Visualization.
Field	Computer Applications
Published In	Volume 6, Issue 1, January-February 2024
Published On	2024-02-10
Cite This	A Study on Problems and Prospects of Data Visualization in Super Store using Data Analysis Tools - Smita Shashikant Patil, Babasaheb Jotiram Mohite - IJFMR Volume 6, Issue 1, January-February 2024. DOI 10.36948/ijfmr.2024.v06i01.13203
DOI	https://doi.org/10.36948/ijfmr.2024.v06i01.13203
Short DOI	https://doi.org/gthqp4

View / Download PDF File

E-ISSN 2582-2160

doi

CrossRef DOI is assigned to each research paper published in our journal.

IJFMR DOI prefix is
10.36948/ijfmr

Downloads

Research Paper Format Copyright Permission Form and Undertaking Form Cover Page Vol 6 Isu 3 Cover Page Vol 6 Isu 2 Cover Page Vol 6 Isu 1

All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.

CC-BY-SA

About IJFMR Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us		+91-9898-5948-55	editor@ijfmr.com

International Journal For Multidisciplinary Research

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

A Study on Problems and Prospects of Data Visualization in Super Store using Data Analysis Tools

Share this