Data Analysis and Visualization of Sales Dataset using Power BI

Abstract

Power BI has completely revolutionized the worlds of business intelligence, data visualization, and analytics. Power BI is an online service that allows users to search for data, transform it, visualize it, and share the reports and dashboards they create with other users in the same or different departments/organizations, as well as the general public. Power BI is used by over 200,000 organizations in 205 countries as of February 2017. Power BI\'s Quick Insights feature is an innovative feature that is built on a growing set of advanced analytical algorithms. This function may be activated with a single click after uploading a data set to Power BI, and it generates a number of reports depending on the data\'s analysis without any need for human participation. This also aids in reducing human errors in calculations and statistical techniques, which can lead to research that isn\'t verifiable. Power BI is simple to use and ready for adoption as a platform for Research Data Analysis, accepting even Excel spreadsheets as input. The pandemic of the coronavirus has hastened the adoption of mobile-friendly analytics and business intelligence platforms. Companies all over the world now want their employees and customers to have access to data and analytics from any location. The mobile BI market will be worth more than $20 billion by 2024, according to Mordor Intelligence. Furthermore, mobile devices such as smartphones and tablets are expected to account for more than 72 percent of all internet traffic. As a result, implementing mobile-friendly BI platforms across your organization in 2022 makes even more sense from a business perspective. The purpose of this paper is to show how Power BI can quickly transform a piece of research data into a set of shareable analytical reports and dashboards.

Introduction

I. INTRODUCTION

We are all always thinking about the future and what is expected to happen in the coming weeks, months, and even years, and in order to do so, a look into the past is required. Businesses must be able to see their development and the factors influencing their sales [1]. In this technological era of large-scale data, organizations must reconsider current techniques to better understand clients in order to achieve a competitive advantage in the market. Data is useless if it cannot be analyzed, comprehended, and applied in context [2]. In this effort, we leveraged AtliQ sales data to create business value. A picture is worth a thousand words, and business analytics may assist in creating a picture by visualizing data to provide retailers with business insights. With these insights, firms can make meaningful modifications to their future plan to maximize profitability and success. Most raw data, particularly large scale databases, are worthless in their unprocessed state. We can extract valuable insights from this stockpile of bits by using the Power BI tools [3]. The primary goal here is to read and analyze the available datasets from AtliQ in order to generate insights and an overall view of the firm. Any organization, business, or company's success is dependent on its sales department, because it is the sole element of the organization that earns revenue and money and brings it to the table. The significance of sales is as follows:

Sales data is a broad word that encompasses a wide range of indicators, but in general, if you can measure something in relation to the sales process, it's viable sales data. With such a broad definition of sales data, it might be difficult to decide where to focus your efforts

II. WHAT IS DATA ANALYSIS?

Data analysis entails establishing a dataset, studying it, cleaning it by removing any Na values or outliers, and converting it to generate a useful result.

Power BI is a cloud-based data analysis tool that extracts, visualizes, and provides real-time insight. Power BI brings together data from a range of sources to provide you a complete picture of your company's data assets. It also takes a 'big picture' approach, using current knowledge to analyse what has happened in the past to help you make better decisions in the future.

III. PROBLEM STATEMENT

AtliQ Hardware is an Indian firm that only sells computer hardware and peripherals in India. Surge stores, Nomad stores, and other stores can be found all over India. The company's headquarters are located in Delhi.

A. Scenario

The company's sales manager is up against a number of obstacles. He's having trouble keeping track of sales in a rapidly expanding market. He is having difficulties with his company's insights. To do so, he has some of the company's regional managers working for him in North, South, and Central India. So he dials their number and inquires about the information he seeks. They inform him of the sales and increase from the previous quarter. As a result, the issue is that the conversations are verbal. As a result, regional managers sugarcoat the truth, and the company's CEO is unaware of the facts. He is unable to act despite knowing that sales are dropping because he lacks a clear picture of the sales. The regional manager sends him with excel files after he requests the records. However, he is unable to make modest decisions using this method. All the management wants is a picture of the company's weakest sector, where it needs to focus in order to boost sales and improve performance. He's looking for easy-to-understand, digestible information. As a result, he's more interested in a dashboard where he can look at real data, because data speaks the truth. He only needs a simple data visualization tool that he can use on a regular basis.

