Dataset Creation
Books are the tool which is used to obtain the knowledge, to communicate properly. It is have high demand for every book industry. In a shop book is bought for sale which is called as bookstore or bookshop. Books are sold at anywhere in any country. Even in libraries, we can buy or borrow the books. In 2010, there are 130,000,000 new titles are published in the google. Because of the introduction of e-books, the sale of books are lost, from 2015. To done the analysis, the books datasets are created with the help of excel, and the file is converted into csv file using online csv converter. Here the dataset consist of 1000 records Then this dataset is processed for data mining, predictive model and analysis with the help of software called Python. To done the analysis part, Python software is helpful to differentiate the analysis on basis of monthly sales with geographic region.
The research has been done with the help of dataset which is created using excel, which can be used to differentiate the analysis part. Some of the modern books are developed with the book layout (Rfwireless-world.com, 2018). A basic type of book consist of back cover, front cover, and content. In the body, it contains diagrams, tables, cited works, etc. The dataset consist of product name, product price, monthly sales from January to December, No, of customer, shipping type, Type of customers, which consist of 100 records (Learning, 2018). In addition the data should not taken from any of the network, it should be created by us (Lynda.com – from LinkedIn, 2018).
The dataset book consist of product name, product price, monthly sales from January to December, No, of customer, Shipping type, Type of customers etc,. Each of the data consist of 1000 of records the analysis will compare the monthly sales of the product, because the sales may differ from the January month to December month (Blackstone, n.d.). With the analysis of this monthly sales, the no. of customer levels are analysed and the type of customer also analysed and done. The price of the product may vary from one product to another product, based on the quality of the book. The books which helps in all levels. Fro the childhood book provide a major role (Shah, 2018). All of people done their education level with the help of this book. The type of the book may vary but the content of the book should not vary. Here the analysis of predictive model and data mining techniques are done with the help of the python software (Search Data Management, 2018).
Analysis of Sales
When Analyze Book Price vs Sales level, the level has both decreasing and increasing level from the month of January to the month of December (Learning, 2018). The value does not remains constant, as the sales profit depends upon the customer.
When compared to sales with customer type, there are two types of customer. They are Existing customer and new customer. It the growth of new customer is increased, then the product would become popular, and automatically the profit level gets increased. If the growth of Existing customer increased, profit level gets increased. While we compare with decrease in the number of new customer which would automatically decrease the sales level and profit level. If we compare with decrease in the number of existing customer, then the profit level and sales level gets decreased.
On analysis, with comparison of product name and sales, which product name has increased in the sales are considered. If the increased level of product is considered, then the profit level is increase. We have to focus on the increase in the product, once the product sales level gets increased, which means the customers are satisfied with that type of product. So, we tried to increase the quality of product which leads to increase the number of customer count. If the customer count is gets increased which leads to the increase sales level and profit level of the company.
People do not buy the products, they should buy the output of the product that may give. Based on the procedure of our dataset in which the customer felt satisfied while getting the outcomes of the products.
- If free shipping is provided, the customers level increases, the sales level also gets increased. So, the profit level reaches higher limit.
If free shipping is provided among customers, popularity gets increased. Eagerness will be there for the customers to buy products. So, the product sales gets increased automatically.
The innovative ideas to improve profit are
- If free products are provided, customer level gets increased.
- We have to increase the lead generation count in the sales, by increase the number of customer from 10 to 15 on day by day basis.
- The Lead generation provide you the ideas for sales training of how to speak with the customer or how to treat the customer.
- Increase the purchase level by decrease the profit level and increase the sales level
- Decreasing the value of gross profit is the main advantages to increase the sales profit. When the gross profit is increased there is increased in the level of customer. If the customer level gets increased which automatically leads to increase the profit level.
- If the product price level is kept less when compared to other company, then automatically all the customers focus on this company.
On refer to the analysis part, the data may vary with price, no. of customers, profit level, sales level, shipping type, etc. The content which includes the following (Brownlee, 2018)
- Product name – Name 1 to 1000
- Product price – vary to each and every product
- Monthly sales from January to December – sales level may vary
- Shipping type – Paid or Free products
- of Customer – the customer level may vary
- Geographical region – The region of sales may vary
Mainly the company is focused on sales level, and profit level. The sales level is depend on the purchase level of the customer, which is how the products are sold to the customer. The company depends on the profit (source, 2018). To increase the profit level, we have to increase the sales level. This is possible when the company decrease the level of profit on each and every product (Ori.hhs.gov, 2018).
Analysis of Customer Types
Customer need the book which is highly interest to read, and the price of the book is reasonable, and the content is in preferable language (Archive.learnhigher.ac.uk, 2018). To achieve the high level profit, the company should need the marketing people with suitable personality to convince the people. The company should need a advertisement. Proper advertisement will lead to proper increase in the customer level. If the customer level is increased the sales level and the profit level
Training should provided to increase the sales level, by providing online advertisement for the particular product. If the company provide the advertisement, the marketing level is reached to the customers. If we provide free home shipping or delivery, the customer gets eager to buy the products. Then the sales level of the product is increased with increase in the profit level. There are lots of steps are followed to increase the profit level. Free shipping and decrease in profit level are the main advantages to increase the profit level.
Conclusions
By analyzing the data containing 1000 records for the Books was successfully created with relational attributes. Here the dataset consist of Books name, Book price, Shipping type, Monthly sales (from January to December), Geographic region, No.of customer, Type of customers are successfully created. In this the price can be declared in the book price, and the variation of sales during the month period are mentioned in monthly sales. The analysis shown that the purchase of books level are both decreased and increased during the period, which is due to the marketing level, provision of free shipping, decrease in profit level with increase in sales level are successfully analyzed.
References
Blackstone, W. (n.d.). Commentaries on the laws of England. [S.l.]: Forgotten Books.
Learning, W. (2018). Weka – Graphical User Interference Way To Learn Machine Learning. [online] Analytics Vidhya. Available at: https://wwwanalyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/weka-gui-learn-machine-learning/ [Accessed 20 Feb. 2018].
Shah, P. (2018). An Introduction to Weka – open source for you. [online] Open Source For You. Available at: https://opensourceforu.com/2017/01/an-introduction-to-weka/ [Accessed 20 Feb. 2018].
source, O. (2018). Classification and clustering. [online] Ibm.com. Available at: https://www.ibm.com/developerworks/library/os-weka2/ [Accessed 20 Feb. 2018].
source, O. (2018). Introduction and regression. [online] Ibm.com. Available at: https://www.ibm.com/developerworks/library/os-weka1/ [Accessed 20 Feb. 2018].
Archive.learnhigher.ac.uk. (2018). Analyse This!!! – qualitative data – advantages and disadvantages. [online] Available at: https://archive.learnhigher.ac.uk/analysethis/main/qualitative1.html [Accessed 20 Feb. 2018].
Brownlee, J. (2018). How to Run Your First Classifier in Weka – Machine Learning Mastery. [online] Machine Learning Mastery. Available at: https://machinelearningmastery.com/how-to-run-your-first-classifier-in-weka/ [Accessed 20 Feb. 2018].
Dashboardinsight.com. (2018). Data Analysis Overview. [online] Available at: https://www.dashboardinsight.com/articles/new-concepts-in-business-intelligence/data-analysis-overview.aspx [Accessed 20 Feb. 2018].
Lynda.com – from LinkedIn. (2018). Data Analysis – Online Courses, Classes, Training, Tutorials on Lynda. [online] Available at: https://www.lynda.com/Data-Analysis-training-tutorials/1303-0.html [Accessed 20 Feb. 2018].
Ori.hhs.gov. (2018). Data Analysis. [online] Available at: https://ori.hhs.gov/education/products/n_illinois_u/datamanagement/datopic.html [Accessed 20 Feb. 2018].
Rfwireless-world.com. (2018). Advantages of Data Analytics,Disadvantages of Data Analytics. [online] Available at: https://www.rfwireless-world.com/Terminology/Advantages-and-Disadvantages-of-Data-Analytics.html [Accessed 20 Feb. 2018].
SearchDataManagement. (2018). What is data analytics (DA)? – Definition from WhatIs.com. [online] Available at: https://searchdatamanagement.techtarget.com/definition/data-analytics [Accessed 20 Feb. 2018].
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
