Difference between revisions of "Help:Octofy: User Manual"

From Sherlock Software
m
m
Line 1: Line 1:
#[[Help:Octofy:Add data source]]Add data source
#[[Help:Octofy:Add data source|Add data source]]
#Manage data source
#Manage data source
#Browser the database
#Browser the database

Revision as of 19:04, 26 September 2021

  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