Enroll Now
12 monthsBeginner friendly

Turn raw data into decisions people act on.

Learn Excel, SQL, Python, R and Power BI, then tell the story behind the numbers with clear reports and dashboards.

Who this program is for

Career changers

From teaching, finance, healthcare administration, sales or operations who want a structured route into a data analyst role.

Spreadsheet power users

Professionals who already live in Excel and want to work faster and deeper with SQL, Python and dashboards.

Professionals who report on data

Managers, coordinators and specialists who need to analyse results and present them clearly to decision-makers.

What you will learn

  • Clean, organise and analyse data in Excel with formulas, lookups and pivot tables.

  • Write SQL queries to filter, join and summarise data from databases.

  • Use Python to clean, analyse and visualise data with libraries such as pandas.

  • Use R for statistical analysis and data visualisation.

  • Build interactive Power BI dashboards that update as data changes.

  • Apply basic statistics to spot trends, compare groups and avoid misleading conclusions.

  • Tell a clear story with data: choose the right chart, write insights and tailor them to the audience.

  • Document analysis so others can follow, check and repeat it.

What you will build

Fellows finish with five portfolio pieces they can show employers.

Project 01

Clean a messy sales dataset in Excel and build a summary report with pivot tables and charts.

Skills shown

  • Excel
  • Data cleaning
  • Pivot tables

Skills you'll learn

  • Data cleaning
  • Data analysis
  • Querying databases
  • Statistical analysis
  • Data visualisation
  • Dashboard design
  • Data modelling
  • Data storytelling
  • Report writing
  • Documentation
  • Microsoft Excel
  • SQL
  • Python
  • pandas
  • R
  • Power BI
  • Jupyter Notebook

Program outline

  • 5

    courses

  • 5

    projects

  • 12

    months

  1. 01

    Advanced Excel

    $1,000

    Formulas, lookups, pivot tables, data cleaning and charts for analysis.

  2. 02

    SQL

    $1,000

    Querying, filtering, joining and summarising data in relational databases.

  3. 03

    Python & R

    $1,500

    Data analysis, statistics and visualisation in Python and R.

  4. 04

    Power BI

    $1,000

    Data models, measures and interactive dashboards.

  5. 05

    Data Storytelling & Documentation

    $1,000

    Presenting insights clearly and documenting analysis for others.

Certification pathway

The program prepares fellows for these industry certifications. Exams are taken with the certifying body, and exam fees are paid separately.

  • Microsoft

    Microsoft Office Specialist: Excel Associate (MO-210)

    Prepared in

  • Python Institute

    PCEP: Certified Entry-Level Python Programmer

    Prepared in

  • Microsoft

    Microsoft Certified: Power BI Data Analyst Associate (PL-300)

    Prepared in

PL-300 is the most widely recognised of the three for data analyst roles. Most fellows take it after finishing the Power BI course.

Prerequisites and requirements

  • Prior experience

    None. Basic computer skills and comfort with simple maths are enough. No coding background is needed.

  • Language

    Good written and spoken English.

  • Equipment

    A laptop or desktop computer and a reliable internet connection. A phone or tablet alone is not enough for the tools used. Power BI Desktop runs on Windows, so Mac users need a Windows setup or the online version.

How learning works at FairChild

  • Fully online and self-paced

    Study from anywhere, on your own schedule, through the FairChild learning portal.

  • Learn by doing

    Every course ends with practical work, and the projects build a portfolio employers can review.

  • Choose your pace

    Finish in 6 months on the accelerated track or spread the work over 12 months.

  • Join the fellows community

    Connect with other FairChild fellows working through the same courses.

  • Add mentorship and career support

    Pair the program with Guided Mentorship & Career Development, or join through the FairChild Fellowship, for interview preparation and career coaching.

Career outcomes

Graduates are prepared to apply for roles such as:

  • Data Analyst

  • Business Intelligence Analyst

  • Reporting Analyst

  • Power BI Developer (junior)

  • Operations Analyst

  • Marketing or Sales Analyst

Only The Best Brains Teach at FairChild Institute

Our mentors aren't just teachers. They're practitioners solving real problems with data every day.

CRM Platform & Projects

Oluwaseyi Allison

I work in CRM every day. I teach project delivery from the field, not the textbook.

Data Analytics & Business Intelligence

Malik Pelumi Bello

