MSC Management Data Driven Decision For Business Assignment Sample

Introduction and project plan

BIJ (Bangles International Jewellery) is a jewellery organization that helps to deal with the products with the customers for increasing the revenue of the company in the region of North America, Europe and Asia.

Along with that, it has handled various types of products for attracting customers from different regions so that the customers can buy products from this company. In addition to that, the company is increasing the sales all over the region to enhance the regions to make a profit with the extension of the market for which the sales manager can enhance their potential to sell the products.

Moreover, the company has different types of categories for which the customers can get varieties of products so that the revenue and profit of the company can increase the sales.

Furthermore, the company has extended the sales and products of the company to get enhancement the jewellery from the website portal of the company. In addition to that, the company has developed its website so that the customers can get choices of jewellery where the customers can buy the jewellery as per their expectations and prices.

The company has the biggest clients of the WFTT (Wood From The Trees) who want to increase their business in South America, Australia, or Africa as they cannot operate their business in these regions.

Further, as a junior consultant, the business analysis needs to be processed for the company to portray the business sales of the company for future aspects. Apart from that,

it can grow its business in other regions for making a profit from the products and the sales of the jewellery so a specific website is required to maintain the products and categories of the company (HURLEN et al. 2019).http://MSC Management Data Driven Decision For Business Assignment Sample

Further, it has maintained its website for which the consumers can buy and book any type of jewellery whenever they want from an online shopping website. Along with that, it has assisted to attract the attention of the customers for which the rate of sales can be increased rather than past sales.

It has worked on the categories of the products for providing a variety of jewellery products to the customers and it is now expanding a market campaign in the UK for conducting the data-driven research.

The products that the company is working on to stay in the jewellery business in the world for which it needs to maintain the quality of the jewellery for customers’ satisfaction. Furthermore, the data-driven application needs to be derived for business solutions for a certain company (Elfindah Princes, 2021).http://MSC Management Data Driven Decision For Business Assignment Sample

Along with that, the company needs to work on the products for which the sales manager needs to pressurize to increase the sales of the company. Besides that, it needs to focus on the other subsections of the products to not depend on a single product to do the business for extending the business of companies all over the world.

Data quality issues and remedies

The data quality needs to be checked before the data analysis of the company so that the business analysis can be perfect while the future aspect of the company can be forecasted (Fruhwirth, 2021). http://MSC Management Data Driven Decision For Business Assignment Sample

Further, it is required to verify the data from the database of the company whether it is not given for forecasting the sales of the company to get the actual analysis.

In this case, the dataset has been given for processing the analysis to get the data-driven analysis for which the production and marketing have been processed (Moro Visconti, Montesi and Papiro, 2018).http://MSC Management Data Driven Decision For Business Assignment Sample

Along with that, the dataset has been required to check for removing the null values from the dataset to get the actual dataset of the jewellery sales from the dataset where the sales managers can get the analysis of the dataset.

In addition to that, it has been shown that the quality of the dataset needs to be enhanced for improving the performance of the dataset for the analysis of the business of this company.

Furthermore, it is required to get the positive impact of the company so that the data driven analysis can be processed for the company to enhance its business operations of the company.

The quality of data needs to be checked at each step for conducting the business analysis of the company for analyzing the profit and loss rate for the years 2018, 2019 and 2020. Besides that, the product and marketing of WFTT can view the analysis of the company and whether the campaign has been going in a proper flow of path or not in the UK.

In addition to that, it is required to remove the rows from the dataset for conducting the dataset analysis for improving the performance where the company can gain profit and decrease the loss as well (van Hulzen, 2020). http://MSC Management Data Driven Decision For Business Assignment SampleThe dataset needs to be well qualified for the business analysis of the company for getting the benefits of the company for which the remedies are required to be implemented.

Furthermore, it is needed to execute the data for the analysis of the data where the dataset needs to be verified for the dataset analysis so that the implementation of the business case can be processed for the BIJ Company.

The remedies need to apply for the analysis of the dataset for the company where the jewelleries are required to qualify for attracting customers (Turi and Li, 2022).http://MSC Management Data Driven Decision For Business Assignment Sample

In addition to that, it has been shown that the dataset needs to be processed for removing the columns which are not required so that the analysis process can be displayed in a proper manner. Further, it has been conducted that the dataset is required to gain the performance and sales rate of the company to get the analysis in an actual format.

Data analysis and commentary

The data analysis has been processed here for getting the sales values from excel where the data analysis has been performed to get the sales chart with a better quality (Sala et al. 2022).http://MSC Management Data Driven Decision For Business Assignment Sample

