Home > Software engineering >  Based on EXCEL ACCESS BI (multidimensional query, data mining and drilling data, the full text retri
Based on EXCEL ACCESS BI (multidimensional query, data mining and drilling data, the full text retri

Time:09-16

[images] :





[download address] :
http://download.csdn.net/download/s200410020305/8232821
[home] :
http://my.csdn.net/s200410020305

[name] : based on BI (data mining and drilling data, multidimensional query) concept design of the personal work management book

[introduction] :
The work management book is based on convenient work at ordinary times, improve the efficiency of the original designed, use from 2011 to now, the job management system "the sweet little tool is another one of my brain, it will help me countless matters assigned by the leadership of the classified according to the progress, will be a mountain of electronic documents by date stored neatly, vague memory let me even for one thing, as long as you describe a probably, will also be able to quickly locate to the things they want to find, this helper will be countless times I out of the amnesia caused by heavy work, and formed a" gifted with photographic memory ", "I'm not afraid because by leaders criticized the" forget items,
2012 project to do because I also began to learn the contents of the full text search, and through their own actual development, the full text retrieval algorithms have deeper understanding, shall be written in PPT, here in the document for your reference as attachment,
Appreciate the CSDN: in software engineering, the source code is the most worthless thing, algorithm and data structure is the most valuable things,

[characteristics] :
1, you can inquire on the "freedom", like the use of baidu GOOGLE using it, enter a few keywords query Spaces separated (middle);
2, record a laundry list of packet classification, please fill in the "task", then fill in the "task progress", easy to browse and query;
3, provide according to the task topic, task schedule, time, and any multidimensional query keywords,

[key] :
1, this system USES EXCEL as a front-end (VBA) development, SQL view as the intermediate BUSINESS processing (filtering, grouping, sorting), ACCESS database as a background, using BI (BUSINESS INTELLIGENCE) theory, set up the relational database model for development;
2, report and input, modify, and delete integrated on the same page, the system not only EXCEL showcases report data, while at the same time allowing new batch records, modify, delete;
3, use similar to baidu, GOOGLE's full text retrieval algorithm, efficient and convenient query technology,

[update] main:
1, add the full-text search engine, you can use baidu, GOOGLE, use this workbook to query;
2, beautify the system interface, increase operation identification,

CodePudding user response:


CodePudding user response:


CodePudding user response:

the original poster is a good man, thanks for sharing

CodePudding user response:

Thanks for sharing knowledge

CodePudding user response:

Thanks for sharing knowledge
  •  Tags:  
  • VBA
  • Related