16 Weekends Online BootCamp

Data Analytics Career Track

Become a Business Intelligence and Data Analyst. Learn Modern Excel, Power BI and SQL .

Date

Mar 18

Duration

16 Weeks

Weekends

Time

6-8 hrs per week

Projects

5+ portfolio projects

Dotted Hexagon Shape
hexagon
hexagon
Microsoft Excel 2019
MySQL an Open-Source Relational Database Management System
Orange Blur Circle Illustration
Smiling African Entrepreneur Working Online

5.5K+ Enrolled Students

Man on Gray Shirt Portrait
Girl in Floral Dress Posing in a Wheat Field
Portrait of Young plus Size Woman.
Portrait of Woman Smiling
Girl Pets Her Dog at Home on the Couch
Portrait
Blue Pixel Burst

Build real-world, job ready skills

We have structured this program to provide you with the skills, knowledge, and confidence to become a data-driven professional or launch a career in the Data space as a Business or Data Analyst. Our curriculum is challenging and it is designed to equip you with the in-demand skills you need to grow and succeed as a Data Professional.

hexagon
Microsoft Excel 2019
hexagon
hexagon
hexagon
hexagon
MySQL an Open-Source Relational Database Management System
hexagon
Dotted Hexagon Shape
hexagon
Trophy Illustration Sticker

FestMan is trusted by students working in top companies

I just created and designed an interactive dashboard on Power BI from the scratch using different AI/Machine Learning visualizations on Power BI.


Thanks, Thomas Festus Cudjoe, my wonderful instructor, FestMan™ Learning Hub, for the learning platform. It was awesome working with you.

蓝白领英社交媒体icon

Kafayat Bamishigbin

Maths tutor | Graphics designer

I am so grateful to the entire FestMan™ Learning Hub for awarding me a scholarship for their new curated HR analytics course.


The course has expanded my knowledge of data visualization and how to use tooltips to create additional visually appealing insights in your reports.


I enjoyed every bit of the course and would gladly recommend it to anyone aspiring to develop skills in data analytics.

Bright Alorwoyie

Client Delivery and Analytics Manager at SumsureIQ

蓝白领英社交媒体icon

Thanks to Thomas Festus Cudjoe and FestMan™ Learning Hub for the detailed tutorial that guided me to design this Financial Analysis Report with Power BI, It was very helpful.

Richmond Yeboah

National Service Person

蓝白领英社交媒体icon

This was fun!


Thank you FestMan™ Learning Hub for a wonderful learning experience, teaching us how to prepare, organize, model, and visualize data (using excel) to answer business questions.


I cannot wait to share my HR analytics projects (in progress)

Rejoice Gorni

People Partner | HR Business Partner


蓝白领英社交媒体icon

It's been fun and challenging learning with Festman in the second part of the year and their courses have been a huge blessing in improving my data analytics skillset as I transition into the data space through business problem case scenarios.


Thank you very much FestMan™ Learning Hub, and your team for putting this amazing contents together

Victor Ayodeji

Clinical physiologist

蓝白领英社交媒体icon

A Big thanks to FestMan™ Learning Hub for an opportunity to improve my skills in Power BI.


I also appreciate Thomas Festus Cudjoe for an insightful and wonderful session where I learned more on Data modeling, Data analysis, and Data Visualization.

Mary Titus

Financial reporting

/Accounting

蓝白领英社交媒体icon

Thank you FestMan™ Learning Hub for the Python for Data Science fundamentals training.


I learned about NumPy, pandas, concepts such as Dataframe, loops, sets & dictionaries, and functions.


This training is highly recommended. The learning continues with the Bootcamp in 2023.

Ayodeji Popoola

Data Analyst | Trade Finance Officer

蓝白领英社交媒体icon

FestMan™ Learning Hub has good guided projects and courses.


In this guided project, Thomas Festus Cudjoe gives a heuristic teaching experience on creating a financial dashboard in Power BI, highlighting some of the financial metrics and KPIs.

Victor Nyakako

Data Analyst

蓝白领英社交媒体icon

The idea of DAX calculations has always been intimidating for me.


After going through this project with aid of FestMan™ Learning Hub, I finally have an understanding of how DAX and time intelligence calculations are done.

