1 / 13

S2000 Data Mining Techniques for Efficient Insights

Explore various methods to access S2000 data effectively, including utilizing Crystal Reports, Excel, Word, and Access. Learn how to set up servers, clients, and databases for seamless data mining. Hands-on examples and live demos provided.

ossie
Download Presentation

S2000 Data Mining Techniques for Efficient Insights

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. S2000 Data Mining Presented by: Alan Bird

  2. Today’s Overview

  3. Ways to Get S2000 Data • Inside S2000 • Marketing List Wizard • Crystal Reports • Outside S2000 • Directly accessing the database • Use Excel/Word/Access

  4. Setup • Server Setup • Use Pervasive to Define your database and location • Client Setup • ODBC Administrator • Creates your link to the Server • 64Bit vs. 32Bit Systems

  5. Setup - Server

  6. Setup - Client • Use 32Bit ODBC Admin for Pervasive 10 and Below if your are on a 64Bit Machine: • C:\Windows\SysWOW64\ODBCAD32.EXE • For 32Bit Machines use: • C:\Windows\System32\ODBCAD32.EXE

  7. Setup - Client Add a S2000 Database to your system

  8. Setup - Client Select Pervasive ODBC Client Interface

  9. Setup - Client Name and Locate your Server Database

  10. Mine • I’m ready now what can I do? • Examples and Ideas • Using Excel • Using Word • Using Access

  11. Live Demo • Excel • Customer Count and Sales by Area • Access • Linking for Advanced Queries • Sample Dash Board with Excel

  12. Summary

  13. Questions?

More Related