As a result, by utilizing such tools and technology, one may make data-driven decisions that aid in increasing a company's sales.

As a result, in this project, we will assist a corporation in creating its own sales dashboard using Power BI.

IV. DATA DISCOVERY

A. AIMS Grid for Project Planning

AIMS grid is a four-part project management tool.

1. Purpose (what to do exactly)
2. Stakeholders (who will be involved)
3. End Result (What are your objectives)
4. Success Criteria (cost optimization and time save)

In our example, the final result will be the creation of a dashboard, and the success criteria will be increasing sales through cost optimization while saving time for the company's manager.

C. How will the Firms Operate?

The sales management system is owned by a group of software engineers (falcons). This system's entries are kept in a MySQL database.

The Data Analyst (Data Master) team contacts the software engineers to request access to the database, which they will use to generate the PowerBI dashboard.

In the same way, our project will be carried out. We'll get the data from the database via the company's website, then transform and import it into PowerBI to create the dashboard.

V. DATA ANALYSIS USING SQL

1. Step 1: Using MySQL Workbench to Import Data

The data is imported from a MySQL file that already exists. For further data analysis, this file must be loaded into MySQL Workbench.

The photo below demonstrates that the import was successful.

b. Filtering data in the Transactions Table

The intended output is produced when we perform the query in MySQL to filter some negative and zero values that appear in the table. Now we'll use PowerBI to accomplish the same filters.

We can remove the values we don't want from the table by deselecting them.

After filtration, the result. We need to sanitize that data because the zero values represent certain junk values that aren't possible.

c. Converting the Currency in the Transaction table from USD to INR

Because the company solely works in India, no USD figures can be calculated. As a result, we'll need to use some algorithms to convert those USD values to INR. Here, we'll create a new column and populate it with the translated currency value.

Obtaining the total values using USD as the currency.

We converted the USD currency into INR by applying the correct conversion procedure.

When we checked the filter, we came across something.. The USD is showing up twice for some reason. As a result, we'll now filter those values as well.

As a result, all USD values have been converted to INR.

VII. CREATING A REPORT OR A DASHBOARD

Dashboards and reports are built based on the requirements. After that, the dashboard is designed based on what the organization genuinely wants to search for and what is more vital to the company. There are many different ways to make a dashboard. In general, the dashboard should be simple to comprehend and use.

This is the dashboard once it has been entirely formatted.

A. Key Insights

Every year's overall performance and sales profit and loss are included in the key insights dashboard.

Conclusion

Overall, the objectives of this research were met. Through visualization, data analysis aids pupils in comprehending concepts. Various technologies are available to undertake corporate data analysis, however the Power BI visualization technique is the most popular technique for learning the fundamentals of data analysis. With the help of the visualization technique, data interpretation and data representation may be done quickly and easily. This strategy is highly useful for stronger conceptual design.

References

[1] Manpreet Singh, Bhawick Ghutla, Reuben Lilo Jnr, Aesaan F S Mohammedand Mahmood A Rashid, “Walmart\'s Sales Data Analysis - A Big Data Analytics Perspective” [Online]. Available: https://www.researchgate.net/publication/328246040_Walmart\'s_Sales_Data_Analysis_-_A_Big_Data_Analytics_Perspective [2] Sonia Singla, “Getting Started with Data Analysis using Power BI” [Online]. Available: [3] https://www.analyticsvidhya.com/blog/2021/11/getting-started-with-data-analysis-using-power-bi/Effective Businesss Intelligence Solutions, “BUSINESS INTELLIGENCE TRENDS IN 2022” [Online]. Available: https://ebisgroup.com/business-intelligence-trends-in-2022/ [4] Maggie Sparkman, David Iseminger, Michele Hart, Kent Sharkey, “Sales and Marketing sample for Power BI: Take a tour” [Online]. Available: https://docs.microsoft.com/en-us/power-bi/create-reports/sample-sales-and-marketing [5] Orina Mark , “Data Analytics and Visualization: A Comprehensive Guide” [Online]. Available: https://hevodata.com/learn/data-analytics-and-visualization/ [6] https://www.tutorialgateway.org/quick-insights-in-power-bi/

Copyright

Copyright © 2022 Ms. Sarika Singh, Ms. Lavina Jadhav. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.