International Journal For Multidisciplinary Research

E-ISSN: 2582-2160     Impact Factor: 9.24

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

Call for Paper Volume 6 Issue 1 January-February 2024 Submit your research before last 3 days of February to publish your research paper in the issue of January-February.

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
Short DOI

Share this