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

From Sherlock Software
(Created page with "==Octofy User Manual== #Add data source #Manage data source #Browser the database ##Database object explorer ##Search ##*Search options ##Column list ##*Column value frequenc...")
 
m
Line 1: Line 1:
==Octofy User Manual==
#Add data source
#Add data source
#Manage data source
#Manage data source

Revision as of 18:59, 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