Ask a question from expert

Ask now

Data And Business Decision Making Assignment PDF

11 Pages2447 Words118 Views
   

Added on  2021-06-17

Data And Business Decision Making Assignment PDF

   Added on 2021-06-17

BookmarkShareRelated Documents
Running head: DATA AND BUSINESS DECISION MAKING REPORTData And Business Decision Making ReportName of the Student:Name of the University:Author Note:
Data And Business Decision Making  Assignment PDF_1
DATA AND BUSINESS DECISION MAKING REPORT1Executive SummaryThe purpose of this report is to analyse a business data and make decisions from that businessdata to show the client about the sales status both in terms of revenue and volume for variousproduct offerings. The dataset has 1046 records on seven variables (Power, Install, Product,Quote, Salesperson, Cost, and Contribution). This report shows the relationship between threevariables and also discusses about the client’s business performance measures where the client isa sales executive. There are four categorical variables Product, Power, Install, and Salesperson.To show the contribution of these variables, Pivot tables are created on “Pivot Table” sheet. Thisis a mixture of both qualitative and quantitative data. The report shows the analysis of theContribution variable based on the four qualitative variables. The given dataset has many scopesto work on it and all the analysis will be helpful for sales increase.
Data And Business Decision Making  Assignment PDF_2
DATA AND BUSINESS DECISION MAKING REPORT2Table of ContentsIntroduction......................................................................................................................................3Body.................................................................................................................................................3i.Pivot table for Product and Contribution..............................................................................4ii.Pivot table for Salesperson and Contribution.......................................................................5iii.Pivot table for Install and Contribution.............................................................................5iv.Pivot table for Power and Contribution............................................................................6Opportunities...............................................................................................................................7Issues............................................................................................................................................7Conclusion.......................................................................................................................................8References........................................................................................................................................9Appendix........................................................................................................................................10
Data And Business Decision Making  Assignment PDF_3
DATA AND BUSINESS DECISION MAKING REPORT3IntroductionThe given dataset shows all the sales related information of Star Solar Company. Thecompany has three product offerings –i.Basic which includes solar array and invertorii.Standard which includes solar array, battery storage, and invertoriii.Premium which offers solar array, invertor, and premium battery.Each product has six different size variations and the power of the products ranges from7.5kW to 20kW. There are four salesperson Lee, Raj, Mary, and Vlad. The Installvariable shows three types of installation - ground array, sinlge storey roof array, multi-storey roof array. The overall sales is quite good and it can be better by making strategicplannings. The existing sale is quite high for products of the standard range (Burns,Bushand and Sinha 2014). The scope for analysis is to use the measures Regression and Pivot tables. The regressionlines show the prediction of the dependent variable Contribution based on Quote, Cost,and Cont% variables. A single linear regression line has been created for each of thesequantitative variables (Hsiao 2014). The remaining four categorical variables have beentreated using the pivot tables where the pivot tables show the sum of the contribution andthe percentage of contribution for Product, Install, Salesperson, and Power. The problemtaken into account in this paper is to analyse how the sales can be increased and morerevenue can be generated by analyzing the given variables. It is an important step toanalyse the sales of any company to help the company to achieve more sales (Einav andLevin 2014). BodyThe study of this business case has the scope to analyse the sales data on the basis of thecost, quote, and percentage contribution of the products (Woodside 2013). The Pivot table hasbeen used here to show the relationship of Contribution with other categorical variables Product,Install, and Salesperson. The reason behind choosing the Pivot table is that it is one of the most
Data And Business Decision Making  Assignment PDF_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Big Data and Analytics - PDF
|8
|1869
|77

Business Analytics: Mathematical Model, Costing and Revenue Behaviour, Advertising Impact on Sales, and Break-Even Analysis for Basu Plc
|16
|4146
|162