Configure
Displays options to open Tally, create Company Info and to perform some of the key functions in
Background.
Documents
Creates Log of Excel files, Activities and provides Test data.
Profile
Displays master info from Tally of company, accounting, inventory, cost centre, compliances &
payroll and ready-made queries for specific master info.
Accounting
Displays transactions of accounting based on selected criteria, ledger vouchers, cash and bank
transactions and master data of accounting from Tally.
Inventory
Displays inventory transactions and master data from Tally.
Cost Centre
Displays cost centre transactions and master data including category-wise, ledgerwise and cost
centre-wise breakup reports from Tally.
Analyse
Displays information from Tally and compliance features including exceptions. Provides overall
statistics and option to validate GSTIN/Patterns of Ids and generate trendline reports.
Payroll
Displays payroll transactions and master data including salary and employee details from Tally.
Reports
Displays information from Registers of Sales, Purchase and Journal.
Curate Data
Transform data in a standard structure to be usable for data analysis as required to ensure that
data is formatted & purified for use in data analytics.
Profile Data
Analyse the data to get an overall perspective of data. Validate data at a macro level to assess
whether the data is correct and complete.
Analyse Data
Examine the data in details to discover essential features by breaking data into specific components
by Grouping, Identifying & Reviewing.
Investigate Data
Observe or query the data in details through: Systematic examination, Make a detailed inquiry or
search And Discover facts & insights to arrive at a conclusion.
Relate
Provides functions to join, append or compare data in two worksheets on specific criteria. It also
has functions for 3-way matching & consolidate columns.
Sampling
Extract specific samples from the population based on specified criteria.
Utilities
Provides unique functions which complement and enhance the use of Excel and are great time-savers.
Document
Documentation refers to recording critical steps of data analytics. The functions in this panel help
document the steps used during data analytics.
Tools
Tools provides functions to rerun tasks performed, perform last, performed task and Search & Run
specific functions.