'''[https://wikidev.taticview.com/taticfiles/Sales.xlsx Donwload]''' Download the example worksheet, using the Sales Spreadsheet and link below, replace it with your data and update the [[Data Sources|datasource]] to start analyzing immediately and improve the management of your business management.
If you do not have all the available data, leave the corresponding columns blank.
[[Special:FilePath/Sales.xlsx|Download Sample Worksheet]]
Sales Spreadsheet Information:
Paragraph* '''Order Date''': Date on which the sale was made* '''Delivery Date''': Date on which the order was delivered* '''Branch''': Affiliate which performed the sale* '''Group''': Group to which belongs the sold product* '''Product''': Name of the sold product* '''Customer''': Customer name* '''City''': City where the customer lives* '''State''': State where the customer lives* '''Region''': The region of the country where the customer lives* '''Salesman''': Name of the salesperson who performed the sale* '''Quantity''': Quantity sold of a product* '''Price''': The price of the sold product* '''Taxes''': The amount of taxes levied on the product sale* '''Net Revenue''': The net value of the product sale* '''Cost''': The value of the product purchase cost* '''Profit''': Profit obtained from the product sale* '''Avg Price''': The result of the price estimate divided by the quantity* '''%Profit''': Percentage of profit on the product selling price
* '''Annual Information (Top 10)'''
[[File:annual_information.PNG|link=]]
* '''Branch Analysis by Quarter'''
[[File:branch_analysis_quarter.PNG|link=]]
* '''State Analysis'''
[[File:state_analysis.PNG|link=]]
* '''Annual Products Comparison'''
[[File:annual_products_comparison.PNG|link=]]
* '''Customer Ranking'''
[[File:customer_ranking.PNG|link=]]
* '''Orders Monthly Analysis'''
[[File:orders_monthly_analysis.PNG|link=]]