Tafadzwa Chigwada

AWS Certified Cloud Practitioner


蓝白领英社交媒体icon

Become a Data Professional.


  • Data Analyst
  • Data Scientist
  • BI Analyst
  • Business Analyst
  • Data Engineer
  • Financial Analyst


Sign up

Data Analyst

African man wearing virtual reality headset

Business Analyst

Colleagues Looking at Survey Sheet

Data Scientist

BI Analyst

Young Black Woman

Future of Work report by World Economic Forum

According to the Future of Work report by the World Economic Forum, by 2025, 85 million jobs will be displaced while 95 million new roles will emerge.


The roles that will experience a growth in demand include:

  • Data Analysts and Scientists
  • AI and Machine Learning Specialists
  • Big Data Specialists


One thing is common among these roles; they all solve problems using Data.

Get Certified!

Earn your verifiable digital certificate and validate your data analytics and business intelligence skills.

hexagon
Smiling African Entrepreneur Working Online
Abstract Wave Lines

FESTMAN LEARNING HUB

hexagon
hexagon
hexagon
Microsoft Excel 2019
hexagon
hexagon
hexagon
hexagon
MySQL an Open-Source Relational Database Management System
hexagon

FESTMAN LEARNING HUB

hexagon
hexagon
hexagon
hexagon

FESTMAN LEARNING HUB

.

FESTMAN CERTIFICATE
FESTMAN CERTIFICATE
Variation of Stars Illustration Sticker

.

Ribbon Icon

MS EXCEL

Ribbon Icon

MYSQL

Ribbon Icon

POWER BI

Certified Business Intelligence & Data Analyst

ISSUED TO

John Walker

ctfestus

THOMAS FESTUS CUDJOE

FOUNDER - FESTMAN LEARNING HUB

Microsoft MVP | Chartered Accountant

Certificate ID: BNKMYNK18009

hexagon
Smiling Black Man

BootCamp Curriculum

The program's curriculum is challenging, comprehensive, and constantly updated, ensuring you are always learning the most in-demand data analytics skills, techniques, and tools used by Data Analysts. You will learn Modern Excel, Microsoft Power BI, and SQL.

Data Analytics with Microsoft Excel

Calendar Icon

5 weeks

Business Plan illustration

Power BI for Data visualization

Calendar Icon

4 weeks

Project Team illustration

Data Analytics with SQL

4 weeks

Calendar Icon
Teaching illustration

Portfolio Projects

3 weeks

Calendar Icon
Planning Starup illustration

Program Details

Shadow Rounded Square

Next Cohort

Shadow Rounded Rectangle
Date and Time

18

March

Shadow Rounded Rectangle

16 weeks

Saturdays

8:30am - 11:30am

Apply Now

Clock Icon
Shadow Rounded Rectangle

Book a Call

Apply Now

Limited seats

Flexible Plans to fit your budget

Enroll in entire bootcamp or individual course(s)

20% Discount Banner

Early bird closes on Mar 11.

hexagon
Microsoft Excel 2019
hexagon
hexagon
hexagon
hexagon
MySQL an Open-Source Relational Database Management System
hexagon

625

GHS

/ month

500

GHS

/ month

GHS 2,500 - Full Payment ( 🦜Early Bird 2,000)

Get Stated

Include access to:

heavy check mark
heavy check mark
heavy check mark
heavy check mark
heavy check mark

16 weeks of Live training

Downloadable recorded videos and files

Course certificates and badges.

On-demand courses

Online Community

Combo(All courses)

For those who are interested in the entire courses in the Bootcamp.

Individual Courses

For those interested in taking a single course or a few courses rather than enrolling in an entire Bootcamp.

hexagon
Microsoft Excel 2019
hexagon
hexagon
hexagon
hexagon
MySQL an Open-Source Relational Database Management System
hexagon

800

GHS

/ course

640

GHS

/ course

Include access to:

heavy check mark
heavy check mark
heavy check mark
heavy check mark
heavy check mark

Live training

Downloadable recorded videos and files

Course certificates and badges.

On-demand courses

Online Community

Chat for account details if you are in Nigeria

