2010.Atkins.Data-Mining Faster英文资料.ppt

Question Answer What does your Database need to tell you? Are you asking the right questions? Data Mining Douglas C. Atkins, OCP FASTER Staff: 1998 – 2010 Customer Takeaway Description Best Suited for system administrators, fleet managers, fleet analysts and supervisors Morning Session.? How to ask your database the right questions / Using FASTER, Excel and other query related tools to get info out of FASTER Agenda Introductions and Credentials Definition of Data Mining Types of Results Tools for Data Mining Real-Life Examples How, What, When, Who, Why Build data queries to take home Questions Answers Introductions and Credentials Fleet Services Team Leader FASTER Staff Member for 12 Years All Script Requests / Conversions Go through FS Oracle OCP, MSSQL DBA Training Worked with you and your staff learning fleet during my tenure, never worked in the industry, here’s my fleet … Goal: “Get some data out”! Data Mining: What Is It? The process of extracting patterns from data. Knowing what to ask. Knowing how to ask. Knowing how to present the data. Educating Our Consumers There is a tendency for insufficiently knowledgeable consumers of the results to attribute magical abilities to data mining, treating the technique as a sort of all-seeing crystal ball. Sample Set vs. Entire Population The discovery of a particular pattern in a particular set of data does not necessarily mean that pattern is representative of the whole population from which that data was drawn. Hence, an important part of the process is the verification and validation of patterns on other samples of data Types of Results Result Sets Lists All Assets in Company 001 Comparisons Parts Obsolescence Trends Asset Historical Cost Per Meter by Month Tools for Data Mining FASTER Excel Access Business Objects (Crystal Reports) SQL (Structured Query Language) FSQL: FASTER TOAD, SQL Developer: Oracle or Microsoft SQL Plus: Oracle SQL Server Management Studio Express: Microsoft Database Connectivity Name