Moreover, it has shown that data of the company has been simulated for getting the profit performance values from the dataset where the company has executed the campaign to know the sales rate.

Along with that, it has required to analyze the data for getting the actual outcome of the sales rate of the company for which the company can get the responses from the customers that it is giving positive results or not.

Figure 1: Evaluation of sales volume and value for the year of 2018 as per the given countries

(Source: Self-created)

The sales results have been projected for getting the sales values and volume of the company so that the evaluation of sales has been shown for the countries, which are Japan, US, UK and USA for the year of 2018.

Further, the sales values and volume have been calculated for the company so that the sales have been configured for which the excel sheet has been derived into three parts such as 2018, 2019 and 2020.

Moreover, the excel functions have been utilized for evaluating the sales values, which is “SUMIFS(E2:E179, D2:D179, “Accessory”, A2:A179, “JAPAN”)” for deriving the sales volume for the accessory product and Japan country.

Along with that, the sales value has been evaluated from the given excel data witty the help of excel functions “SUMIFS(F2:F179, D2:D179, “Accessory”, A2:A179, “United Kingdom”)” in a proper table format. The sales value and volume have been evaluated from the given data to get the excel values for the BIJ company for the year of 2018.

Figure 2: Evaluation of sales volume and value for the year of 2019 as per the given countries

(Source: Self-created)

The evaluation of sales has been evaluated for gathering the values of the dataset to calculate the sales of the company in different countries (Berndtsson et al. 2018).http://MSC Management Data Driven Decision For Business Assignment Sample Further, it has been seen that the sales values and volume have been evaluated from the dataset to get the sales values with the help of a summation function that has been derived in the excel software and the summation function has been described in the above part.

Moreover, the dataset analysis has been processed for the year of 2019 where the sales rate has been calculated with the given data by sorting the values and character values in the table chart. It has been analyzed that the sales values have been evaluated with sales values for getting the sales rate values for the year 2019 for the countries.

Figure 3: Evaluation of sales volume and value for the year of 2020 as per the given countries

(Source: Self-created)

The evaluation of sales for the company has been processed here for the year of 2020 that has been processed for the sales of BIJ. It has been evaluated from the excel for the analysis of the data so that the analysis of the company has been considered here.

Furthermore, it has been displayed that the calculation of sales has been conducted for the illustration of the data to get the exact calculation of the jewellery products for which the data analysis has been processed here. Along with that, the accessory, bracelet, ring, necklace and hair band have been valued for implementing the sales of the products for the BIJ Company to get the evaluation of the products.

It has been seen that the bracelet has the highest sales in the UK and USA whereas the sales of other products do not sell so much for the BIJ Company for which the company needs to be focused on other regions as well. Besides, it has helped to get the actual outcome of the company for which the sales volume has been going in a positive direction as the sales have increased in the US in 2020.

Data charting and commentary

The data chart has been processed to get the chart analysis for the business case for getting the data driven analysis (De Langhe and Puntoni, 2021). http://MSC Management Data Driven Decision For Business Assignment Sample

Further, the data driven campaign has been processed here for which the sales of the company for the years (2018, 2019 and 2020) have been conducted here with the help of an excel chart.

Along with that, it has been seen that the sales have increased with the increasing of years for the company where the chart has been evaluated. In addition to that, the excel chart for the company has been generated to get the sales as per the yearly sales for the countries where the sales have occurred.

Figure 4: Sales chart for the countries in the year 2018

(Source: Self-created)

The sales chart has been created here for all of the countries where the company has processed its sales (Luthfi and Janssen, 2019).http://MSC Management Data Driven Decision For Business Assignment Sample Further, it has been created for the jewellery products of the BIJ to get the outcome of the sales so that the sales can be projected in a specific manner.

Along with that, it has shown that the categorization of the products has been evaluated for the countries to get the actual sales profit and revenue of the company. The total values have been represented for the company to get the bar plot of the sales for the individual products so that it has seen that the hair band has the highest sales rate rather than other products. Besides that, it has been seen that the sale has mainly occurred in japan and no sales happen in the US.

Figure 5: Sales chart for the countries in the year of 2018

(Source: Self-created)

The chart has been developed using the data which has been calculated from the evaluation of sales where the excel valuation has been processed (Ali and Lande, 2019).http://MSC Management Data Driven Decision For Business Assignment Sample

Along with that, it has been shown that the jewellery products of the BIJ have been displayed in a graph to get the outcome of the sales so that the sales can be viewed in a good manner. In addition to that, it has shown that the types of products are shown as per the country basis to get the actual sales profit and revenue of the company.

