The Course

The Tools that you will be trained in

Microsoft Excel

The industry leader in analysis for decades and the foundation for most company reporting





– IF statements including nested IF statements
– VLOOKUP and XLOOKUP
– Pivot Tables
– Data Cleansing
– VBA

SQL

The most sought-after skill for analysts in the world. Many of my colleagues have spent their entire careers only working with SQL




– Basic Query Structure
– Aggregate functions
– INNER JOIN, LEFT JOIN and RIGHT JOIN
– Window Functions (ROW_NUMBER, LEAD & LAG)
– CTEs
– Subqueries
– Temporary Tables

Power BI

The highest-rated visualisation and reporting platform across all Industries.





– Linking data sources and building star and snowflake data models
– Transforming Data
– Building Visuals and dashboards
– DAX
– M
– Power BI Online administration

Concepts & Theory modules

Knowing how to use the tools is not enough —you need to learn how to think through problems and which tools to use in which situations. This can traditionally only be taught “on the job.”

For the first time, I am able to offer lessons on concepts and theory around data analysis, with a focus on real-world examples from my career history.

I will train you to work through common challenges that appear as part of your role.

I could always spot someone who began working in data fresh from an online BootCamp because their first few months were spent staring in horror at the work that they were expected to do – BootCamps simply do not teach what data looks like “in the real world” since many of them are designed by people who have not worked in this sector in the UK and only make you work on clean, perfect data.

You will be taught how to know what to do from day 1 of your new job, how to break down work into organised steps, how to build solutions and what to expect. I am not just selling you a course for you to study and forget, I am giving you everything you need to thrive from a solid foundation.