I. Purpose of construction
a food and beverage group needs to analyze the financial situation of each branch, currently use Excel to store revenue for each region , the income summary data for each month of each region is through a multi-sheet Way Show, as the catering group is a relatively large catering group, many areas have branches. So, just for the income situation, you need to do a lot of Excel to make a summary of the revenue storage. This leads to the query history data is very troublesome, not conducive to the data of the archival regularization, production costs are too high, wasting effective human resources and many other drawbacks, so the use of data analysis system to solve these shortcomings.
two,Business Requirements
1. Overall objectives
The overall objective of the project is to establish a group Data Analysis System , Conduct Business analysis, membership analysis, food analysis, table analysis, employee performance analysis, and report analysis. The system from the food, membership, employee performance and other multi-dimensional analysis of the revenue situation of the store statistics. Through a variety of forms, such as charts, reports and so on, so that the viewer for each income situation has a concise, clear understanding of the development of relevant measures (such as promotion, etc.) to provide a basis for data analysis.
2. Basic Functional Requirements
Basic functional requirements for data analysis systems include:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/78/2D/wKiom1Z3ZlXw667QAACOV9mCiuQ100.png "title=" Picture 1.png "alt=" Wkiom1z3zlxw667qaacov9mciuq100.png "/>
3, other functional requirements
( 1 the client should not need to install the program, maintenance-free, 0 management
The end user of the system does not need to install the application, directly in the browser for data viewing, analysis and other operations, if the software upgrade, do not need to download software and report parameters, directly in the browser update, do not affect the report tasks and data, do not require the user to spend time to maintain, management.
( 2 ) data classification management mechanism
The system involves a number of different departments, the data you see are also different, in order to ensure the security of data, support hierarchical management data mechanism, the system according to the login user's role , automatically locks the range of data that the user accesses to ensure the security of the data.
( 3 using a report-oriented system design, users do not need to master database knowledge
because of the underlying need for data storage, system should be able to be based on the report format designed by the administrator and manage the database to make the database transparent to the user. as end users do not need to understand the report data storage and other knowledge, just care about their report format and reporting scope.
In view of the above functional requirements, the system is mainly developed with Finereport.
Iii. General overview of system construction
1. General Ideas
through Data Analysis System , Analyze and statistic the income of each store , you can quickly see which stores in an area have higher incomes and which stores have lower incomes, so that decision makers can tailor their business, such as which stores offer a special promotion.
2. System Framework
According to the overall design and construction ideas of the system, the application System framework is as follows:
650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M02/78/2C/wKioL1Z3ZQ6TMW6eAAKwdFbn590516.jpg "title=" 1_ copy. jpg "alt=" wkiol1z3zq6tmw6eaakwdfbn590516.jpg "/>
"Case Study" restaurant Business branch financial Data Analysis System solutions: Business Requirements