Strategic Car Sales using Finance Cluster Analysis
Added on 2020-01-07
20 Pages3862 Words158 Views
|
|
|
DATA HANDLING AND BUISNESS INTELIGENCE
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................3Part A...............................................................................................................................................3Reasons responsible for reduction in sales of company..............................................................3Pros and cons of excel.................................................................................................................5Part 2................................................................................................................................................8Reasons for using Weka to gain competitive advantage.............................................................8Merits and dermis of Weka in comparison to excel (Pros and cons of using excel for data analysis)8Application of J48 algorithm on data set in Weka......................................................................9Application of clustering method on Audi data.........................................................................11Modification of existing data.....................................................................................................17CONCLUSION..............................................................................................................................17REFERENCES..............................................................................................................................18Figure 1 Output table of decision tree in Weka...............................................................................8Figure 2Decision tree in Weka........................................................................................................8Figure 3 Cluster of finance and TT................................................................................................11Figure 4 Cluster of finance and A4................................................................................................12Figure 5 Cluster of finance and RS7..............................................................................................14
INTRODUCTIONAnalytics is the one of the fastest growing industry in the world. It is important to use business intelligence because it help one inidentifying reasons due to which business problem comes in existence. In this industry many software’s are used to analyze the factsand figures. In the current research study analysis of facts and figures is done by using excel software. Factors due to which salesdecline are also identified in the report. Apart from this Weka is also applied on the data that is related to Audi. Interpretation ofresults is done in proper manner. In this way entire work is done in the report.Part AReasons responsible for reduction in sales of companyFigure 1 Calculation of unit costFigure 2 Margin calculation per unit
Figure 3IF statement formulaFigure 4 IF statement formulaFigure 5Lookup formulaeOn analysis of all facts and figures that were given in the data set it is identified that discount and profit margin are the two mainreason due to which firm earn low profit in its business. It must be noted that big variation does not come in the earned margin amountwhen company is selling one product at high price and other one at low price. In some cases there is small of the product but margin ishigh. Contrary to this, in some cases price of product is high but low margin is earned on same. Lack of balance in earning of marginis responsible for declined in the firm sales. For example on row ID 2383 product is delivery truck and its sales price is 5472 andearned margin on same is 0.59. Opposite to this, in case of delivery truck that is on ID 2384 product is available at 1810 and earned
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents