Embark on a transformative journey with our online course, taking you from a Data Analytics novice to an intermediate expert!
Learn to collect, transform, organise, and analyse data to make informed decisions. Understand past trends, uncover reasons, predict future occurrences, and strategise accordingly.
Guided by our experienced coaches, you’ll gain essential skills and learn to apply them effectively. Master data-driven decision-making, a crucial asset in today’s business world!
Unlocking data analytics skills opens a world of exciting career opportunities tailored to your aspirations and expertise. Whether you aim to become an analyst, transition into operational or management roles, or advance to a data scientist or engineer, the possibilities are vast.
This course equips you to make data-driven strategic decisions, a highly sought-after skill in any business landscape. Embrace the chance to shape your career and drive impactful change with data!
PLEASE NOTE: This course is designed for individual participants.
If you are interested in scheduling this training for a group of employees, we can arrange a bespoke offering, either remotely or in-person. Please contact Jayne Atkinson, Head of Sales, at jayne.atkinson@activateapprenticeships.co.uk to discuss this further.
What you'll learn
Our comprehensive course is structured into two dynamic elements to guide you from the basics to intermediate data analytics mastery:
Foundation
- Basics of Excel
- Reading data
Intermediate
- Cleaning data in Excel & Power Query
- Lookups & IF statements
- Creating & interpreting tables
- Pivot tables
- Building reports
Join us and transform your skills, making you an invaluable asset!
How you'll learn and be assessed
The course comprises three instructional methods:
- Self-directed Online Learning: Engage with course materials at your own pace, ensuring you complete each section within the allotted duration
- Coaching Sessions: Participate in two 1-hour group coaching sessions with one of our expert coaches
- Validation Session: Conclude the course by presenting your learnings to a coach in a final group session
Assessment will occur as you progress through the online training materials. Participants identified in the initial assessment as possessing basic or intermediate skills will be fast-tracked to the advanced stages. Feedback will be provided during the coaching sessions in weeks 2 and 4. The final assessment will take place during the validation session at the end of the course (week 6).
Entry requirements
You will need access to a computer (laptop or desktop) running Windows or macOS (with a recent operating system) for the duration of the course. Additionally, an active Microsoft 365 subscription, which includes Excel is necessary.
