Skills Bootcamp – Data Analysis

The course is one day per week over 12-16 weeks with a coaching and mentoring session available on the same day to support your professional development.

Induction, the first week of each module, and graduation week will be held on site at Exeter College.

The second week of each module will be taught live online using the Microsoft Teams platform, with the option to attend in person if you prefer.

During the coaching and mentoring sessions there will be progress reviews, an opportunity to further discuss the content of the programme, as well as focusing on Individual Professional Development, reflecting on skills development and individual target setting, and supporting those applying for a change of job role.

During the course you will create an online portfolio of work to showcase your development.

In the final week of the programme there will be interview preparation, final portfolio feedback, visiting speaker talks and graduation!

Module 1: Beginners Databases and SQL
Target Skills

• Introduction to relational databases
• Basics of SQL
• An introduction to SQL server

Module 2: Essential Statistics
Target Skills

• Introduction to Excel
• Calculating and interpreting summary statistics
• Visualising data

Module 3: Advanced Excel
Target Skills

• Using statistical functions in Excel
• Using pivot tables, Goal Seek, Lookups

Module 4: Introduction to Forecasting and Core Deliverables
Target Skills

• Introduction to time series
• Introduction to forecasting in Excel
• Core deliverables – presenting to project sponsors or analysts

Module 5: Business applications
Target Skills

• Introduction to Power BI
• Statistics with business applications

The following entry criteria must be fulfilled:

• You are 19 years or over
• You live in Devon or Cornwall
• You have the right to work in the UK
• You have lived in the UK or EU/EAA for the last 3 years or have a residency status that makes you exempt from this rule
• English skills including written/spoken required with Level 1 being the minimum
• You have not completed another Skills Bootcamp in this current financial year
• You need to be in employment. If you are fully employed, your employer will be asked to pay a contribution. If you are part-time employed, funding will depend on your circumstances
• You are committed to participating in delivery sessions for 12-16 weeks

All applicants will be assessed at interview.

The new Digital and Data Centre at Exeter College provides a nationally significant and prestigious digital learning centre in the heart of the city. Complete with digital learning laboratories, state-of-the-art IT suites and interactive seminar spaces, learners have access to cutting edge equipment to help gear them to move directly in to industry or further study.