Help:Octofy: User Manual

From Sherlock Software
Revision as of 18:59, 26 September 2021 by Sherlock (talk | contribs)
  1. Add data source
  2. Manage data source
  3. Browser the database
    1. Database object explorer
    2. Search
      • Search options
    3. Column list
      • Column value frequency
      • Copy column name
  4. Data analysis
    1. Analysis types:
      • Category count
      • Category sum
      • Category distribution count
      • Category distribution sum
    2. Select analysis variables
    3. Data filter
    4. Exclude blanks
    5. Sort
    6. Search the categories
    7. Drill down to the records
    8. Export the results
  5. Build SELECT statement
    1. Add tables/views
    2. Preview tables/views data or check column value frequency
    3. Join
    4. Select columns
    5. Add query conditions
    6. Parse the statement
    7. Preview the data
    8. Perform data analysis
  6. Excel file data analysis
  7. Program options