Practical and Job-ready content

The program's curriculum is challenging, comprehensive, and constantly updated, ensuring you are always learning the most in-demand data analytics skills, techniques, and tools used by Data Analysts. You will learn Modern Excel, Microsoft Power BI, and SQL.

Introduction to Data Analytics and Business Intelligence

  • Data analytics and Business Intelligence
  • The Data Job Landscape
  • Types of Data Analytics
  • Application of Data Analytics
  • Tools of Trade for Analysts
  • Data Analytics lifecycle
  • Roles in the Data Space
  • Becoming a BI and Data Analyst - Skills required

Microsoft Excel for Analytics and Reporting

  • Microsoft Excel Fundamentals
  • Microsoft Excel Formulas and Functions
  • Working with Excel Tables
  • Advanced Formulas and Functions - Dyamic arrays


💡 Portfolio Project: Analyzing Data with Excel formulas and Functions


  • Introduction to PivotTables
  • Data visualization and Reporting
  • Advanced PivotTables and Charts
  • Working with Data from multiple sources
  • Data cleaning and Transformation - Power Query
  • Data modeling and DAX - PowerPivot


💡 Portfolio Project: Developing interactive dashboard with Excel.

Final Capstone: Pizza demand case study

SQL for Data Querying and Analytics

  • Introduction to Databases, SQL and RDBMS.
  • Working with Databases, Tables, and Data types
  • SQL Contraints
  • Data Definition Languages
  • Data Querying and Reporting
  • Case Statements
  • Aggregate Functions


💡 Portfolio Projects: Analyzing and querying Data for Business Reports


  • Aggregate Functions - Deep-dive
  • Working with multiple Tables - SQL joins
  • Sub Queries
  • SQL Views
  • Window functions
  • Stored Procedures


💡 Portfolio Projects: Advanced analytics and reporting with SQL

Final Capstone Project: Team Project

Data Analytics and Visualization with Power BI

  • Get started with Microsoft data analytics
  • Prepare data for analysis
  • Data Modeling in Power BI
  • Creating custom business calculations with DAX
  • Time Intelligence Calculations
  • Performing advanced analytics with AI

💡 Portfolio Project: Analyzing HR Data with DAX


  • Visualizing Data in Power BI
  • Reporting and Dashboarding

💡 Portfolio Project: Analyizing Hotel Booking Data for Reporting


  • Creating user-experience designs
  • Sharing and consuming reports


💡 Portfolio Project: Analyzing and developing Financial Analytics Reports

Final Capstone: Team Projects

Join our Learning Community

With the support of a diverse community of mentors and peers, our immersive learning experience will provide you with the skills and support you need to succeed in our data-driven world today.

Sign up

hexagon
Portrait of handsome excited cheerful joyful delightful curi
hexagon
Smiling African Entrepreneur Working Online

Trusted by over 5k students across the globe

5,000+

hexagon
Smiling Black Student with Afro
hexagon
Smiling Black Man

Build real-world, job-ready skills

This Bootcamp focuses on the relevant and in-demand data skills needed to become a world-class Business Intelligence and Data Analyst.

hexagon
Microsoft Excel 2019
hexagon
hexagon
MySQL an Open-Source Relational Database Management System
hexagon
hexagon
hexagon

Dashboard Design

Data Modeling

Data Cleaning

Data Analysis

Visualization

Real-world Projects

Desktop Monitor Icon
hexagon
Microsoft Excel 2019

Analyze and visualize Hotel booking Data

Desktop Monitor Icon
hexagon

HR Analytics using Power BI

Abstract Minimalist Dots Shapes
Desktop Monitor Icon
hexagon

Financial Analytics using Power BI

FestMan Learning Hub is a digital learning platform that provides premium digital skills in Data Science, Business Intelligence, Data Analytics and Financial Modeling.


All rights reserved 2023

蓝白领英社交媒体icon
Simple Facebook Icon
Simple Instagram Icon
Simple Twitter Icon
Simple Viber Icon

LEARNING PATHS


Power BI Track

Microsoft Excel Track

Data Analytics Track

Business Intelligence Track

EXPLORE


Course Catalog

Plans

Live Events

Community