Assessment: Data Analysts
IT Skills assessment for Data Analysts, Business Analysts
Data analysis skills are very important qualifications for the business world and this is just one of the reasons why the demand for such specialized executives is growing.
Depending on the size of the enterprise, executives involved in data analysis may form the entire department by themselves, have an assistant or even be part of a group of specialized executives / associates.
The day-to-day responsibilities of the people holding these positions involve:
- Conducting surveys and analyzing data for decision making
- Removing corrupted data
- Controlling of cashflows, expenses, budget management
- Presenting ideas/strategies
- Preparing and distributing financial, statistical etc. data
In order to perform their duties properly, these executives must know very well how to operate various applications so as to produce the desired result.
Job positions with similar typical skills
Jobs with similar formal qualifications include: Data analysts, Business analysts, Business systems analysts, Process analysts, Enterprise analysts, Functional analysts.
What does TEST4U recommend?
These jobs require excellent knowledge of operating a variety of applications. For a clearer result and a better picture, we suggest the assessing the candidates’ skills in the applications:
- Advanced Functions
(AND, IF, OR, VALUE, IFERROR, WORKDAY.INTL, DAYS, DATEDIF, INDEX, MATCH, DAY MONTH, DATE, NETWORKDAYS) - Statistical and Financial Functions
(COUNTIFS, AVERAGEIF, IRR, IPMT) - Data and Chart Management
(Duplicate values, modify charts, scenarios, goal seek) - Advanced Charts and Pivot Tables
(Pivot tables and charts, advanced charts) - Business Modelling and Statistical Analysis
(TRIMMEAN, GEOMEAN, AVERAGE, MEDIAN, TREND, solver add-in, Analysis ToolPak)
- Formatting
(Styles, paragraph settings, wrapping style, picture layout) - Referencing and Columns
(Columns, table of contents, bookmarks, captions) - Enhancing Productivity
(Text to table, table to text, table formulas, sections, macros, mail merging) - Collaborative Editing and Fields
(Insert and modify fields, track changes, document protection)
- Managing Presentations
(Slide master, presentation settings, custom presentation, layout creation) - Formatting
(Themes, text, shapes and pictures formatting) - Charts and Diagrams
(SmartArt, convert list to SmartArt, create modify and animate chart) - Graphical Objects and Multimedia
(Alternative text, animation, distribution, position, cropping, multimedia settings)
- Mail Creation
- Mail Organizing
- Outlook Settings and Printing
- Calendar
- Contacts
- Mail Management
The assessment uses Microsoft Office 2019
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office:
Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.