1 / 22

Getting Data Out of FASTER : Tips for the New & Experienced

Getting Data Out of FASTER : Tips for the New & Experienced. with Doug Atkins. Getting Data Out of FASTER. Find out how you can get information out of FASTER that will help you make better management decisions.

kalb
Download Presentation

Getting Data Out of FASTER : Tips for the New & Experienced

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Getting Data Out of FASTER:Tips for the New & Experienced with Doug Atkins

  2. Getting Data Out of FASTER Find out how you can get information out of FASTER that will help you make better management decisions. Learn if you’re really getting all the information out of FASTER that you would like to? Discover new ways to get the data out of FASTER.

  3. Agenda • Introductions and Credentials • Definition of Data Mining • Types of Results • Tools for Data Mining • Real-Life Example • How do you analyze the data? • What do you do with the data? • Who should see the data? • Questions & Answers

  4. Introductions and Credentials • Fleet Services Team Leader • FASTER Staff Member for 12 Years • All Script Requests 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: make a miner out of you!

  5. 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.

  6. 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.

  7. 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

  8. Types of Results • Result Sets • Lists • All Assets in Company 001 • Comparisons • Parts Obsolescence • Trends • Asset Historical Cost Per Meter by Month

  9. 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

  10. Tools Require Connectivity • FASTER • OLEDB • Excel, Access, Query Developer Tools • OLEDB, ODBC • TOAD, SQL Plus, SQL Server Management Studio • Native Drivers • Licensed Data Base Software

  11. Database Connectivity • Name of your Database • FasterCS • TNSName • Windows Authentication • User Name and Password • DBA to Create Your Account • Select Permission Only • Reports account

  12. Locating the Data • FASTER Data Dictionaries • http://customer.ccgsystems.com/download-center/manuals-documentation/(requires login/password) • Core FASTER Application • HTML View for Easy Navigation • Tables • FASTER Reports Data Dictionary • HTML View for Easy Navigation • Views and Stored Procedures

  13. Real-Life Examples • Lists • FASTER Search and Query • FASTER Standard Reports • Custom Reports & Queries • How many assets are in the fleet?, in a Department?, in a Class?, in a Shop?, are Take Home Vehicles?, are Off-Road Vehicles? • What is the value of my Inventory? How many brake parts have I issued?, to light duty equipment?, what is the value of Obsolescence?

  14. Real-Life Examples • Comparisons • FASTER Search and Query • FASTER Standard Reports • Custom Reports & Queries • Do I have enough technicians?, enough Bays?, am I stocking the right parts?, do I have adequate staffing in the parts room? • Are my vehicles being under/over utilized?, are there vehicles that should be sending up red flags (CPM/MPG)?, which ones need replacing?

  15. Real-Life Examples • Trends • Cost of PM, by Asset Class, by Year • Let’s Build It • Let’s Analyze It • Let’s Talk about How It Can Help Us Make a Decision • Let’s Take It Home

  16. How to Build a Query • Select • The columns to be selected for the result set. The select list is a series of expressions separated by commas. • All, Distinct, * • Specific Column Names • Formulas • Select EHKey, EHCompany, … • Select Count(EHKey), …

  17. How to Build a Query • From • Specifies the tables, views, and joined tables used in DELETE, SELECT, and UPDATE statements. • Select … From faster.Eheader • Select … From faster.Eheader JOIN faster.EPM on (Eheader.EHUID = EPM.EPEHuid) • Inner (only matches) • Full Outer (All rows) • Left Outer (All matches, includes rows from left) • Right Outer (All matches, includes rows from right)

  18. How to Build a Query • Where • Specifies the condition for the rows returned by a query. Defines the condition to be met for the rows to be returned. There is no limit to the number of conditions. • Select … From … Where • EHeader.EHUID = WHeader.WHEHUID and • Wheader.WHUID = WLabor.WLWHUID and • WLabor.WLRTY like ‘PM%’

  19. How to Build a Query • Group By • Divides a table into groups. Groups can consist of column names or results or computed columns. • Select … From … Where … • Group by EHeader.EHClass, EHeader.EHYear

  20. How to Build a Query • Order By • Specifies the sort for the result set. • Select … From … Where … Group By … • Order By EHeader.EHClass, EHeader. EHYear

  21. Our Query • Select EH… • From EH… • Where faster.EHeader, … • Group BY EHeader.EHClass … • Order BY EHeader.EHClass …

  22. Question & Answer What does your Database need to tell you? Are you asking the right questions?

More Related