Beginner friendly100% online, self-paced

Fundamentals of Data Analysis

Advanced Excel, SQL and Power BI for analysing and reporting project data.

What you will learn

  • Analyse project data with Excel and SQL, and build dashboards in Power BI and Tableau.

What you will build

This course feeds the program's Project Performance Dashboard portfolio piece.

Project 01

Analyse project data with Excel and SQL and build a status dashboard in Power BI or Tableau.

Skills shown

  • Excel
  • SQL
  • Power BI
  • Tableau

Skills you'll learn

  • Data analysis
  • Dashboard reporting
  • Microsoft Excel
  • SQL
  • Power BI

Certification pathway

This course prepares fellows for this industry certification. Exams are taken with the certifying body, and exam fees are paid separately.

PMP requires documented experience leading projects as well as 35 hours of project management education. Fellows new to project management usually start with CAPM. The PMP exam content was updated in July 2026 and now places more weight on AI in project work, which this program covers.

Prerequisites and requirements

  • Prior experience

    None. Experience organising work or people helps, but is not required.

  • 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.

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.

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.