Help:Octofy: User Manual

From Sherlock Software
Revision as of 19:07, 26 September 2021 by Sherlock (talk | contribs) (Sherlock moved page Help:Octofy User Manual to Help:Octofy: User Manual without leaving a redirect)
  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