Data Analyst ICT Professionals
SaveWhat Does a Data Analyst Do?
Data analysts import, inspect, clean, transform, validate, model, or interpret collections of data with regard to the business goals of the company. They ensure that the data sources and repositories provide consistent and reliable data. Data analysts use different algorithms and IT tools as demanded by the situation and the current data. They might prepare reports in the form of visualisations such as graphs, charts, and dashboards.
Resource recommendations may include affiliate links. Learn more
Business Intelligence
The tools used to transform large amounts of raw data into relevant and helpful business information.
These are common skills for this role, based on a European framework. Requirements vary between jobs, including in the UK. Real-world experience matters more than ticking every box - use this as a guide, not a checklist.
Skills You Need to Become a Data Analyst
Essential Skills
Essential Skills
-
EssentialBusiness Intelligence knowledge
The tools used to transform large amounts of raw data into relevant and helpful business information.
Recommended Books
5 books -
EssentialVisual Presentation Techniques knowledge
The visual representation and interaction techniques, such as histograms, scatter plots, surface plots, tree maps and parallel coordinate plots, that can be used to present abstract numerical and non-numerical data, …
-
EssentialInformation Extraction knowledge
The techniques and methods used for eliciting and extracting information from unstructured or semi-structured digital documents and sources.
Recommended Books
1 book -
EssentialUnstructured Data knowledge
The information that is not arranged in a pre-defined manner or does not have a pre-defined data model and is difficult to understand and find patterns in without using techniques …
-
EssentialInformation Structure knowledge
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
Recommended Books
1 book -
EssentialData Models knowledge
The techniques and existing systems used for structuring data elements and showing relationships between them, as well as methods for interpreting the data structures and relationships.
Recommended Books
1 book -
EssentialData Quality Assessment knowledge
The process of revealing data issues using quality indicators, measures and metrics in order to plan data cleansing and data enrichment strategies according to data quality criteria.
-
EssentialInformation Confidentiality knowledge
The mechanisms and regulations which allow for selective access control and guarantee that only authorised parties (people, processes, systems and devices) have access to data, the way to comply with …
Recommended Books
1 book -
EssentialData Mining knowledge
The methods of artificial intelligence, machine learning, statistics and databases used to extract content from a dataset.
No book recommendations available yet.
-
EssentialDocumentation Types knowledge
The characteristics of internal and external documentation types aligned with the product life cycle and their specific content types.
No book recommendations available yet.
-
EssentialInformation Categorisation knowledge
The process of classifying the information into categories and showing relationships between the data for some clearly defined purposes.
No book recommendations available yet.
-
EssentialQuery Languages knowledge
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
No book recommendations available yet.
-
EssentialResource Description Framework Query Language knowledge
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).
No book recommendations available yet.
-
EssentialStatistics knowledge
The study of statistical theory, methods and practices such as collection, organisation, analysis, interpretation and presentation of data. It deals with all aspects of data including the planning of data …
No book recommendations available yet.
-
EssentialApply Statistical Analysis Techniques skill
Use models (descriptive or inferential statistics) and techniques (data mining or machine learning) for statistical analysis and ICT tools to analyse data, uncover correlations and forecast trends.
Course recommendations coming soon.
-
EssentialDefine Data Quality Criteria skill
Course recommendations coming soon.
-
EssentialExecute Analytical Mathematical Calculations skill
Apply mathematical methods and make use of calculation technologies in order to perform analyses and devise solutions to specific problems.
Course recommendations coming soon.
-
EssentialManage Data skill
Administer all types of data resources through their lifecycle by performing data profiling, parsing, standardisation, identity resolution, cleansing, enhancement and auditing. Ensure the data is fit for purpose, using specialised …
Course recommendations coming soon.
-
EssentialPerform Data Mining skill
Explore large datasets to reveal patterns using statistics, database systems or artificial intelligence and present the information in a comprehensible way.
Course recommendations coming soon.
-
EssentialAnalyse Big Data skill
Collect and evaluate numerical data in large quantities, especially for the purpose of identifying patterns between the data.
Course recommendations coming soon.
-
EssentialCollect ICT Data skill
Gather data by designing and applying search and sampling methods.
Course recommendations coming soon.
-
EssentialEstablish Data Processes skill
Use ICT tools to apply mathematical, algorithmic or other data manipulation processes in order to create information.
Course recommendations coming soon.
-
EssentialHandle Data Samples skill
Collect and select a set of data from a population by a statistical or other defined procedure.
Course recommendations coming soon.
-
EssentialImplement Data Quality Processes skill
Apply quality analysis, validation and verification techniques on data to check data quality integrity.
Course recommendations coming soon.
-
EssentialIntegrate ICT Data skill
Combine data from sources to provide unified view of the set of these data.
Course recommendations coming soon.
-
EssentialInterpret Current Data skill
Analyse data gathered from sources such as market data, scientific papers, customer requirements and questionnaires which are current and up-to-date in order to assess development and innovation in areas of …
Course recommendations coming soon.
-
EssentialNormalise Data skill
Reduce data to their accurate core form (normal forms) in order to achieve such results as minimisation of dependency, elimination of redundancy, increase of consistency.
Course recommendations coming soon.
-
EssentialPerform Data Cleansing skill
Detect and correct corrupt records from data sets, ensure that the data become and remain structured according to guidelines.
Course recommendations coming soon.
Optional Skills (5 of 17 displayed)
-
OptionalSPARQL knowledge
The computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation …
Recommended Books
2 books -
OptionalWeb Analytics knowledge
The characteristics, tools and techniques for measurement, collection, analysis and reporting of web data to get information on the users' behaviour and to improve the performance of a website.
-
OptionalXquery knowledge
The computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation …
-
OptionalN1QL knowledge
The computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Couchbase.
-
OptionalCloud Technologies knowledge
The technologies which enable access to hardware, software, data and services through remote servers and software networks irrespective of their location and architecture.
Recommended Books
3 books -
OptionalData Storage knowledge
The physical and technical concepts of how digital data storage is organised in specific schemes both locally, such as hard-drives and random-access memories (RAM) and remotely, via network, internet or …
Recommended Books
1 book -
OptionalLINQ knowledge
The computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
Recommended Books
2 books -
OptionalLDAP knowledge
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
Recommended Books
2 books -
OptionalInformation Architecture knowledge
The methods through which information is generated, structured, stored, maintained, linked, exchanged and used.
No book recommendations available yet.
-
OptionalMDX knowledge
The computer language MDX is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
Recommended Books
1 book -
OptionalDatabase knowledge
The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.
No book recommendations available yet.
-
OptionalOnline Analytical Processing knowledge
The online tools which analyse, aggregate and present multi-dimensional data enabling users to interactively and selectively extract and view data from specific points of view.
No book recommendations available yet.
-
OptionalDeliver Visual Presentation Of Data skill
Create visual representations of data such as charts or diagrams for easier understanding.
Course recommendations coming soon.
-
OptionalReport Analysis Results skill
Produce research documents or give presentations to report the results of a conducted research and analysis project, indicating the analysis procedures and methods which led to the results, as well …
Course recommendations coming soon.
-
OptionalCreate Data Models skill
Use specific techniques and methodologies to analyse the data requirements of an organisation's business processes in order to create models for these data, such as conceptual, logical and physical models. …
Course recommendations coming soon.
-
OptionalGather Data For Forensic Purposes skill
Collect protected, fragmented or corrupted data and other online communication. Document and present findings from this process.
Course recommendations coming soon.
-
OptionalManage Data Collection Systems skill
Develop and manage methods and strategies used to maximise data quality and statistical efficiency in the collection of data, in order to ensure the gathered data are optimised for further …
Course recommendations coming soon.