Data Analyst

UK Salary range £25,000 - £50,000

Data Analysts gather, analyse, and interpret complex data. They identify patterns, trends, and insights that drive informed business decisions.

They develop and maintain data models, dashboards, and reports. Strong analytical, problem-solving, and communication skills are essential.

Communal3

Data Analyst

UK Salary range £25,000 - £50,000

Key Skills For Data Analysts

Courses For Data Analysts

Google Sheets Intro course image

Google Sheets Intro

  One day    Classroom    Live Online     Private Options

For complete beginners who want to create sophisticated spreadsheets. Organise your data and share insights with colleagues on the go.

This Google Sheets course will give you the skills to efficiently set up spreadsheets, manage and analyse data, automate tasks, and collaborate effectively with your colleagues for improved productivity and decision-making.

Learn valuable time-saving techniques and shortcuts to navigate and work with data in Google Sheets, enabling you to be more productive and get tasks done more quickly.

  •  Creating and navigating spreadsheets
  •  Data Manipulation
  •  Formulas and Functions
  •  Data Organisation and Presentation
  •  Collaboration and Sharing

  •  

    "The whole process was great. Starting with all the support I received from Marianna to organise all the training for me and my co-workers, and during the training itself with Lynne, which was very helpful and well executed ."

  • More Reviews
Choose Dates & Book
Microsoft Excel : Advanced course image

Microsoft Excel Adv

From £179 + VAT

  One day    Classroom    Live Online     Private Options

Gain the confidence to tackle complex challenges and scenarios in Excel. Learn time-saving hints and tips from professional Microsoft Excel experts.

Learn powerful data analysis techniques, including advanced functions, pivot tables, and data visualisation tools.

Enhance your ability to extract insights and make informed business decisions.

Gain the confidence to tackle complex challenges and scenarios.

Learn techniques to troubleshoot errors and optimise your Excel workbooks.

  •  Expanded functions for advanced calculations
  •  Minimise audit risk with data validation
  •  Analyse data efficiently with Pivot Tables
  •  What If Analysis with Goal Seek and Scenarios
  •  Clever time saving techniques

  •  

    "Peter was a great teacher; he had great patience and took us through everything until we were confident with it. Class sizes were great. Often when too big, it can seem overwhelming to contribute. The time given for tasks was great and the tasks set were easy to understand but also challenging in a good way. Peter kept the sessions light (asked us how we were and made jokes) but also was very informative and attentive. Previously, I had zero understanding or knowledge of InDesign and now I can do considerably a lot more. Very pleased."

  •  

    "This was a really useful course and I appreciated that Deva was really keen to find solutions to all of our questions."

  •  

    "Clear explanations and easy to follow"

  •  

    "The trainer was very knowledgeable and engaging on the subject matter. Real life examples and super helpful"

  •  

    "Lisa was a brilliant teacher. She taught me to speed up my way of work by actually slowing down and reading the ribbons and tasks. The magic button will be a life saver. The food was brilliant and the service is very attentive."

  • More Reviews
Choose Dates & Book
Microsoft Excel : Dashboards course image

Microsoft Excel Dashboards

From £329 + VAT

  One day    Classroom    Live Online     Private Options

Utilise Excel’s dynamic features to create polished dashboards that update seamlessly. Display key metrics and insights all in one place with interactive visualisations.

Our one day course will show you how to create an interactive dashboard that communicates important data, like KPIs, simply and effectively.

You'll learn how to prepare and analyse data, create dynamic data visualisations, and how to add interactive features to your dashboard.

Take this course after completing our Excel : Intermediate class.

  •  Clean and prepare data
  •  Analyse data with formulas and pivot tables
  •  Design visualisations and add interactivity
  •  Test functionality and dynamic features
  •  Prepare your dashboard for sharing

  •  

    "Thoroughly enjoyed the training. Very patient and explained everything in detail."

  •  

    "The instructor was amazing and very knowledgable. He was very patient with me and was considerate that I was using a Mac. Went at a useful pace and asked for constant feedback from us. Would definitely recommend this course to anyone!"

  • More Reviews
Choose Dates & Book
Microsoft Excel : Intermediate course image

Microsoft Excel Intermediate

From £149 + VAT

  One day    Classroom    Live Online     Private Options

Gain the confidence to take on more complicated tasks in Excel. Learn new ways to manipulate data, analyse information, and automate tasks.

Build upon your basic Excel knowledge and master more advanced features and functions.

Learn new techniques to manipulate data, analyse information and automate tasks.

This intermediate level Excel course will also provide you with time-saving tips, tricks, and shortcuts that can streamline your workflow and increase productivity.

  •  Using more advanced formulas
  •  Working with conditional formatting
  •  Efficient worksheet management
  •  Improved data analysis
  •  Streamlined data organisation

  •  

    "Content and clarity of explanations was great, interactivity and class size worked really well"

    Penguin Random House

  •  

    "Enjoyable and useful course in a nice venue. Stress-free"

    Penguin Random House

  •  

    "Lynne was a really clear and approachable trainer."

    National Basketball Association

  •  

    "The course itself flowed very well and Lynne was happy to go over information that I/we had perhaps not fully understood. I feel that I am going home with a lot more Excel knowledge."

  •  

    "Very good flow to the course, easy to follow, the slow build up to making something from scratch was great as was the focusing on the 3 main tools such as select tool, frames and text."

  • More Reviews
Choose Dates & Book
Microsoft Excel : Introduction course image

Microsoft Excel Intro

From £179 + VAT

  One day    Classroom    Live Online     Private Options

The ideal course for beginners who need to get the most from Microsoft Excel. Learn to work efficiently, producing spreadsheets that are clear and easy to understand.

This course provides the perfect introduction for new users of Microsoft Excel.

Learn Excel's powerful tools for organising and analysing data.

Set up and lay out spreadsheets and master fundamental features such as data entry, formatting, calculations, data manipulation and creating basic charts.

Our experts will provide the ideal foundation for using Excel.

  •  Master the Excel interface
  •  Organise and navigate workbooks
  •  Effortlessly layout spreadsheets
  •  Define and create calculations
  •  Present data clearly and beautifully

  •  

    "I am very happy with the center and my course. I have been warmly welcomed on the morning and showned the amenities, after explaining me how the day will go. I was pleased with having good food throuhout the day, the view to the London Bridge, as well as the space and cleanliness of the space. I also enjoy the course. I have always been scared of excel as I am not good in Math but our trainor reassured me and explained me clearly skills I will need for work and also helpful new ones. He was also always ready to help and answer my questions."

    Hachette Partworks

  •  

    "Very good service. lovely view. lovely and friendly staff."

    SHOOTERS HILL SIXTH FORM COLLEGE

  •  

    "Good professional set up with friendly open attitude of tutor and helpful staff."

  •  

    "Great friendly trainer and good content"

  •  

    "Matt was very nice and patient"

  • More Reviews
Choose Dates & Book
Microsoft Excel : VBA course image

Microsoft Excel VBA

  Two day    Classroom    Private Options

Harness the power of VBA to manage large and variable amounts of data. Learn best practice for writing and editing VBA code and improve your data's usability.

This Microsoft Excel and VBA course equips you with the tools and knowledge to harness the full potential of Excel, automate processes and generate insightful reports.

Gain the skills to improve your productivity and efficiency in data analysis, reporting, and decision-making.

  •  Automate tasks with Macros
  •  Create custom functions and procedures
  •  Manipulate objects and properties
  •  Expressions, variables, and functions
  •  Working with forms and controls

  •  

    " Dynamic teachers, hands on, great centre and fab food and drinks! Will be coming back"

  • More Reviews
Choose Dates & Book
PHP : Introduction course image

PHP Intro

  Two day    Classroom    Live Online     Private Options

Learn the essentials of PHP to build dynamic web applications. Master PHP basics and how it integrates with HTML and databases like MySQL.

PHP's versatility, scalability, and extensive feature set make it a popular choice for web development projects of all sizes and complexities.

This course provides an excellent grounding in PHP.

Our experts will give you the skills to create dynamic, interactive websites, handle form submissions, and manage data on the server side.

  •  How HTML and PHP work together
  •  Understand PHP syntax and variables
  •  Explore different datatypes in PHP
  •  Access server variables in PHP
  •  Connect and interact with databases

  •  

    "Friendly approachable, convenient"

  •  

    "Friendly knowledgeable trainers"

  • More Reviews
Choose Dates & Book
Power BI : Business Analytics course image

Power BI Business Analytics

From £399 + VAT

  Two day    Classroom    Live Online     Private Options

Learn to present and visualise data like a pro on this Power Bi course. Master how to create interactive and visually appealing dashboards and reports.

Learn how to connect various data sources, perform data transformations, and create calculated measures on this practical course.

Our experts will give you a deeper understanding of data analysis techniques and cover how to use Power BI's features to produce valuable business insights.

  •  Understand Power BI concepts and features
  •  Connect to various data sources easily
  •  Create visually appealing and interactive visuals
  •  Query and shape your data for analysis
  •  Generate comprehensive reports

  •  

    "It all ran smoothly, the course was very good"

    Ecclesiastical Insurance

  •  

    "Too many to mention!"

  •  

    "Great demos and enjoyable learning."

  •  

    "Fantastic course and really well taught"

  •  

    "Very helpful and explained really well in steps step by step."

  • More Reviews
Choose Dates & Book
Python Introduction course image

Python Intro

From £399 + VAT

  Two day    Classroom    Live Online     Private Options

Learn the basics of programming with Python. Take the first step towards becoming a developer in one of the most versatile and in-demand languages

This course will give you the knowledge, skills, and confidence to use Python effectively.

Python is in high demand across various industries, including web development, data science, machine learning, and automation.

This course is the perfect start for anyone who wants to gain a solid understanding of programming using Python.

  •  Writing clean code
  •  Using Variables and Types
  •  String Manipulation
  •  Functions and Modules
  •  Handling exceptions

  •  

    "The Trainer/Teacher was excellent"

  •  

    "Excellent trainer with lots of knowledge. I felt engaged the whole time."

  •  

    "Simon was wonderful, energetic, patient and clear. Brilliant day and I left feeling I had learnt a lot"

  •  

    "Thorough introduction to lots of indesign tips."

  •  

    "Very patient!"

  • More Reviews
Choose Dates & Book
Report Writing course image

Report Writing

From £329 + VAT

  One day    Classroom    Live Online     Private Options

Learn to write clear, concise reports that convey your message effectively. Discover techniques that will improve the clarity and structure of your reports.

Learn report writing skills to effectively communicate complex information and ideas to a wide range of audiences.

This course will help you develop techniques to organise and structure your reports so that they are easy to understand and get your message across.

  •  Plan effectively for your audience
  •  Structure your writing for clarity
  •  Write concisely for maximum impact
  •  Create clear and effective messages
  •  Edit and proofread for mistake-free work

  •  

    "Our teacher Rosie was absolutely amazing. I feel so inspired by this course and feel ready to build on my writing skills."

  •  

    "Everything! The space feels welcoming and friendly and the views are unbeatable! Eveything is well laid out and there is everything that you need. The staff are all super-friendly and helpful"

    UK Parliament

  •  

    "Amazing- very well structure course, insightful and has left me with top nuggets! The trainer was outstanding and expertise was 10/10."

  •  

    "Clear explanations delivered in an easy to listen way. Knowledgeable trainer"

  •  

    "Explaining things and being patient"

  • More Reviews
Choose Dates & Book
SQL : Introduction course image

SQL Intro

From £329 + VAT

  One day    Classroom    Live Online     Private Options

Master the fundamentals of SQL to work with databases, tables, and queries. Use SQL queries to gain insights into large datasets and make informed business decisions.

Learn the fundamentals of SQL, a widely used language for managing databases, allowing you to interact with and manipulate data effectively.

Gain the skills to efficiently retrieve data from databases allowing you to work with data in a structured and organised manner.

  •  SQL basics for database management
  •  Creating and managing tables efficiently
  •  Inserting, updating, and deleting data
  •  Retrieving and sorting data effectively
  •  Understanding table joins and aggregations

  •  

    "James was a great teacher, very knowledgeable with the subject matter. Thanks"

  •  

    "Patsy was very engaging and had good examples to explain the points being put across. I particularly liked the use of the whiteboard and slides to get over the ideas being presented. Patsy is very personable which allowed for a relaxed atmosphere to learn in."

  •  

    "Trainer was great, really informative and clear. Good time spent practicing in addition to learning. Would definitely recommend!"

  •  

    "Very knowledgeable and answered all our queries with a clear and supportive response."

  • More Reviews
Choose Dates & Book
XML : Introduction course image

XML Intro

  Two day    Classroom    Live Online     Private Options

Gain valuable, practical XML skills for web development and data integration. Learn how to code XML documents for a wide variety of data exchange applications.

The ideal course for those who want to master the power and capabilities of XML.

Understand how XML allows you to define your data's structure, making it easier to manage and exchange information between different systems and platforms.

  •  How XML enables structured data organisation
  •  Master well-formed and valid documents
  •  Understand XML namespaces and entities
  •  Create XML sitemaps for SEO benefits
  •  Explore XSLT and template rules

  •  

    "Passing across information in an easily digestable way. Very friendly and approachable staff."

  •  

    "Overall I thought this was a great intro training and has given me tools that I can now go away and practice to become more efficient in after effects."

  •  

    "The tutor was very good, really easy to follow"

  • More Reviews
Choose Dates & Book