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
#[[Help:Octofy: Manage data source|Manage data source]]
#Browser the database
#[[Help:Octofy: Browser the database|Browser the database]]
##Database object explorer
##[[Help:Octofy: Database object explorer|Database object explorer]]
##Search
##[[Help:Octofy: Search|Search]]
##*Search options
##*[[Help:Octofy: Search options|Search options]]
##Column list
##[[Help:Octofy: Column list|Column list]]
##*Column value frequency
##*[[Help:Octofy: Column value frequency|Column value frequency]]
##*Copy column name
##*[[Help:Octofy: Copy column name|Copy column name]]
#Data analysis
#[[Help:Octofy: Data analysis|Data analysis]]
##Analysis types:
#[[Help:Octofy: Query data analysis|Query data analysis]]
##*Category count
##[[Help:Octofy: Add tables views|Add tables or views]]
##*Category sum
##[[Help:Octofy: Preview table or view|Preview table or view]]
##*Category distribution count
##[[Help:Octofy: Join tables|Join tables]]
##*Category distribution sum
##[[Help:Octofy: Select columns|Select columns]]
##Select analysis variables
##[[Help:Octofy: Add query conditions|Add query conditions]]
##Data filter
##[[Help:Octofy: Parse the statement|Parse the statement]]
##Exclude blanks
##[[Help:Octofy: Preview the query data|Preview the query data]]
##Sort
##[[Help:Octofy: Perform data analysis|Perform data analysis]]
##Search the categories
#[[Help:Octofy: Excel file data analysis|Excel file data analysis]]
##Drill down to the records
#[[Help:Octofy: Program options|Program options]]
##Export the results
#Build SELECT statement
##Add tables/views
##Preview tables/views data or check column value frequency
##Join
##Select columns
##Add query conditions
##Parse the statement
##Preview the data
##Perform data analysis
#Excel file data analysis
#Program options

Revision as of 19:54, 26 September 2021

  1. Add data source
  2. Manage data source
  3. Browser the database
    1. Database object explorer
    2. Search
    3. Column list
  4. Data analysis
  5. Query data analysis
    1. Add tables or views
    2. Preview table or view
    3. Join tables
    4. Select columns
    5. Add query conditions
    6. Parse the statement
    7. Preview the query data
    8. Perform data analysis
  6. Excel file data analysis
  7. Program options
Retrieved from "https://www.sherlocksoftwareinc.com/wiki/index.php?title=Help:Octofy:_User_Manual&oldid=37"