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.