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
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
Data
Course level
Level 3
Level 3
Course format
Face-to-face (daytime), Online (tutor-led)
Face-to-face (daytime), Online (tutor-led)
Share "Business Data Analyst Skills Bootcamp"
Share on Facebook Share on Twitter Share on WhatsApp Share by email