Further, the total values have been represented for the company to get the line chart of the sales for the individual products so that it has seen that the hair band has the highest sales. Moreover, the rate of sales of other products is low whereas the sales have mainly occurred in Japan and UK and USA and there are no sales in the US.

Figure 6: Sales chart for the countries in the year of 2018

(Source: Self-created)

The chart has been generated here for all of the countries in which the sales have been conducted for getting revenue and profit (Priyadarshini, 2022). http://MSC Management Data Driven Decision For Business Assignment SampleMoreover, it has been created for the jewellery products of the BIJ to get the outcome of the sales so that the sales can be projected in a specific manner.

Along with that, it has shown that the categories of the products have been evaluated for the countries to get the actual sales profit and revenue of the company. Additionally, total values have been evaluated from the sales of the products to representing sales in a horizontal bar plot.

Apart from that, the company has given the sales analysis part to the junior consultant for deriving the market analysis for getting sales of the individual products. However, it has been seen that hair bands have the highest sales rate rather than other products whereas the sales have been mainly conducted in Japan. In addition to that, it has shown the sales rate of the company has increased with the increment of year for which the sales have occurred in the US as well.

Conclusions and recommendations

The research study has been processed here for the WFTT organization for which the sales rate of the BIJ company can be distributed and the profit can be seen in the UK as it is growing or not.

Furthermore, it can be concluded that the projection of sales has been evaluated for which the BIJ company can focus on the sales of the jewellery in the stated region as per the case study. Moreover, it can be concluded that the WFTT can analyze the jewellery products of the company for which ten marketing campaigns have been raised in the UK in 2020 .

for getting the sales aspect of the company. Along with that, it can be deduced that the future aspect of the sales has been evaluated for increasing the sales rate of jewellery products of the company among the regions.

It can be recommended that the company needs to focus on its sales as the sales of hair bands are more than other products. Hence, it can be suggested that the sales managers are required to enhance the sales of Rings, bracelets, accessories and necklaces to increase business sales. Along with that, the company needs to extend its business regions all over the world to increase the sales rate.

References

Ali, H. and Lande, M., 2019, November. Data-driven decisions in prototyping and product development: a framework for uncertainty and decision-making. In ASME International Mechanical Engineering Congress and Exposition, Salt Lake City (Vol. 83518, p. V014T14A039).

Berndtsson, M., Forsberg, D., Stein, D. and Svahn, T., 2018. Becoming a data-driven organisation. In 26th European Conference on Information Systems (ECIS2018), Portsmouth, United Kingdom, June 23-28, 2018.

De Langhe, B. and Puntoni, S., 2021. What Leaders Get Wrong About Data-Driven Decisions. MIT Sloan Management Review, 62(3), pp.10-12.

Elfindah Princes, W.K., 2021. DATA-DRIVEN ANALYTICS IN THE DECISION-MAKING PROCESS: DO WE STILL NEED INTUITION?. Journal of Southwest Jiaotong University, 56(4).

Fruhwirth, M., Pammer-Schindler, V. and Thalmann, S., 2021, January. A network-based tool for identifying knowledge risks in data-driven business models. In Proceedings of the 54th Hawaii International Conference on System Sciences (p. 5218).

HURLEN, L., FARBROT, J.E., DRØIVOLDSMO, A., REEGÅRD, K., OSLAND, P.O. and JENSSEN, L., 2019. Enabling data-driven decisions in power grid companies. In Human Factors Society Conference (p. 313).

Luthfi, A. and Janssen, M., 2019. Open data for evidence-based decision-making: Data-driven government resulting in uncertainty and polarization. International Journal on Advanced Science, Engineering and Information Technology, 9(3), pp.1071-1078.

Moro Visconti, R., Montesi, G. and Papiro, G., 2018. Big data-driven stochastic business planning and corporate valuation. Moro Visconti, R., Montesi, G., & Papiro, G.(2018). Big data-driven stochastic business planning and corporate valuation. Corporate Ownership & Control, 15(3-1), pp.189-204.

Priyadarshini, S., 2022. People Analytics: Data-Driven Approach to Manage People at Work. IJNRD-International Journal of Novel Research and Development (IJNRD), 7(3), pp.603-606.

Sala, R., Pirola, F., Pezzotta, G. and Cavalieri, S., 2022. Data-Driven Decision Making in Maintenance Service Delivery Process: A Case Study. Applied Sciences, 12(15), p.7395.

Turi, A.N. and Li, X.S., 2022. Data-Driven Decision-Making in Digital Entrepreneurship. International Journal of Industrial and Systems Engineering, 16(4), pp.122-127.

van Hulzen, G., 2020. Interactive Data-Driven Business Process Simulation. In ICPM Doctoral Consortium/Tools (pp. 7-8).