Data Analysis - Excel & Power BI for Junior Analyst

overview

Course Overview

Why Should I Attend the Data Analysis - Excel & Power BI for Junior Analyst Training?

Start Your Career With an Associate Course

This Junior Analyst course provides the fundamental skills required to gather, clean, analyze, and visualize data using common industry tools like Excel, Google Sheets, and Power BI. It is designed to equip participants to perform tasks required in entry-level analyst roles, with a primary focus on setting up analyses and creating basic reports and dashboards.

Career Switch: Give yourself a new start with Data Analysis. This course is your gateway to a high-demand, future-proof career across various industries including finance, tech, healthcare, and e-commerce.
Upgrade Your Skills: Enhance your professionalism with in-demand skills like Excel, SQL, data visualization, dashboard creation, and basic statistical analysis using tools like Power BI, Tableau, and Python.
Improved Earning Potential: Junior Data Analysts in Nigeria earn between ₦200,000 and ₦450,000 monthly, depending on the industry, technical skills, and level of hands-on experience.

Learning Outcomes

What Will You Learn in Our Junior Data Analysis Course?

By the end of the Junior Analyst course, participants will be able to:

Understand core data concepts, the analysis lifecycle, and navigate key tools (Excel, Sheets, Power BI).
Perform essential data setup, cleaning, and manipulation tasks in Excel and Google Sheets using formulas and functions.
Connect to data sources and perform basic data transformations using Power BI's Power Query Editor.
Build simple data models and create reports with standard visuals in Power BI.
Create basic calculated columns/measures and arrange visuals into interactive dashboards.
Interpret basic charts/tables, perform simple descriptive analysis, and export findings from tools.

Curriculum

Module 1: Data Analysis Fundamentals & Tool Setup

Core Data Concepts: Data Types, Databases vs. Spreadsheets

The Data Analysis Lifecycle Stages

Introduction to Excel, Google Sheets, and Power BI Desktop Environments

Setting up Accounts and Navigating Interfaces

Data Privacy and Ethical Considerations Overview

Module 2: Data Setup & Manipulation in Excel/Sheets

Basic Data Entry, Formatting, Sorting, and Filtering

Fundamental Formulas: SUM, AVERAGE, COUNT, IF, Basic Arithmetic

Creating Basic Charts: Bar, Line, Pie Charts

Setting up Structured Data using Tables

Importing Data from CSV and Text Files

Module 3: Setting Up Data Connections & Basic Transformations in Power BI

Connecting Power BI Desktop to Excel, CSV, and other common sources

Introduction to the Power Query Editor Interface

Basic Data Cleaning: Changing Data Types, Removing Columns/Rows, Handling Basic Errors (Nulls), Filtering Data

Module 4: Building Basic Data Models & Reports in Power BI

Basic Data Modeling Concepts: Fact vs. Dimension Tables, Primary/Foreign Keys

Creating Simple Relationships between Tables

Building Reports with Standard Visuals: Tables, Matrices, Cards, Bar/Line/Pie Charts

Basic Formatting of Visuals and Report Pages

Module 5: Creating Basic Calculations & Visualizations

Creating Calculated Columns in Excel/Sheets/Power BI (Simple Formulas)

Introduction to DAX: Creating Basic Measures (SUM, COUNT, AVERAGE) in Power BI

Arranging Visuals to Create Basic Interactive Dashboards/Reports

Module 6: Basic Data Reporting & Interpretation

Reading Basic Charts and Tables Effectively

Simple Descriptive Analysis: Finding Minimums, Maximums, Averages, Counts

Formulating Basic Observations and Summaries from Data

Exporting Reports, Visuals, or Data from Tools (Excel, Power BI)

who attends

Right For You

Is the Junior Data Analysis Training Right for You?

Participants enrolling for this programme will be required to have no prior data analysis experience, but strong computer literacy and familiarity with spreadsheet basics (like navigating cells) are beneficial. A logical mindset and interest in working with data.

Access to a computer capable of running Microsoft Excel/Google Sheets and Power BI Desktop, along with a reliable internet connection.

Requirements:

Individuals with no prior Excel experience but an interest in data analysis
Individuals seeking entry-level roles in data analysis (e.g., Junior Data Analyst, Data Assistant, Reporting Analyst).
Professionals in other fields who need a foundational understanding of data handling, interpretation, and reporting to support decision-making.
Team members who want to improve collaboration with data teams by better understanding data workflows and basic analytical tools.
Career changers looking to transition into the data analytics field with practical, job-ready skills.
Recent graduates aiming to build core competencies in data collection, cleaning, analysis, and visualization to improve employability.

Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.

Key Program Features

Certification

What Are the Benefits of the Data Analysis Certificate?

Acquire essential data analysis skills, including data cleaning, interpretation, visualization, and reporting, through a hands-on learning approach using tools like Excel and Power BI.
Improve your job prospects for entry-level roles such as Junior Data Analyst, Reporting Analyst, or Data Assistant with targeted training and career development support.
Gain valuable real-world experience and verifiable references by participating in an internship of up to four months on actual data analysis projects across various industries.
Establish a solid foundation for career progression and the pursuit of globally recognised certifications like Google Data Analytics, Microsoft Power BI, or IBM Data Analyst, potentially increasing your earning power and expanding your professional opportunities.

teaching team

Meet Your Facilitator(s)

Christian Ozoemene

Data Scientist • Nigeria

M.Sc. in Data Science Management; AWS Certified Solutions Architect (in view); AWS Data Engineer Associate (in view).

Christian Ozoemene is a Data Scientist at Piston & Fusion Business Academy with an M.Sc. in Data Science Management, specializing in Data Analytics, Machine Learning, and AI. He is dedicated to staying at the forefront of the field, pursuing industry-recognized certifications like AWS Certified Solutions Architect and AWS Data Engineer Associate. With proficiency in tools like Python, SQL, Excel, and Power BI, Christian empowers students to confidently tackle data challenges. His real-world experience, including work on credit scoring projects at mdoc, enriches his lessons, bridging theory with practical application. Christian is passionate about nurturing the next generation of data-driven leaders, equipping them with the skills to transform data into actionable business strategies.

Olawande Akinmola

Trainer at Piston and Fusion Business Academy • Nigeria

B.Sc. in Microbiology; certifications in Data Analysis, Financial Analysis, and Financial Modelling (DAFM)

Olawande Akinmola is a Business Intelligence Analyst and facilitator skilled in transforming data into actionable insights. With a B.Sc. in Microbiology and certifications in Data and Financial Analysis, she specializes in SQL, Tableau, and Power BI. With three years of experience, she helps businesses make data-driven decisions through clear, strategic insights. As a facilitator at Piston and Fusion, she empowers professionals with data literacy, making complex information accessible and impactful.

course schedule

The Schedule For This Course

Piston and Fusion offer the Junior Data Analysis Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates for classroom and virtual online class.

Classroom & Virtual

Junior Data Analysis Course Schedule for Lagos, Abuja, & Online

Weekdays

Dates:

8th Sep – 11th Sep, 2025

As of Sat May 17 2025

Days:

Mon – Thu

Time:

8:30am – 3:30pm

Duration:

4 days

Weekends

fees

What It Will Cost

Piston and Fusion offer the Data Analysis Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See fees for classroom and virtual online class.

Standard

₦140,000

Virtual Only

Course Materials

PDF

Certificate

PDF

Manual, Cases & Templates

PDF

Mentorship

Refreshment

Perks

Additional Services

Standard Plus

₦170,000

Virtual Only

Course Materials

PDF

Certificate

PDF

Manual, Cases & Templates

PDF

Mentorship

3 Months

Refreshment

Perks

Additional Services

CV & LinkedIn Profile Development

Exam Application (Only for Certification courses)

Professional

₦210,000

Classroom & Virtual

Course Materials

Print & PDF

Certificate

Manual, Cases & Templates

Mentorship

Refreshment

Teabreak & Lunch

Perks

Souvenir

Notepad & Pen

Additional Services

Professional Plus

₦240,000

Classroom & Virtual

Course Materials

Print & PDF

Certificate

Manual, Cases & Templates

Print & PDF

Mentorship

3 Months

Refreshment

Tea Break & Lunch

Perks

Souvenir

Notepad & Pen

Additional Services

CV & LinkedIn Profile Development

Exam Application (Only for Certification courses)

apply now

Ready to Join the Course?

Talk to the Career Advisor and join the next schedule

How to Apply:

Check the website to select a course of choice and fee.

Pay the registration fee and tuition to P&F account domiciled at First Bank

DETAILS
Account Name: Piston & Fusion Ltd
Account Number: 2015242578
Bank: First Bank of Nigeria

Send your name, phone no, email, training location, amount paid & proof of payment to fees@pistonandfusion.org

Complete the enrollment form ONLY AFTER PAYMENT

CASH PAYMENTS ARE NOT ALLOWED, ALL PAYMENTS MUST BE MADE TO THE COMPANY’S ACCOUNT.

https://www.pistonandfusion.org/enrol-now?type=individual&course=data-analysis

Request a Proposal

Are you a corporate client looking to upskill your team?

To register multiple employees for our courses, please fill out this form to request a proposal.

We’ll provide you with a detailed quote, outlining the costs and benefits of your chosen courses. Once approved, we’ll generate an invoice for payment.

Let’s elevate your team's skills together!

https://www.pistonandfusion.org/enrol-now?type=corporate&course=data-analysis

contact us

Want to Get in Touch?

Individual

+234(0)7063097056 - Erica +234(0)9045518768 - Victor +234(0)7026272420 - Samson info@pistonandfusion.org 122A Obadina Street, Omole Phase 1, Ikeja, Lagos.22 Kumasi Cres, Wuse 2, Abuja 904101, Federal Capital Territory Or fill out our online contact form

Get Free Career Counselling

We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.

Corporate

+234(0)9065510762 - Hope +234(0)7025590901 - Michael info@pistonandfusion.org 122A Obadina Street, Omole Phase 1, Ikeja, Lagos.22 Kumasi Cres, Wuse 2, Abuja 904101, Federal Capital Territory Or fill out our online contact form

Get Free L&D Plan

We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.