Data and BI are my world. I teach you to make numbers tell a story.

Business analysis

Baba Nureni-Yusuf

BA is where I made my name. I teach the craft and the interview game.

Agile and Scrum Mastery

Babajide Onabajo

Agile is how I run teams. I teach Scrum without the jargon.

Salesforce Service Cloud with Projects

Debo Fafore

I build on Service Cloud. I teach solutions that survive go-live.

Salesforce Essentials

Samson Bavo

Salesforce got me in the door. I teach the essentials that still do.

Salesforce Sales Cloud

Sophie Mokah

I live in Sales Cloud. I teach setups that help teams sell.

Data Analytics & Business Intelligence

Qahhar Okenla

BI is my thing. I teach dashboards people actually open.

Salesforce Experience Cloud

Ogenna Odebatu

Experience Cloud is my space. I teach portals built for real users.

Triple Play Course B - Salesforce Flow Automation Implementations

Niloy Debnath

Flow is what I do. I teach automations that work on day one.

Triple Play Course A - 8+ Salesforce Project Implementation

Oladipo Ojo

8+ projects in. I teach Salesforce how it's done on the job.

Triple Play Course C - Salesforce Admin Platforms Implementations

Olanrewaju Badiru (Ola B)

Admin platforms are my lane. I teach configs built for production.

CRM Platform & Projects

Oluwaseyi Allison

I work in CRM every day. I teach project delivery from the field, not the textbook.

Data Analytics & Business Intelligence

Malik Pelumi Bello

Data and BI are my world. I teach you to make numbers tell a story.

Business analysis

Baba Nureni-Yusuf

BA is where I made my name. I teach the craft and the interview game.

Agile and Scrum Mastery

Babajide Onabajo

Agile is how I run teams. I teach Scrum without the jargon.

Salesforce Service Cloud with Projects

Debo Fafore

I build on Service Cloud. I teach solutions that survive go-live.

Salesforce Essentials

Samson Bavo

Salesforce got me in the door. I teach the essentials that still do.

Salesforce Sales Cloud

Sophie Mokah

I live in Sales Cloud. I teach setups that help teams sell.

Data Analytics & Business Intelligence

Qahhar Okenla

BI is my thing. I teach dashboards people actually open.

Salesforce Experience Cloud

Ogenna Odebatu

Experience Cloud is my space. I teach portals built for real users.

Triple Play Course B - Salesforce Flow Automation Implementations

Niloy Debnath

Flow is what I do. I teach automations that work on day one.

Triple Play Course A - 8+ Salesforce Project Implementation

Oladipo Ojo

8+ projects in. I teach Salesforce how it's done on the job.

Triple Play Course C - Salesforce Admin Platforms Implementations

Olanrewaju Badiru (Ola B)

Admin platforms are my lane. I teach configs built for production.

CRM Platform & Projects

Oluwaseyi Allison

I work in CRM every day. I teach project delivery from the field, not the textbook.

Data Analytics & Business Intelligence

Malik Pelumi Bello

Data and BI are my world. I teach you to make numbers tell a story.

Business analysis

Baba Nureni-Yusuf

BA is where I made my name. I teach the craft and the interview game.

Agile and Scrum Mastery

Babajide Onabajo

Agile is how I run teams. I teach Scrum without the jargon.

Salesforce Service Cloud with Projects

Debo Fafore

I build on Service Cloud. I teach solutions that survive go-live.

Salesforce Essentials

Samson Bavo

Salesforce got me in the door. I teach the essentials that still do.

Salesforce Sales Cloud

Sophie Mokah

I live in Sales Cloud. I teach setups that help teams sell.

Data Analytics & Business Intelligence

Qahhar Okenla

BI is my thing. I teach dashboards people actually open.

Salesforce Experience Cloud

Ogenna Odebatu

Experience Cloud is my space. I teach portals built for real users.

Triple Play Course B - Salesforce Flow Automation Implementations

Niloy Debnath

Flow is what I do. I teach automations that work on day one.

Triple Play Course A - 8+ Salesforce Project Implementation

Oladipo Ojo

8+ projects in. I teach Salesforce how it's done on the job.

Triple Play Course C - Salesforce Admin Platforms Implementations

Olanrewaju Badiru (Ola B)

Admin platforms are my lane. I teach configs built for production.

FAQ

No. Every program starts with the basics and builds up step by step.

Related programs