All

All

All

Digital Course
Finder

All

All

Business Data Analyst Skills Bootcamp

Exeter College

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
Subject area(s)
Data
Course level
Level 3
Course format
Face-to-face (daytime), Online (tutor-led)