Data Analysis of Sainsbury Assignment Sample
Introduction
Data analysis refers to a process which is used as a purpose of cleaning, transferring and intercepting data to make important news, information and conclusion. It is used as a support system to make any important decision. In the process of data analysis, it included many types of facts and approaches which are mainly used to understand different types of business domains. In the current period of time, data analysis plays an important role in the business world which is used to make effective decisions and operate the business operations in a good manner. The process of data analysis is also used in the business to analyze the set of data to understand the performances of the company. This process compares different data of the company and finds effective results of the company. To find the actual performances of the business, business analysis used many effective techniques and processes. In the company data analysis process is also used to measure future results and analyze profitability and productivity of the company.
Theoretical framework
In the part of data analysis, Sainsbury used the procedure of data mining which helped to understand the business structure and sales data of the company. Sainsbury provides delicious and good quality foods at a reasonable price. The first store of the company was opened in 1869. The company inspired its customers by the taste and purity of the food. The main focus of the company is to increase the value of the food. Now this company has many stores and it also sells its food products through an online website. Sainsbury is the third most famous supermarket company in the US market. The company uses a data mining process, some important recommendations are provided to Sainsbury on the basis of a data analysis report. Sainsbury provides a big data set in five different ways (Zhu et al., 2018). This data helps to understand the enlargement of the company and its working experience. Big data of the company is mainly used to analyze the simulation of the company that helps the company to become more proficient and diligent and also reduce the time to fill the appropriations. Sainsbury used this big data to measure the procedure of the company. With the help of big data analysis companies have a chance to grow fast in the market. Sainsbury is one of the famous supermarkets of the US, even though this company faces many issues while using big data analysis (Osman, A.M.S., 2019). The measure issue related to big data analysis is to analyze the flow of data. The process of big data analysis is mostly dependent on the internet; if the internet connective faces an issue then it has the possibility of causing difficulties in the area’s flow of data. Big data analysis is mainly used to indemnify the areas which cause issues for the company. By using this process the company can easily find out the problem area and improve them to develop the performance of the company. On the other hand, this big data analysis process also helps the company to receive many opportunities from the market and find the path to reduce the cost of the company (Wang et al., 2018). By using big data analysis Sainsbury already improved its performance in the market. Sainsbury is a very big company and it’s able to use many advanced technologies in the process of business that help to easily handle the process of the company. Advanced technologies also help the company to collect all internal data automatically.
The main issues that are related to data analysis are completely dependent on some reasons. The technological system of the company has included the capability to collect all the data automatically. For the company it is very important to check all types of data which are related to the company’s process. After completing the process of data checking all data is centralized in the system. All the employees of Sainsbury allow access to the sources of the data to verify the data set (Mehta et al., 2018). The data which are centralized in the system give impact on the risk management area. The impact either positive or negative on the management is completely dependent on the quality of the data. Bad quality of data gives negative impact in the risk management and good quality of data gives positive impact on the risk management area. The process of data analysis is done to identify the effect of each process in the company. It also affects the budget of the company. Negative impact on the company’s budget gives a vital impact on the company’s performance and its reputation. Input data in the system is a very critical process (Mikalef et al., 2020). Therefore the company is required to input all the data in a very careful manner; otherwise it will have a very bad impact on the company. Company’s financial report and its cash flow position depend on the analysis of data. Data analysis is very important for the company.
Evidence of knowledge and Understanding of business intelligence
To gain knowledge about anything requires proper evidence. Evidence helps to understand the situation and provide actual information about the data. In the data analysis evidence refers to the data that are collected and analyzed to make an effective report to provide information of the data analysis. Business intelligence refers to skills of data analysis. It includes many processes such as collective important data, analysis and reports that provide lots of important information about the data (Elijah et al., 2018). To perform all the performance in an effective manner it requires skill of business intelligence. Analysis reports are used to make many effective decisions. Business intelligence has included many popular features that are used by the professional to data visualization and interactive dashboard.
Figure 1: Feature of business intelligence
It allows users to predict future performance of the company on the basis of a report of the data analysis. The professionals of business intelligence provide lots of information in the analysis that help you gain lots of knowledge (Singh et al., 2019). Business intelligence includes some benefits such as it used to key predictions, used to analyze the process of the business and it also helps to reduce the cost of the company and increase the profit of the company.
Critical analysis and justification of dashboard solution
Critical analysis mainly refers to a detailed examination of the data to evaluate the result of the company. Critical analysis of the data helps to identify the performance of the company. In this stage the important data of Sainsbury is critically analyzed to measure the performance of the Sainsbury (Galetsi et al., 2020). To identify the entire performance of Sainsbury, mainly focus on the company’s sales, gross margin, rating of products, income, quantity of customers and quantity of products.
Figure 2: Total sales of the Sainsbury
(Sources: Self created in MS Excel)
In the above figure, sales of Sainsbury are shown. The sales of the company are visually shown in the figure. The company mostly sells its product in three countries: Arizona, Oklahoma and Virginia. This figure shows the total number of sellers on the basis of countries. As per the report of the figure it is shown that the products of the company are more sold in Oklahoma compared to other two countries. As per the sale of the company Virginia is second and Arizona is third (Rehman et al., 2019). As per the report of the Arizona is measured that the products of the company are least sold in this country. Through the report of the figure it is identified the values of Sainsbury in the country. On the left side of the figure the numbers of sells show that help to understand the visual report of the company.
This figure shows the customers of Sainsbury. In the above figure the customers are divided as per male and female. In this particular figure it is shown that the number of male costumes and numbers of female costumes of the company is equal (Grover et al., 2018). It means both male and female customers are equally interested to buy products from this company and both are equally satisfied by the products of the company. In the above figure the red portion indicates the percentage of female and pink position of the figure indicates the percentage of male.
Figure 4: Average rating of Sainsbury’s products
(Sources: Self created in MS Excel)
Sainsbury is the most famous supermarket in the US; it sells various types of products such as electronic products, food products, fashion products, beauty products, and sports products and so on. This figure shows the rating of the products in separate categories. In the figure it is shown that among the all categories of the product, fashion accessories are the most sold in the company and get more ratings. Product rating shows the satisfaction level of the customers of using the products (Mikalef et al., 2018). As per the report of the figure it is found that customers of the company are more satisfied with the fashion products sold by the company. The company also sells health and beauty products and the figures show that these products get the least rating. It identifies that customers of the company are least satisfied by the home and beauty related products that are sold by the company.
Figure 5: Income of the company through different modes
By selling the products the company generates revenue. During selling the company allows costumes to be paid money by using different modes such as cash, credit and Ewallet. This figure shows the use of modes by the customers for purchasing the products of the company (Vassakis et al., 2018). The dark blue portion of the figure show the income of the company through the cash mode, sky blue portion of the figure show the income of the company through the credit mode and light blue portion show Ewallet mode uses by the customers to pay the money for the products of the company.
This figure helps to identify the customers of Sainsbury based on the countries. The costumes that are purchased more times are known as the members of the company and the costumes who buy the products one or two times from the company are called the Norman costumes of the company. This Figure shows both members and normal customers of the company as per the country. The data of the costumes are collected from three countries and the figure shows the result as per the collected customer’s data of the company. In figure 1 it is identified that the products of the company are mostly sold in Oklahoma (Dai et al., 2019). Therefore the numbers of customers are most in the Oklahoma. In the above figure it is shown that the Oklahoma has more costumes of Sainsbury. Among the categories of normal and members, normal customers are more than members.
Sainsbury is a famous supermarket in the US and it sells products in lots of categories. In the above figure the quantity of the products that are sold by the company are shown. All the categories of the product are shown by using different colors in the figure. In this figure it is shown that the quantity of fashion of products is more than other products of the company. It means mostly customers of the company are buying fashionable products of the company and they are fully satisfied (Bag et al., 2020). The quantity of other products of the company is less than fashionable products of the company. In this figure it is also showing that the quantity of health and beauty products is least among the all products of the company.
In this figure the sum of rating of the product and the sum of quantity of the product is shown. Both the sum of ration and the sum of quantity are separately shown as per the country (Bhattarai et al., 2019). As per the above figure, the sum of rating and the sum of quantity is equal in all the countries. Blue porting of the figure shows the sum of rating and quantity of Oklahoma, red portion of the figure shows the sum of rating and quantity of Virginia and the green porting shows the sum of rating and quantity of Arizona.
Recommendation
In this assignment the data of the Sainsbury is analyzed and uses a dashboard report to understand the performance of the company. All the data of the company is critically analyzed and based on the report of the analysis some recommendation for the company is provided (Ghofrani et al., 2018). To measure the performance of the company, firstly sales data of the company is analyzed and found that sales of Arizona and Virginia are less company to Oklahoma.
Following recommendation is provide for the company to improve its performances:
- In the area of sales, companies are required to apply an effective strategy to improve the sales performance of the company.
- Among varieties of products customers of the company is mostly satisfied by the fashionable products so therefore the company requires improving the quality of other products.
- To increase the level of customers in other countries, companies are required to apply strategies such as offers and discounts that help to attract the customers to buy the products of the company.
- Mostly fashionable products are sold in the company, so companies need to add more varieties in the products in the different categories to increase the quantity of other category products.
- Companies require developing the quantity of the products to achieve more rating on the products. Rating on the products help to improve the reputation of the company in the market.
Conclusion
At the stage of conclusion the entire assignment is concluding in briefly. This assignment discusses data analysis. Data analysis refers to a process which helps to understand the performance of the company. Data analysis is very important for the company; it helps the company to identify issues that affect the performance of the company. By identifying the issues, companies have a chance to resolve the issue and improve the performance of the company. In this assignment, the data of Sainsbury is analyzed to measure the business performance of the Sainsbury. Sainsbury is a famous supermarket in the US. It sells different categories of products. The main focus of this company is to provide tasty and healthy and quality products to the customers. To indemnify the performance of the Sainsbury, data of the company is critically analyzed. The report of the analysis is shown visually by using charts and graphs in the dashboard. The colorful chart and graph used to make the assignment more effective and make it easy to understand the performance of the company. Based on the report of the collected data of Sainsbury, some recommendations for the company are also provided that may help the company to improve its performance and also help to perform better in the market.
Reference List
Journal
Osman, A.M.S., 2019. A novel big data analytics framework for smart cities. Future Generation Computer Systems, 91, pp.620-633.
Wang, Y., Chen, Q., Hong, T. and Kang, C., 2018. Review of smart meter data analytics: Applications, methodologies, and challenges. IEEE Transactions on Smart Grid, 10(3), pp.3125-3148.
Mehta, N. and Pandit, A., 2018. Concurrence of big data analytics and healthcare: A systematic review. International journal of medical informatics, 114, pp.57-65.
Elijah, O., Rahman, T.A., Orikumhi, I., Leow, C.Y. and Hindia, M.N., 2018. An overview of Internet of Things (IoT) and data analytics in agriculture: Benefits and challenges. IEEE Internet of Things Journal, 5(5), pp.3758-3773.
Singh, S.K. and El-Kassar, A.N., 2019. Role of big data analytics in developing sustainable capabilities. Journal of cleaner production, 213, pp.1264-1273.
Galetsi, P., Katsaliaki, K. and Kumar, S., 2020. Big data analytics in health sector: Theoretical framework, techniques and prospects. International Journal of Information Management, 50, pp.206-216.
ur Rehman, M.H., Yaqoob, I., Salah, K., Imran, M., Jayaraman, P.P. and Perera, C., 2019. The role of big data analytics in industrial Internet of Things. Future Generation Computer Systems, 99, pp.247-259.
Grover, V., Chiang, R.H., Liang, T.P. and Zhang, D., 2018. Creating strategic business value from big data analytics: A research framework. Journal of Management Information Systems, 35(2), pp.388-423.
Mikalef, P., Pappas, I.O., Krogstie, J. and Giannakos, M., 2018. Big data analytics capabilities: a systematic literature review and research agenda. Information Systems and e-Business Management, 16(3), pp.547-578.
Vassakis, K., Petrakis, E. and Kopanakis, I., 2018. Big data analytics: applications, prospects and challenges. In Mobile big data (pp. 3-20). Springer, Cham.
Dai, H.N., Wong, R.C.W., Wang, H., Zheng, Z. and Vasilakos, A.V., 2019. Big data analytics for large-scale wireless networks: Challenges and opportunities. ACM Computing Surveys (CSUR), 52(5), pp.1-36.
Bag, S., Wood, L.C., Xu, L., Dhamija, P. and Kayikci, Y., 2020. Big data analytics as an operational excellence approach to enhance sustainable supply chain performance. Resources, Conservation and Recycling, 153, p.104559.
Bhattarai, B.P., Paudyal, S., Luo, Y., Mohanpurkar, M., Cheung, K., Tonkoski, R., Hovsapian, R., Myers, K.S., Zhang, R., Zhao, P. and Manic, M., 2019. Big data analytics in smart grids: state‐of‐the‐art, challenges, opportunities, and future directions. IET Smart Grid, 2(2), pp.141-154.
Ghofrani, F., He, Q., Goverde, R.M. and Liu, X., 2018. Recent applications of big data analytics in railway transportation systems: A survey. Transportation Research Part C: Emerging Technologies, 90, pp.226-246.
Mikalef, P. and Krogstie, J., 2020. Examining the interplay between big data analytics and contextual factors in driving process innovation capabilities. European Journal of Information Systems, 29(3), pp.260-287.
………………………………………………………………………………………………………………………..
Know more about UniqueSubmission’s other writing services:
