Data Analysis Bootcamp for Beginners – Session 9 of 9

Loading Events

« All Events

Data Analysis Bootcamp for Beginners – Session 9 of 9

July 27 @ 6:00 pm - 8:30 pm

Summary:

  • Introducing and using Data Analytics is not just a case of acquiring analytics software. This
    course will provide new or informally trained analysts with the necessary knowledge of data,
    analytics and how these apply to the modern business environment, as well as practical
    analytic and visualisation skills.

Who should attend:

  • New or informally trained analysts

Pre-Requisite:

Good basic Excel knowledge

Content:

  • The language of Data Analysis
  • What is a Data Analyst
  • Understanding data and data sources
  • Characteristics of good data
  • Approaches for data validation and cleaning
  • Awareness of Data Analytic and visualisation software tools
  • Ethical Data Analytics
  • What is Big Data
  • The Data Analysis lifecycle
  • Interpreting and communicating results
  • Use of visualisations and colours

Practical Analytics:

  • Data Filtering / Sorting
  • Expressions / Order of Operations
  • Statistics Terms – Means; Min/Max; SUM; Data Outliers
  • Look Ups; Data Validation; Pivot Tables; Quick Analysis Tool; If / Nested If; Linear Regression;
  • What IF Analysis

Technical Skills learned:

  • Excel Refresher / Advanced Excel
  • Using statistics in Excel
  • Power Bi visualisations

Details

Date:
July 27
Time:
6:00 pm - 8:30 pm
Event Category:
Contact Us